Related products
$72.00 each
Chrome Diopside, Moonstone, and Green Amethyst Latch-Back Earrings
MWJ28AMG
4 items in stock
Joomla! Version | 5.2.3 |
PHP Version | 8.3.17 |
Identity | guest |
Response | 200 |
Template | g5_helium |
Database |
|
1 x afterRender (569.09KB) (23.58%) | 118ms |
1 x afterInitialise (2.92MB) (20.11%) | 101ms |
1 x afterRenderRawModule mod_hikashop (Related products) (2.59MB) (17.11%) | 85.81ms |
1 x beforeRenderRawModule mod_custom (Our Friends) (1.74MB) (12.14%) | 60.88ms |
1 x afterRoute (2.67MB) (10.73%) | 53.79ms |
1 x afterDispatch (56.24KB) (2.77%) | 13.91ms |
1 x afterRenderRawModule mod_custom (Signup For Our Newsletter) (567.3KB) (2.58%) | 12.96ms |
1 x beforeRenderRawModule mod_gantry5_particle (Menu Search) (922.28KB) (2.26%) | 11.32ms |
1 x beforeRenderRawModule mod_gantry5_particle (Topbar Account) (602.45KB) (2.17%) | 10.88ms |
1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (283.66KB) (1.48%) | 7.40ms |
1 x afterRenderModule mod_hikashop (Related products) (99.84KB) (0.87%) | 4.39ms |
1 x afterRenderRawModule mod_hikashop_cart (HikaShop Cart Module) (53.06KB) (0.5%) | 2.51ms |
1 x afterRenderRawModule mod_login (My Account) (53.57KB) (0.48%) | 2.40ms |
1 x beforeRenderRawModule mod_login (My Account) (126.68KB) (0.44%) | 2.19ms |
1 x beforeRenderRawModule mod_hikashop_cart (HikaShop Cart Module) (55.05KB) (0.33%) | 1.68ms |
1 x beforeRenderRawModule mod_custom (Signup For Our Newsletter) (19.49KB) (0.3%) | 1.52ms |
1 x afterLoad (110.8KB) (0.28%) | 1.42ms |
1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (11.57KB) (0.26%) | 1.28ms |
1 x afterRenderRawModule mod_gantry5_particle (Menu Search) (8.23KB) (0.23%) | 1.13ms |
1 x afterRenderRawModule mod_custom (Our Friends) (4.48KB) (0.15%) | 736μs |
1 x beforeRenderRawModule mod_hikashop (Related products) (49.72KB) (0.12%) | 582μs |
1 x afterRenderModule mod_custom (Signup For Our Newsletter) (8.5KB) (0.11%) | 538μs |
1 x beforeRenderComponent com_hikashop (33.18KB) (0.1%) | 526μs |
1 x beforeRenderRawModule mod_hikashop_filter (Narrow Your Choices) (91.67KB) (0.1%) | 507μs |
1 x afterRenderModule mod_login (My Account) (10.92KB) (0.1%) | 495μs |
1 x afterRenderModule mod_gantry5_particle (Topbar Account) (19KB) (0.09%) | 466μs |
1 x afterRenderRawModule mod_gantry5_particle (Topbar Account) (80.17KB) (0.09%) | 440μs |
1 x afterRenderModule mod_gantry5_particle (Menu Search) (31.24KB) (0.08%) | 386μs |
1 x afterRenderModule mod_custom (Our Friends) (44.14KB) (0.07%) | 355μs |
1 x afterRenderModule mod_hikashop_cart (HikaShop Cart Module) (5.91KB) (0.06%) | 305μs |
1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.92KB) (0.06%) | 302μs |
1 x afterRenderRawModule mod_hikashop_filter (Narrow Your Choices) (3.5KB) (0.05%) | 245μs |
1 x afterRenderModule mod_hikashop_filter (Narrow Your Choices) (2.48KB) (0.03%) | 166μs |
1 x afterRenderComponent com_hikashop (52.73KB) (0.02%) | 95μs |
1 x beforeRenderModule mod_custom (Our Friends) (720B) (0%) | 19μs |
1 x beforeRenderModule mod_custom (Signup For Our Newsletter) (736B) (0%) | 18μs |
1 x beforeRenderModule mod_hikashop (Related products) (720B) (0%) | 10μs |
1 x beforeRenderModule mod_login (My Account) (720B) (0%) | 8μs |
1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%) | 7μs |
1 x beforeRenderModule mod_gantry5_particle (Menu Search) (720B) (0%) | 7μs |
1 x beforeRenderModule mod_hikashop_cart (HikaShop Cart Module) (736B) (0%) | 7μs |
1 x beforeRenderModule mod_gantry5_particle (Topbar Account) (736B) (0%) | 6μs |
1 x beforeRenderModule mod_hikashop_filter (Narrow Your Choices) (736B) (0%) | 6μs |
SELECT @@SESSION.sql_mode;
137μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308CopySELECT `data`
FROM `m37h2_session`
WHERE `session_id` = ?
192μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250CopySELECT `session_id`
FROM `m37h2_session`
WHERE `session_id` = :session_id LIMIT 1
141μs1.3KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `m37h2_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
2.2ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `id`,`rules`
FROM `m37h2_viewlevels`
147μs976B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `m37h2_usergroups` AS `a`
LEFT JOIN `m37h2_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
223μs1.34KBParams/libraries/src/Access/Access.php:868CopySELECT `value`
FROM `m37h2_admintools_storage`
WHERE `key` = 'cparams'
154μs536B/administrator/components/com_admintools/src/Helper/Storage.php:120CopySELECT `option`,`view`,`query`
FROM `m37h2_admintools_wafexceptions`
106μs640B/plugins/system/admintools/src/Utility/Cache.php:196CopySELECT `params`
FROM `m37h2_extensions`
WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'
242μs1.15KB/plugins/system/admintools/src/Utility/RescueUrl.php:324CopySELECT manifest_cache FROM m37h2_extensions WHERE element = 'com_logman'
254μs536B/plugins/koowa/logman/logman.php:153CopySELECT `params`
FROM `m37h2_extensions`
WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'
318μs536B/plugins/system/admintools/src/Utility/RescueUrl.php:324CopySELECT *
FROM `m37h2_admintools_ipautoban`
118μs656B/plugins/system/admintools/src/Utility/Cache.php:126CopySELECT `ip`
FROM `m37h2_admintools_ipblock`
92μs520B/plugins/system/admintools/src/Utility/Cache.php:136CopySELECT *
FROM `m37h2_admintools_storage`
WHERE `key` LIKE 'timestamp_%'
151μs592B/plugins/system/admintools/src/Feature/Base.php:253CopySELECT `source`,`dest`,`keepurlparams`
FROM `m37h2_admintools_redirects`
WHERE `published` = 1
ORDER BY `ordering` ASC
289μs640B/plugins/system/admintools/src/Utility/Cache.php:162CopySELECT *
FROM m37h2_rsform_config
177μs1.19KB/administrator/components/com_rsform/helpers/config.php:52CopySELECT * FROM m37h2_hikashop_config
860μs381.88KB/administrator/components/com_hikashop/classes/config.php:16CopySET sql_mode=(SELECT REPLACE(REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''), 'STRICT_TRANS_TABLES', ''));
85μs0B/administrator/components/com_hikashop/helpers/helper.php:3561CopySELECT product_id FROM m37h2_hikashop_product WHERE product_alias = 'iolite-and-lapis-latch-back-earrings'
4.67ms536B/components/com_hikashop/router.php:363CopySELECT product_id FROM m37h2_hikashop_product WHERE product_alias = 'category_pathway-17'
4.43ms520B/components/com_hikashop/router.php:363CopySELECT * FROM m37h2_hikashop_product WHERE product_alias REGEXP '^ *p?category_pathway.+17 *$' OR product_name REGEXP '^ *p?category_pathway.+17 *$'
6.7ms5.48KB/components/com_hikashop/router.php:380CopySELECT product_id FROM m37h2_hikashop_product WHERE product_alias = 'related_product-14916'
4.44ms520B/components/com_hikashop/router.php:363CopySELECT * FROM m37h2_hikashop_product WHERE product_alias REGEXP '^ *p?related_product.+14916 *$' OR product_name REGEXP '^ *p?related_product.+14916 *$'
7.1ms5.48KB/components/com_hikashop/router.php:380CopySELECT `option`,`view`,`task`,`query`,`query_type`,`query_content`,`verb`,`application`
FROM `m37h2_admintools_wafblacklists`
WHERE `enabled` = 1
200μs976B/plugins/system/admintools/src/Utility/Cache.php:182CopySELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM m37h2_template_styles AS s
WHERE s.client_id = 0 AND s.template = 'g5_helium'
ORDER BY s.id
343μs784B/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69CopySELECT DISTINCT a.*
FROM `m37h2_ampz` AS a LIMIT 20
172μs640B/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT product.*, product_category.product_category_id, product_category.category_id, product_category.ordering FROM m37h2_hikashop_product AS product LEFT JOIN m37h2_hikashop_product_category AS product_category ON product.product_id = product_category.product_id WHERE (product.product_id = 15360) AND ((product.product_access = 'all' OR product.product_access LIKE '%,9,%')) LIMIT 1
590μs21.84KB/components/com_hikashop/views/product/view.html.php:1458CopySELECT * FROM m37h2_modules WHERE id IN (155,0) AND language IN ('*', '', 'en-GB')
351μs2.41KB/administrator/components/com_hikashop/helpers/module.php:123CopySELECT cart.cart_id FROM m37h2_hikashop_cart AS cart WHERE (cart.cart_type = 'cart') AND (cart.session_id = 'nuedh7da2q0oabcjq8smgnia5i') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
249μs520B/administrator/components/com_hikashop/classes/cart.php:69CopySELECT * FROM m37h2_hikashop_currency WHERE currency_id IN (2)
157μs1.44KB/administrator/components/com_hikashop/classes/currency.php:2019CopyUPDATE m37h2_hikashop_product SET product_hit = product_hit + 1, product_last_seen_date = 1739629595 WHERE product_id = 15360
144μs48B/administrator/components/com_hikashop/classes/product.php:4264CopySELECT p.* FROM m37h2_hikashop_product_related AS pr LEFT JOIN m37h2_hikashop_product AS p ON pr.product_related_id = p.product_id WHERE (pr.product_id = 15360) AND (pr.product_related_type = 'options') AND (p.product_published = 1) AND ((p.product_sale_start = '' OR p.product_sale_start <= 1739629595)) AND ((p.product_sale_end = '' OR p.product_sale_end > 1739629595)) AND ((p.product_access = 'all' OR p.product_access LIKE '%,9,%')) ORDER BY pr.product_related_ordering ASC, pr.product_related_id ASC
440μs5.44KB/components/com_hikashop/views/product/view.html.php:1576CopySELECT p.*, pr.product_related_quantity FROM m37h2_hikashop_product_related AS pr INNER JOIN m37h2_hikashop_product AS p ON pr.product_related_id = p.product_id WHERE pr.product_id = 15360 AND pr.product_related_type = 'bundle' ORDER BY pr.product_related_ordering ASC, pr.product_related_id ASC
476μs8.02KB/components/com_hikashop/views/product/view.html.php:1593CopySELECT * FROM m37h2_hikashop_product WHERE (product_parent_id IN (15360)) AND (product_published = 1) AND ((product_access = 'all' OR product_access LIKE '%,9,%'))
295μs5.48KB/components/com_hikashop/views/product/view.html.php:1621CopySELECT v.*, c.* FROM m37h2_hikashop_variant AS v INNER JOIN m37h2_hikashop_characteristic AS c ON v.variant_characteristic_id = c.characteristic_id WHERE v.variant_product_id IN (15360) ORDER BY v.ordering ASC, c.characteristic_id ASC
189μs1.45KB/components/com_hikashop/views/product/view.html.php:1662CopySELECT * FROM m37h2_hikashop_file WHERE file_ref_id IN (15360) AND file_type IN ('product','file') AND (file_access = 'all' OR file_access LIKE '%,9,%') ORDER BY file_ordering ASC, file_id ASC
1.7ms1.45KB/components/com_hikashop/views/product/view.html.php:1707CopySELECT cart.cart_id FROM m37h2_hikashop_cart AS cart WHERE (cart.cart_type = 'cart') AND (cart.session_id = 'nuedh7da2q0oabcjq8smgnia5i') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
210μs520B/administrator/components/com_hikashop/classes/cart.php:69CopySELECT currency_id FROM m37h2_hikashop_currency WHERE currency_published=1 OR currency_id = 2
167μs536B/administrator/components/com_hikashop/classes/currency.php:473CopySELECT p.* FROM m37h2_hikashop_price as p WHERE (p.price_currency_id IN (2)) AND (p.price_start_date < 1739629595) AND ((p.price_end_date < 1 OR p.price_end_date > 1739629595)) AND (p.price_product_id IN (15360)) AND ((p.price_access = 'all' OR p.price_access LIKE '%,9,%')) AND ((p.price_users = '' OR p.price_users LIKE '%,0,%')) ORDER BY p.price_site_id ASC, p.price_value DESC
223μs1.44KB/administrator/components/com_hikashop/classes/currency.php:1718CopySELECT * FROM m37h2_hikashop_discount WHERE (discount_type = 'discount') AND (discount_published = 1) AND (discount_quota > discount_used_times OR discount_quota = 0) AND (discount_start < 1739629595) AND (discount_end > 1739629595 OR discount_end = 0) AND (discount_product_id IN ('','0','15360') OR discount_product_id LIKE '%,15360,%') AND (discount_flat_amount != 0 OR discount_percent_amount != 0) AND ((discount_flat_amount = 0 OR discount_currency_id =2)) AND ((discount_access = 'all' OR discount_access LIKE '%,9,%')) AND ((discount_user_id = '' OR discount_user_id LIKE '%,0,%'))
414μs3.13KB/administrator/components/com_hikashop/classes/currency.php:1778CopySELECT category_id, category_left, category_right FROM m37h2_hikashop_category WHERE category_id IN (96)
154μs656B/administrator/components/com_hikashop/classes/category.php:60CopySELECT category_id FROM m37h2_hikashop_category WHERE ((category_left >= 93 AND category_right <= 94)) AND (category_access = 'all' OR category_access LIKE '%,9,%')
212μs536B/administrator/components/com_hikashop/classes/currency.php:1267CopySELECT product_id FROM m37h2_hikashop_product_category WHERE category_id IN (96,96)
215μs8.51KB/administrator/components/com_hikashop/classes/currency.php:1283CopySELECT product_id FROM m37h2_hikashop_product WHERE product_manufacturer_id IN (96,96)
4.63ms520B/administrator/components/com_hikashop/classes/currency.php:1287CopySELECT category_id, category_left, category_right FROM m37h2_hikashop_category WHERE category_id IN (64,50)
174μs672B/administrator/components/com_hikashop/classes/category.php:60CopySELECT category_id FROM m37h2_hikashop_category WHERE ((category_left >= 62 AND category_right <= 63) OR (category_left >= 135 AND category_right <= 136)) AND (category_access = 'all' OR category_access LIKE '%,9,%')
214μs552B/administrator/components/com_hikashop/classes/currency.php:1267CopySELECT product_id FROM m37h2_hikashop_product_category WHERE category_id IN (50,64,50,64)
560μs20.51KB/administrator/components/com_hikashop/classes/currency.php:1283CopySELECT product_id FROM m37h2_hikashop_product WHERE product_manufacturer_id IN (50,64,50,64)
4.86ms520B/administrator/components/com_hikashop/classes/currency.php:1287CopySELECT category_id, category_left, category_right FROM m37h2_hikashop_category WHERE category_id IN (74)
210μs656B/administrator/components/com_hikashop/classes/category.php:60CopySELECT category_id FROM m37h2_hikashop_category WHERE ((category_left >= 155 AND category_right <= 156)) AND (category_access = 'all' OR category_access LIKE '%,9,%')
214μs536B/administrator/components/com_hikashop/classes/currency.php:1267CopySELECT product_id FROM m37h2_hikashop_product_category WHERE category_id IN (74,74)
356μs12.51KB/administrator/components/com_hikashop/classes/currency.php:1283CopySELECT product_id FROM m37h2_hikashop_product WHERE product_manufacturer_id IN (74,74)
4.45ms520B/administrator/components/com_hikashop/classes/currency.php:1287CopySELECT * FROM m37h2_menu WHERE id = '730' LIMIT 1
329μs2.84KB/administrator/components/com_hikashop/helpers/helper.php:2771CopySELECT * FROM m37h2_hikashop_category WHERE category_id = '13' LIMIT 1
234μs2.75KB/administrator/components/com_hikashop/helpers/helper.php:2771CopySELECT hk_parent.*, hk_parent.category_parent_id FROM m37h2_hikashop_category AS hk_parent WHERE hk_parent.category_id = 17 AND hk_parent.category_left >= 9 AND hk_parent.category_right <= 10 ORDER BY hk_parent.category_left
177μs2.77KB/administrator/components/com_hikashop/classes/category.php:780CopySELECT * FROM m37h2_hikashop_product WHERE product_id = '14916' LIMIT 1
245μs21.5KB/administrator/components/com_hikashop/helpers/helper.php:2771CopySELECT category_id FROM m37h2_hikashop_product_category WHERE product_id IN (15360) ORDER BY ordering ASC
200μs680B/administrator/components/com_hikashop/classes/product.php:1221CopySELECT hk_parent.category_id, hk_parent.category_parent_id FROM m37h2_hikashop_category AS hk_parent WHERE hk_parent.category_id IN (16,69,39,60,40,13,36,82,91) ORDER BY hk_parent.category_left
207μs736B/administrator/components/com_hikashop/classes/category.php:780CopySELECT hk_parent.category_id, hk_parent.category_parent_id, hk_parent.category_parent_id FROM m37h2_hikashop_category AS hk_parent WHERE hk_parent.category_id IN (2,35,48,34) ORDER BY hk_parent.category_left
158μs704B/administrator/components/com_hikashop/classes/category.php:780CopySELECT hk_parent.category_id, hk_parent.category_parent_id, hk_parent.category_parent_id, hk_parent.category_parent_id FROM m37h2_hikashop_category AS hk_parent WHERE hk_parent.category_id IN (1) ORDER BY hk_parent.category_left
111μs704B/administrator/components/com_hikashop/classes/category.php:780CopySELECT * FROM m37h2_hikashop_field as a WHERE a.`field_published` = 1 AND a.`field_frontcomp` = 1 AND a.field_table='product' AND (a.field_access = 'all' OR a.field_access LIKE '%,9,%') AND ((((field_with_sub_categories = 0 AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,16,%' OR field_categories LIKE '%,69,%' OR field_categories LIKE '%,39,%' OR field_categories LIKE '%,60,%' OR field_categories LIKE '%,40,%' OR field_categories LIKE '%,13,%' OR field_categories LIKE '%,36,%' OR field_categories LIKE '%,82,%' OR field_categories LIKE '%,91,%'))OR (field_with_sub_categories = 1 AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,35,%' OR field_categories LIKE '%,48,%' OR field_categories LIKE '%,34,%' OR field_categories LIKE '%,13,%' OR field_categories LIKE '%,36,%' OR field_categories LIKE '%,39,%' OR field_categories LIKE '%,40,%' OR field_categories LIKE '%,82,%' OR field_categories LIKE '%,60,%' OR field_categories LIKE '%,91,%' OR field_categories LIKE '%,16,%' OR field_categories LIKE '%,69,%'))) AND field_products="") OR (field_products LIKE '%,15360,%')) ORDER BY a.`field_ordering` ASC
307μs2.73KB/administrator/components/com_hikashop/classes/field.php:167CopySELECT * FROM m37h2_hikashop_field as a WHERE a.`field_published` = 1 AND a.`field_frontcomp` = 1 AND a.field_table='item' AND (a.field_access = 'all' OR a.field_access LIKE '%,9,%') AND ((((field_with_sub_categories = 0 AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,16,%' OR field_categories LIKE '%,69,%' OR field_categories LIKE '%,39,%' OR field_categories LIKE '%,60,%' OR field_categories LIKE '%,40,%' OR field_categories LIKE '%,13,%' OR field_categories LIKE '%,36,%' OR field_categories LIKE '%,82,%' OR field_categories LIKE '%,91,%'))OR (field_with_sub_categories = 1 AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,35,%' OR field_categories LIKE '%,48,%' OR field_categories LIKE '%,34,%' OR field_categories LIKE '%,13,%' OR field_categories LIKE '%,36,%' OR field_categories LIKE '%,39,%' OR field_categories LIKE '%,40,%' OR field_categories LIKE '%,82,%' OR field_categories LIKE '%,60,%' OR field_categories LIKE '%,91,%' OR field_categories LIKE '%,16,%' OR field_categories LIKE '%,69,%'))) AND field_products="") OR (field_products LIKE '%,15360,%')) ORDER BY a.`field_ordering` ASC
276μs2.73KB/administrator/components/com_hikashop/classes/field.php:167CopySELECT a.* FROM m37h2_hikashop_badge AS a WHERE a.badge_start <= 1739629595 AND (a.badge_end >= 1739629595 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = 7) AND (a.badge_new_period = 0 OR a.badge_new_period >= 124758267) AND (badge_discount_id = '0' OR badge_discount_id = '') AND (a.badge_access = 'all' OR a.badge_access LIKE '%,9,%') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '16' OR badge_category_id LIKE '%,16,%' OR badge_category_id = '69' OR badge_category_id LIKE '%,69,%' OR badge_category_id = '39' OR badge_category_id LIKE '%,39,%' OR badge_category_id = '60' OR badge_category_id LIKE '%,60,%' OR badge_category_id = '40' OR badge_category_id LIKE '%,40,%' OR badge_category_id = '13' OR badge_category_id LIKE '%,13,%' OR badge_category_id = '36' OR badge_category_id LIKE '%,36,%' OR badge_category_id = '82' OR badge_category_id LIKE '%,82,%' OR badge_category_id = '91' OR badge_category_id LIKE '%,91,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '35' OR badge_category_id LIKE '%,35,%' OR badge_category_id = '48' OR badge_category_id LIKE '%,48,%' OR badge_category_id = '34' OR badge_category_id LIKE '%,34,%' OR badge_category_id = '13' OR badge_category_id LIKE '%,13,%' OR badge_category_id = '36' OR badge_category_id LIKE '%,36,%' OR badge_category_id = '39' OR badge_category_id LIKE '%,39,%' OR badge_category_id = '40' OR badge_category_id LIKE '%,40,%' OR badge_category_id = '82' OR badge_category_id LIKE '%,82,%' OR badge_category_id = '60' OR badge_category_id LIKE '%,60,%' OR badge_category_id = '91' OR badge_category_id LIKE '%,91,%' OR badge_category_id = '16' OR badge_category_id LIKE '%,16,%' OR badge_category_id = '69' OR badge_category_id LIKE '%,69,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
318μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.*,b.* FROM m37h2_hikashop_category AS a LEFT JOIN m37h2_hikashop_file AS b ON a.category_id = b.file_ref_id AND b.file_type = 'category' WHERE a.category_id = 17 LIMIT 1
369μs4.59KB/administrator/components/com_hikashop/classes/category.php:35CopySELECT * FROM m37h2_menu WHERE id = '730' LIMIT 1
210μs13.84KB/administrator/components/com_hikashop/helpers/helper.php:2771CopySELECT DISTINCT a.product_id FROM m37h2_hikashop_product_category AS a LEFT JOIN m37h2_hikashop_product AS b ON a.product_id=b.product_id WHERE (b.product_published = 1) AND (b.product_type = 'main') AND (a.category_id = 17) AND ((b.product_access = 'all' OR b.product_access LIKE '%,9,%')) AND (b.product_quantity != 0) GROUP BY a.product_id ORDER BY b.product_created DESC
4.53ms4.51KB/components/com_hikashop/views/product/view.html.php:1986CopySELECT b.* FROM m37h2_hikashop_product_category AS a LEFT JOIN m37h2_hikashop_category AS b ON a.category_id = b.category_id WHERE a.product_id = 15360 ORDER BY a.product_category_id ASC
339μs18.89KB/components/com_hikashop/views/product/view.html.php:2052CopySELECT a.id FROM m37h2_menu AS a INNER JOIN `m37h2_menu_types` as b on a.menutype = b.menutype WHERE a.type='component' AND a.published=1 AND b.title IS NOT NULL AND a.access IN (1,2,5) AND a.client_id=0 AND a.link='index.php?option=com_hikashop&view=checkout&layout=show' AND a.language IN ('*', '', 'en-GB')
520μs520B/administrator/components/com_hikashop/classes/menus.php:333CopySELECT a.id FROM m37h2_menu AS a INNER JOIN `m37h2_menu_types` as b on a.menutype = b.menutype WHERE a.type='component' AND a.published=1 AND b.title IS NOT NULL AND a.access IN (1,2,5) AND a.client_id=0 AND a.link LIKE 'index.php?option=com_hikashop&view=%' AND a.language IN ('*', '', 'en-GB')
465μs1.51KB/administrator/components/com_hikashop/classes/menus.php:333CopySELECT a.*, c.currency_symbol FROM m37h2_hikashop_shipping AS a INNER JOIN m37h2_hikashop_currency AS c ON c.currency_id = a.shipping_currency_id WHERE (a.shipping_params LIKE '%s:20:\"shipping_per_product\";s:1:\"1\"%' OR a.shipping_params LIKE '%s:20:\"shipping_per_product\";i:1%') ORDER BY a.shipping_id
469μs1.64KB/plugins/hikashop/shippingmanual_prices/shippingmanual_prices.php:45CopySELECT * FROM m37h2_extensions WHERE folder='hikashop' AND element='shippingmanual_prices' AND type='plugin'
277μs2.53KB/administrator/components/com_hikashop/classes/plugins.php:113CopySELECT * FROM m37h2_extensions WHERE folder='system' AND element='hikashopsocial' AND type='plugin'
231μs2.53KB/administrator/components/com_hikashop/classes/plugins.php:113CopySELECT * FROM m37h2_extensions WHERE folder='content' AND element='hikashopsocial' AND type='plugin'
224μs2.52KB/administrator/components/com_hikashop/classes/plugins.php:113CopySELECT `m`.`tag_id`,`t`.*
FROM `m37h2_contentitem_tag_map` AS `m`
INNER JOIN `m37h2_tags` AS `t` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3)
276μs4KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT r.*
FROM m37h2_rereplacer AS r
WHERE r.published = 1 AND (r.area = 'articles' OR r.params LIKE '%\"use_xml\":\"1\"%')
ORDER BY r.ordering, r.id
189μs1.48KB/plugins/system/rereplacer/src/Items.php:97CopySELECT LOWER(REPLACE(a.title, " ", ""))
FROM m37h2_viewlevels as a
WHERE a.id IN ('1','2','5')
117μs568B/plugins/system/tabsaccordions/src/Sets.php:160CopySELECT LOWER(REPLACE(u.title, " ", ""))
FROM m37h2_usergroups as u
WHERE u.id IN ('1','2','9')
101μs568B/plugins/system/tabsaccordions/src/Sets.php:434CopySELECT option_value FROM m37h2_imagerecycle_options WHERE option_name ='queue_process_lastRun' LIMIT 1
97μs536B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172CopySELECT option_value FROM m37h2_imagerecycle_options WHERE option_name ='queue_process_status' LIMIT 1
67μs536B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172CopySELECT * FROM m37h2_extensions WHERE folder='hikashop' AND element='google_products' AND type='plugin'
201μs2.53KB/administrator/components/com_hikashop/classes/plugins.php:113CopySELECT * FROM m37h2_hikashop_vote WHERE vote_type = 'product' AND vote_published > 0 AND vote_ref_id = 15360
155μs1.45KB/templates/g5_helium/html/com_hikashop/product/show_microdata.php:86CopySELECT option_value FROM m37h2_imagerecycle_options WHERE option_name ='queue_process_lastRun' LIMIT 1
135μs536B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172CopySELECT option_value FROM m37h2_imagerecycle_options WHERE option_name ='queue_process_status' LIMIT 1
110μs536B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172CopySELECT a.id, a.link, a.params FROM m37h2_menu AS a INNER JOIN `m37h2_menu_types` AS b ON a.menutype = b.menutype WHERE a.type='component' AND a.published=1 AND b.title IS NOT NULL AND a.access IN (1,2,5) AND a.client_id=0 AND (a.link='index.php?option=com_hikashop&view=category&layout=listing' OR a.link='index.php?option=com_hikashop&view=product&layout=listing') AND a.language IN ('*', '', 'en-GB')
972μs257.5KB/administrator/components/com_hikashop/helpers/helper.php:1249CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15360 ORDER BY pc.product_category_id ASC
240μs648B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT r.*
FROM m37h2_rereplacer AS r
WHERE r.published = 1 AND (r.area = 'component' OR r.params LIKE '%\"use_xml\":\"1\"%')
ORDER BY r.ordering, r.id
216μs1.48KB/plugins/system/rereplacer/src/Items.php:97CopySELECT `content`
FROM `m37h2_modules`
WHERE `published` = 1 AND `client_id` = 0 AND `content` <> ''
293μs616B/plugins/system/ampz/helper.php:88CopySELECT `a`.`menutype`,`a`.`title`
FROM `m37h2_menu_types` AS `a`
WHERE `a`.`client_id` = 0
288μs704B/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138CopySELECT m.id, m.alias, m.path AS route, m.level, m.parent_id
FROM m37h2_menu AS m
WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0
ORDER BY m.lft
851μs1.73KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791CopySELECT `a`.`id`
FROM `m37h2_tags` AS `a`
LEFT JOIN `m37h2_tags` AS `b` ON `b`.`lft` < `a`.`lft` AND `a`.`rgt` < `b`.`rgt`
WHERE `b`.`id` = :id
277μs1.38KBParams/components/com_tags/src/Service/Router.php:365CopySELECT m.*
FROM m37h2_modules AS m
LEFT JOIN m37h2_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
WHERE m.client_id = 0 AND m.id = 125 AND m.access IN (1,2,5) AND m.published = 1 AND e.enabled = 1
ORDER BY m.ordering
365μs2.41KB/plugins/system/modulesanywhere/src/Replace.php:359CopySELECT cart.cart_id FROM m37h2_hikashop_cart AS cart WHERE (cart.cart_type = 'cart') AND (cart.session_id = 'nuedh7da2q0oabcjq8smgnia5i') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
298μs520B/administrator/components/com_hikashop/classes/cart.php:69CopySELECT m.id, m.alias, m.path AS route, m.level, m.parent_id
FROM m37h2_menu AS m
WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0
ORDER BY m.lft
884μs1.73KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791CopySELECT cart.cart_id FROM m37h2_hikashop_cart AS cart WHERE (cart.cart_type = 'cart') AND (cart.session_id = 'nuedh7da2q0oabcjq8smgnia5i') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
323μs520B/administrator/components/com_hikashop/classes/cart.php:69CopySELECT category_id FROM m37h2_hikashop_category WHERE (category_access = 'all' OR category_access LIKE '%,9,%') AND category_id IN ('2')
138μs536B/components/com_hikashop/views/product/view.html.php:693CopySELECT * FROM m37h2_hikashop_filter WHERE filter_published = 1 AND (filter_access = 'all' OR filter_access LIKE '%,9,%') ORDER BY filter_ordering
247μs1.72KB/administrator/components/com_hikashop/classes/filter.php:339CopySELECT hk_parent.category_id, hk_parent.category_parent_id FROM m37h2_hikashop_category AS hk_parent WHERE hk_parent.category_id = 2 ORDER BY hk_parent.category_left
99μs592B/administrator/components/com_hikashop/classes/category.php:780CopySELECT hk_parent.category_id, hk_parent.category_parent_id, hk_parent.category_parent_id FROM m37h2_hikashop_category AS hk_parent WHERE hk_parent.category_id IN (1) ORDER BY hk_parent.category_left
95μs656B/administrator/components/com_hikashop/classes/category.php:780CopySELECT a.*,b.* FROM m37h2_hikashop_category AS a LEFT JOIN m37h2_hikashop_file AS b ON a.category_id = b.file_ref_id AND b.file_type = 'category' WHERE a.category_id = 2 LIMIT 1
477μs4.59KB/administrator/components/com_hikashop/classes/category.php:35CopySELECT DISTINCT b.* FROM m37h2_hikashop_product_related AS a LEFT JOIN m37h2_hikashop_product AS b ON a.product_related_id=b.product_id WHERE (b.product_published = 1) AND (a.product_related_type='related') AND (a.product_id=15360) AND (b.product_type = 'main') AND (b.product_quantity!=0) AND ((b.product_access = 'all' OR b.product_access LIKE '%,9,%')) ORDER BY a.product_related_ordering ASC, b.product_id ASC LIMIT 20
2.08ms21.64KB/components/com_hikashop/views/product/view.html.php:1082CopySELECT * FROM m37h2_hikashop_file WHERE file_ref_id IN (15795,15972,15915,14897,15831,11542,12705,15540,14916) AND file_type IN ('product','file') ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
2.06ms1.73KB/administrator/components/com_hikashop/classes/product.php:2466CopySELECT variant_product_id FROM m37h2_hikashop_variant WHERE variant_product_id IN (15795,15972,15915,14897,15831,11542,12705,15540,14916)
167μs520B/administrator/components/com_hikashop/classes/product.php:2494CopySELECT product_id FROM m37h2_hikashop_product_related WHERE product_related_type = 'options' AND product_id IN (15795,15972,15915,14897,15831,11542,12705,15540,14916)
668μs520B/administrator/components/com_hikashop/classes/product.php:2510CopySELECT cart.cart_id FROM m37h2_hikashop_cart AS cart WHERE (cart.cart_type = 'cart') AND (cart.session_id = 'nuedh7da2q0oabcjq8smgnia5i') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
202μs520B/administrator/components/com_hikashop/classes/cart.php:69CopySELECT product_parent_id, product_id, product_tax_id FROM m37h2_hikashop_product WHERE product_parent_id IN ('15795','15972','15915','14897','15831','11542','12705','15540','14916') AND product_published = 1 AND product_type = 'variant' AND product_sale_start < 1739629595 AND (product_sale_end > 1739629595 OR product_sale_end = 0)
393μs640B/administrator/components/com_hikashop/classes/currency.php:1060CopySELECT * FROM m37h2_hikashop_discount WHERE discount_type='discount' AND discount_published=1 AND (discount_quota > discount_used_times OR discount_quota = 0) AND discount_start < 1739629595 AND (discount_end > 1739629595 OR discount_end = 0) AND ( (discount_product_id IN ('','0','15795','15972','15915','14897','15831','11542','12705','15540','14916')) OR (discount_product_id LIKE '%,15795,%') OR (discount_product_id LIKE '%,15972,%') OR (discount_product_id LIKE '%,15915,%') OR (discount_product_id LIKE '%,14897,%') OR (discount_product_id LIKE '%,15831,%') OR (discount_product_id LIKE '%,11542,%') OR (discount_product_id LIKE '%,12705,%') OR (discount_product_id LIKE '%,15540,%') OR (discount_product_id LIKE '%,14916,%') ) AND (discount_flat_amount != 0 OR discount_percent_amount != 0) AND (discount_flat_amount = 0 OR discount_currency_id =2) AND (discount_access = 'all' OR discount_access LIKE '%,9,%') AND (discount_user_id = '' OR discount_user_id LIKE '%,0,%')
429μs3.13KB/administrator/components/com_hikashop/classes/currency.php:558CopySELECT a.*, CASE WHEN price_site_id = 0 OR price_site_id = '[unselected]' THEN '' ELSE price_site_id END AS price_site_id FROM m37h2_hikashop_price AS a WHERE a.price_product_id IN (15795,15972,15915,14897,15831,11542,12705,15540,14916) AND a.price_currency_id IN (2) AND a.price_start_date < 1739629595 AND (a.price_end_date < 1 OR a.price_end_date > 1739629595) AND (a.price_access = 'all' OR a.price_access LIKE '%,9,%' OR ISNULL(a.price_access)) AND (a.price_users = '' OR a.price_users LIKE '%,0,%') ORDER BY a.price_site_id ASC, a.price_value DESC
366μs1.61KB/administrator/components/com_hikashop/classes/currency.php:589CopySELECT * FROM m37h2_hikashop_currency WHERE currency_id IN (2)
127μs1.44KB/administrator/components/com_hikashop/classes/currency.php:1028CopySELECT DISTINCT b.category_id, b.category_depth FROM m37h2_hikashop_product_category AS c LEFT JOIN m37h2_hikashop_category AS a ON c.category_id=a.category_id LEFT JOIN m37h2_hikashop_category AS b ON a.category_left >= b.category_left WHERE (b.category_right >= a.category_right) AND (c.product_id = 11542) AND ((b.category_access = 'all' OR b.category_access LIKE '%,9,%'))
476μs832B/administrator/components/com_hikashop/classes/currency.php:1607CopySELECT DISTINCT b.category_id, b.category_depth FROM m37h2_hikashop_product AS c LEFT JOIN m37h2_hikashop_category AS a ON c.product_manufacturer_id=a.category_id LEFT JOIN m37h2_hikashop_category AS b ON a.category_left >= b.category_left WHERE (b.category_right >= a.category_right) AND (c.product_id = 11542) AND ((b.category_access = 'all' OR b.category_access LIKE '%,9,%'))
141μs576B/administrator/components/com_hikashop/classes/currency.php:1625CopySELECT c.*, pc.* FROM m37h2_hikashop_category AS c LEFT JOIN m37h2_hikashop_product_category AS pc ON c.category_id = pc.category_id WHERE pc.product_id IN (15795,15972,15915,14897,15831,11542,12705,15540,14916);
693μs84.23KB/administrator/components/com_hikashop/classes/product.php:2561CopySELECT hk_parent.category_id, hk_parent.category_parent_id FROM m37h2_hikashop_category AS hk_parent WHERE hk_parent.category_id IN (38,57,46,45,42,15,91,13) ORDER BY hk_parent.category_left
187μs704B/administrator/components/com_hikashop/classes/category.php:780CopySELECT a.* FROM m37h2_hikashop_badge AS a WHERE a.badge_start <= 1739629595 AND (a.badge_end >= 1739629595 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = 4) AND (a.badge_new_period = 0 OR a.badge_new_period >= 89850448) AND (badge_discount_id = '0' OR badge_discount_id = '') AND (a.badge_access = 'all' OR a.badge_access LIKE '%,9,%') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '38' OR badge_category_id LIKE '%,38,%' OR badge_category_id = '57' OR badge_category_id LIKE '%,57,%' OR badge_category_id = '46' OR badge_category_id LIKE '%,46,%' OR badge_category_id = '45' OR badge_category_id LIKE '%,45,%' OR badge_category_id = '42' OR badge_category_id LIKE '%,42,%' OR badge_category_id = '15' OR badge_category_id LIKE '%,15,%' OR badge_category_id = '91' OR badge_category_id LIKE '%,91,%' OR badge_category_id = '13' OR badge_category_id LIKE '%,13,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '35' OR badge_category_id LIKE '%,35,%' OR badge_category_id = '48' OR badge_category_id LIKE '%,48,%' OR badge_category_id = '34' OR badge_category_id LIKE '%,34,%' OR badge_category_id = '13' OR badge_category_id LIKE '%,13,%' OR badge_category_id = '38' OR badge_category_id LIKE '%,38,%' OR badge_category_id = '42' OR badge_category_id LIKE '%,42,%' OR badge_category_id = '45' OR badge_category_id LIKE '%,45,%' OR badge_category_id = '46' OR badge_category_id LIKE '%,46,%' OR badge_category_id = '57' OR badge_category_id LIKE '%,57,%' OR badge_category_id = '91' OR badge_category_id LIKE '%,91,%' OR badge_category_id = '15' OR badge_category_id LIKE '%,15,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
268μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT hk_parent.category_id, hk_parent.category_parent_id FROM m37h2_hikashop_category AS hk_parent WHERE hk_parent.category_id IN (67,60,82,91,16,93,17) ORDER BY hk_parent.category_left
202μs704B/administrator/components/com_hikashop/classes/category.php:780CopySELECT a.* FROM m37h2_hikashop_badge AS a WHERE a.badge_start <= 1739629595 AND (a.badge_end >= 1739629595 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = 2) AND (a.badge_new_period = 0 OR a.badge_new_period >= 55207989) AND (badge_discount_id = '0' OR badge_discount_id = '') AND (a.badge_access = 'all' OR a.badge_access LIKE '%,9,%') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '67' OR badge_category_id LIKE '%,67,%' OR badge_category_id = '60' OR badge_category_id LIKE '%,60,%' OR badge_category_id = '82' OR badge_category_id LIKE '%,82,%' OR badge_category_id = '91' OR badge_category_id LIKE '%,91,%' OR badge_category_id = '16' OR badge_category_id LIKE '%,16,%' OR badge_category_id = '93' OR badge_category_id LIKE '%,93,%' OR badge_category_id = '17' OR badge_category_id LIKE '%,17,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '35' OR badge_category_id LIKE '%,35,%' OR badge_category_id = '48' OR badge_category_id LIKE '%,48,%' OR badge_category_id = '34' OR badge_category_id LIKE '%,34,%' OR badge_category_id = '17' OR badge_category_id LIKE '%,17,%' OR badge_category_id = '82' OR badge_category_id LIKE '%,82,%' OR badge_category_id = '60' OR badge_category_id LIKE '%,60,%' OR badge_category_id = '91' OR badge_category_id LIKE '%,91,%' OR badge_category_id = '93' OR badge_category_id LIKE '%,93,%' OR badge_category_id = '16' OR badge_category_id LIKE '%,16,%' OR badge_category_id = '67' OR badge_category_id LIKE '%,67,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
251μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT hk_parent.category_id, hk_parent.category_parent_id FROM m37h2_hikashop_category AS hk_parent WHERE hk_parent.category_id IN (82,60,16,91,24) ORDER BY hk_parent.category_left
246μs656B/administrator/components/com_hikashop/classes/category.php:780CopySELECT a.* FROM m37h2_hikashop_badge AS a WHERE a.badge_start <= 1739629595 AND (a.badge_end >= 1739629595 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = 2) AND (a.badge_new_period = 0 OR a.badge_new_period >= 70841188) AND (badge_discount_id = '0' OR badge_discount_id = '') AND (a.badge_access = 'all' OR a.badge_access LIKE '%,9,%') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '82' OR badge_category_id LIKE '%,82,%' OR badge_category_id = '60' OR badge_category_id LIKE '%,60,%' OR badge_category_id = '16' OR badge_category_id LIKE '%,16,%' OR badge_category_id = '91' OR badge_category_id LIKE '%,91,%' OR badge_category_id = '24' OR badge_category_id LIKE '%,24,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '35' OR badge_category_id LIKE '%,35,%' OR badge_category_id = '48' OR badge_category_id LIKE '%,48,%' OR badge_category_id = '34' OR badge_category_id LIKE '%,34,%' OR badge_category_id = '24' OR badge_category_id LIKE '%,24,%' OR badge_category_id = '82' OR badge_category_id LIKE '%,82,%' OR badge_category_id = '60' OR badge_category_id LIKE '%,60,%' OR badge_category_id = '91' OR badge_category_id LIKE '%,91,%' OR badge_category_id = '16' OR badge_category_id LIKE '%,16,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
261μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT hk_parent.category_id, hk_parent.category_parent_id FROM m37h2_hikashop_category AS hk_parent WHERE hk_parent.category_id IN (60,82,46,41,51,39,38,79,37,91,13) ORDER BY hk_parent.category_left
227μs768B/administrator/components/com_hikashop/classes/category.php:780CopySELECT a.* FROM m37h2_hikashop_badge AS a WHERE a.badge_start <= 1739629595 AND (a.badge_end >= 1739629595 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = 4) AND (a.badge_new_period = 0 OR a.badge_new_period >= 154562646) AND (badge_discount_id = '0' OR badge_discount_id = '') AND (a.badge_access = 'all' OR a.badge_access LIKE '%,9,%') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '60' OR badge_category_id LIKE '%,60,%' OR badge_category_id = '82' OR badge_category_id LIKE '%,82,%' OR badge_category_id = '46' OR badge_category_id LIKE '%,46,%' OR badge_category_id = '41' OR badge_category_id LIKE '%,41,%' OR badge_category_id = '51' OR badge_category_id LIKE '%,51,%' OR badge_category_id = '39' OR badge_category_id LIKE '%,39,%' OR badge_category_id = '38' OR badge_category_id LIKE '%,38,%' OR badge_category_id = '79' OR badge_category_id LIKE '%,79,%' OR badge_category_id = '37' OR badge_category_id LIKE '%,37,%' OR badge_category_id = '91' OR badge_category_id LIKE '%,91,%' OR badge_category_id = '13' OR badge_category_id LIKE '%,13,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '35' OR badge_category_id LIKE '%,35,%' OR badge_category_id = '48' OR badge_category_id LIKE '%,48,%' OR badge_category_id = '34' OR badge_category_id LIKE '%,34,%' OR badge_category_id = '13' OR badge_category_id LIKE '%,13,%' OR badge_category_id = '37' OR badge_category_id LIKE '%,37,%' OR badge_category_id = '38' OR badge_category_id LIKE '%,38,%' OR badge_category_id = '39' OR badge_category_id LIKE '%,39,%' OR badge_category_id = '41' OR badge_category_id LIKE '%,41,%' OR badge_category_id = '46' OR badge_category_id LIKE '%,46,%' OR badge_category_id = '82' OR badge_category_id LIKE '%,82,%' OR badge_category_id = '51' OR badge_category_id LIKE '%,51,%' OR badge_category_id = '60' OR badge_category_id LIKE '%,60,%' OR badge_category_id = '91' OR badge_category_id LIKE '%,91,%' OR badge_category_id = '79' OR badge_category_id LIKE '%,79,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
330μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT hk_parent.category_id, hk_parent.category_parent_id FROM m37h2_hikashop_category AS hk_parent WHERE hk_parent.category_id IN (60,82,33,16,91,24) ORDER BY hk_parent.category_left
165μs672B/administrator/components/com_hikashop/classes/category.php:780CopySELECT a.* FROM m37h2_hikashop_badge AS a WHERE a.badge_start <= 1739629595 AND (a.badge_end >= 1739629595 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = 2) AND (a.badge_new_period = 0 OR a.badge_new_period >= 85096066) AND (badge_discount_id = '0' OR badge_discount_id = '') AND (a.badge_access = 'all' OR a.badge_access LIKE '%,9,%') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '60' OR badge_category_id LIKE '%,60,%' OR badge_category_id = '82' OR badge_category_id LIKE '%,82,%' OR badge_category_id = '33' OR badge_category_id LIKE '%,33,%' OR badge_category_id = '16' OR badge_category_id LIKE '%,16,%' OR badge_category_id = '91' OR badge_category_id LIKE '%,91,%' OR badge_category_id = '24' OR badge_category_id LIKE '%,24,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '35' OR badge_category_id LIKE '%,35,%' OR badge_category_id = '48' OR badge_category_id LIKE '%,48,%' OR badge_category_id = '34' OR badge_category_id LIKE '%,34,%' OR badge_category_id = '24' OR badge_category_id LIKE '%,24,%' OR badge_category_id = '33' OR badge_category_id LIKE '%,33,%' OR badge_category_id = '82' OR badge_category_id LIKE '%,82,%' OR badge_category_id = '60' OR badge_category_id LIKE '%,60,%' OR badge_category_id = '91' OR badge_category_id LIKE '%,91,%' OR badge_category_id = '16' OR badge_category_id LIKE '%,16,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
267μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT hk_parent.category_id, hk_parent.category_parent_id FROM m37h2_hikashop_category AS hk_parent WHERE hk_parent.category_id IN (93,96,60,40,52,36,16,33,17) ORDER BY hk_parent.category_left
230μs736B/administrator/components/com_hikashop/classes/category.php:780CopySELECT a.* FROM m37h2_hikashop_badge AS a WHERE a.badge_start <= 1739629595 AND (a.badge_end >= 1739629595 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = 4) AND (a.badge_new_period = 0 OR a.badge_new_period >= 336389195) AND (badge_discount_id = 41 OR badge_discount_id = '0' OR badge_discount_id = '' OR badge_discount_id LIKE '%,41,%') AND (a.badge_access = 'all' OR a.badge_access LIKE '%,9,%') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '93' OR badge_category_id LIKE '%,93,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '60' OR badge_category_id LIKE '%,60,%' OR badge_category_id = '40' OR badge_category_id LIKE '%,40,%' OR badge_category_id = '52' OR badge_category_id LIKE '%,52,%' OR badge_category_id = '36' OR badge_category_id LIKE '%,36,%' OR badge_category_id = '16' OR badge_category_id LIKE '%,16,%' OR badge_category_id = '33' OR badge_category_id LIKE '%,33,%' OR badge_category_id = '17' OR badge_category_id LIKE '%,17,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '35' OR badge_category_id LIKE '%,35,%' OR badge_category_id = '48' OR badge_category_id LIKE '%,48,%' OR badge_category_id = '34' OR badge_category_id LIKE '%,34,%' OR badge_category_id = '17' OR badge_category_id LIKE '%,17,%' OR badge_category_id = '33' OR badge_category_id LIKE '%,33,%' OR badge_category_id = '36' OR badge_category_id LIKE '%,36,%' OR badge_category_id = '40' OR badge_category_id LIKE '%,40,%' OR badge_category_id = '52' OR badge_category_id LIKE '%,52,%' OR badge_category_id = '60' OR badge_category_id LIKE '%,60,%' OR badge_category_id = '93' OR badge_category_id LIKE '%,93,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '16' OR badge_category_id LIKE '%,16,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
243μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT hk_parent.category_id, hk_parent.category_parent_id FROM m37h2_hikashop_category AS hk_parent WHERE hk_parent.category_id IN (60,16,36,91,17) ORDER BY hk_parent.category_left
168μs656B/administrator/components/com_hikashop/classes/category.php:780CopySELECT a.* FROM m37h2_hikashop_badge AS a WHERE a.badge_start <= 1739629595 AND (a.badge_end >= 1739629595 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = 4) AND (a.badge_new_period = 0 OR a.badge_new_period >= 275269036) AND (badge_discount_id = '0' OR badge_discount_id = '') AND (a.badge_access = 'all' OR a.badge_access LIKE '%,9,%') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '60' OR badge_category_id LIKE '%,60,%' OR badge_category_id = '16' OR badge_category_id LIKE '%,16,%' OR badge_category_id = '36' OR badge_category_id LIKE '%,36,%' OR badge_category_id = '91' OR badge_category_id LIKE '%,91,%' OR badge_category_id = '17' OR badge_category_id LIKE '%,17,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '35' OR badge_category_id LIKE '%,35,%' OR badge_category_id = '48' OR badge_category_id LIKE '%,48,%' OR badge_category_id = '34' OR badge_category_id LIKE '%,34,%' OR badge_category_id = '17' OR badge_category_id LIKE '%,17,%' OR badge_category_id = '36' OR badge_category_id LIKE '%,36,%' OR badge_category_id = '60' OR badge_category_id LIKE '%,60,%' OR badge_category_id = '91' OR badge_category_id LIKE '%,91,%' OR badge_category_id = '16' OR badge_category_id LIKE '%,16,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
255μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT hk_parent.category_id, hk_parent.category_parent_id FROM m37h2_hikashop_category AS hk_parent WHERE hk_parent.category_id IN (39,36,60,82,59,78,16,91,17) ORDER BY hk_parent.category_left
171μs736B/administrator/components/com_hikashop/classes/category.php:780CopySELECT a.* FROM m37h2_hikashop_badge AS a WHERE a.badge_start <= 1739629595 AND (a.badge_end >= 1739629595 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = 1) AND (a.badge_new_period = 0 OR a.badge_new_period >= 114740915) AND (badge_discount_id = '0' OR badge_discount_id = '') AND (a.badge_access = 'all' OR a.badge_access LIKE '%,9,%') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '39' OR badge_category_id LIKE '%,39,%' OR badge_category_id = '36' OR badge_category_id LIKE '%,36,%' OR badge_category_id = '60' OR badge_category_id LIKE '%,60,%' OR badge_category_id = '82' OR badge_category_id LIKE '%,82,%' OR badge_category_id = '59' OR badge_category_id LIKE '%,59,%' OR badge_category_id = '78' OR badge_category_id LIKE '%,78,%' OR badge_category_id = '16' OR badge_category_id LIKE '%,16,%' OR badge_category_id = '91' OR badge_category_id LIKE '%,91,%' OR badge_category_id = '17' OR badge_category_id LIKE '%,17,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '35' OR badge_category_id LIKE '%,35,%' OR badge_category_id = '48' OR badge_category_id LIKE '%,48,%' OR badge_category_id = '34' OR badge_category_id LIKE '%,34,%' OR badge_category_id = '17' OR badge_category_id LIKE '%,17,%' OR badge_category_id = '36' OR badge_category_id LIKE '%,36,%' OR badge_category_id = '39' OR badge_category_id LIKE '%,39,%' OR badge_category_id = '82' OR badge_category_id LIKE '%,82,%' OR badge_category_id = '59' OR badge_category_id LIKE '%,59,%' OR badge_category_id = '60' OR badge_category_id LIKE '%,60,%' OR badge_category_id = '91' OR badge_category_id LIKE '%,91,%' OR badge_category_id = '16' OR badge_category_id LIKE '%,16,%' OR badge_category_id = '78' OR badge_category_id LIKE '%,78,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
226μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT hk_parent.category_id, hk_parent.category_parent_id FROM m37h2_hikashop_category AS hk_parent WHERE hk_parent.category_id IN (97,39,36,60,82,16,91,17) ORDER BY hk_parent.category_left
183μs704B/administrator/components/com_hikashop/classes/category.php:780CopySELECT hk_parent.category_id, hk_parent.category_parent_id, hk_parent.category_parent_id FROM m37h2_hikashop_category AS hk_parent WHERE hk_parent.category_id IN (2,35,48,34,88) ORDER BY hk_parent.category_left
122μs8.7KB/administrator/components/com_hikashop/classes/category.php:780CopySELECT a.* FROM m37h2_hikashop_badge AS a WHERE a.badge_start <= 1739629595 AND (a.badge_end >= 1739629595 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = 3) AND (a.badge_new_period = 0 OR a.badge_new_period >= 153445579) AND (badge_discount_id = '0' OR badge_discount_id = '') AND (a.badge_access = 'all' OR a.badge_access LIKE '%,9,%') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '97' OR badge_category_id LIKE '%,97,%' OR badge_category_id = '39' OR badge_category_id LIKE '%,39,%' OR badge_category_id = '36' OR badge_category_id LIKE '%,36,%' OR badge_category_id = '60' OR badge_category_id LIKE '%,60,%' OR badge_category_id = '82' OR badge_category_id LIKE '%,82,%' OR badge_category_id = '16' OR badge_category_id LIKE '%,16,%' OR badge_category_id = '91' OR badge_category_id LIKE '%,91,%' OR badge_category_id = '17' OR badge_category_id LIKE '%,17,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '35' OR badge_category_id LIKE '%,35,%' OR badge_category_id = '48' OR badge_category_id LIKE '%,48,%' OR badge_category_id = '34' OR badge_category_id LIKE '%,34,%' OR badge_category_id = '88' OR badge_category_id LIKE '%,88,%' OR badge_category_id = '17' OR badge_category_id LIKE '%,17,%' OR badge_category_id = '36' OR badge_category_id LIKE '%,36,%' OR badge_category_id = '39' OR badge_category_id LIKE '%,39,%' OR badge_category_id = '82' OR badge_category_id LIKE '%,82,%' OR badge_category_id = '60' OR badge_category_id LIKE '%,60,%' OR badge_category_id = '91' OR badge_category_id LIKE '%,91,%' OR badge_category_id = '16' OR badge_category_id LIKE '%,16,%' OR badge_category_id = '97' OR badge_category_id LIKE '%,97,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
221μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT hk_parent.category_id, hk_parent.category_parent_id, hk_parent.category_parent_id FROM m37h2_hikashop_category AS hk_parent WHERE hk_parent.category_id IN (38,57,46,45,42,15,91,13,67,60,82,16,93,17,24,41,51,39,79,37,33,96,40,52,36,59,78,97) ORDER BY hk_parent.category_left
236μs1.13KB/administrator/components/com_hikashop/classes/category.php:780CopySELECT hk_parent.category_id, hk_parent.category_parent_id, hk_parent.category_parent_id, hk_parent.category_parent_id FROM m37h2_hikashop_category AS hk_parent WHERE hk_parent.category_id IN (2,35,48,34,88) ORDER BY hk_parent.category_left
173μs768B/administrator/components/com_hikashop/classes/category.php:780CopySELECT hk_parent.category_id, hk_parent.category_parent_id, hk_parent.category_parent_id, hk_parent.category_parent_id, hk_parent.category_parent_id FROM m37h2_hikashop_category AS hk_parent WHERE hk_parent.category_id IN (1) ORDER BY hk_parent.category_left
128μs768B/administrator/components/com_hikashop/classes/category.php:780CopySELECT * FROM m37h2_hikashop_field as a WHERE a.`field_published` = 1 AND a.`field_display` LIKE '%;front\_listing=1;%' AND a.field_table='product' AND (a.field_access = 'all' OR a.field_access LIKE '%,9,%') AND ((((field_with_sub_categories = 0 AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,38,%' OR field_categories LIKE '%,57,%' OR field_categories LIKE '%,46,%' OR field_categories LIKE '%,45,%' OR field_categories LIKE '%,42,%' OR field_categories LIKE '%,15,%' OR field_categories LIKE '%,91,%' OR field_categories LIKE '%,13,%' OR field_categories LIKE '%,67,%' OR field_categories LIKE '%,60,%' OR field_categories LIKE '%,82,%' OR field_categories LIKE '%,16,%' OR field_categories LIKE '%,93,%' OR field_categories LIKE '%,17,%' OR field_categories LIKE '%,24,%' OR field_categories LIKE '%,41,%' OR field_categories LIKE '%,51,%' OR field_categories LIKE '%,39,%' OR field_categories LIKE '%,79,%' OR field_categories LIKE '%,37,%' OR field_categories LIKE '%,33,%' OR field_categories LIKE '%,96,%' OR field_categories LIKE '%,40,%' OR field_categories LIKE '%,52,%' OR field_categories LIKE '%,36,%' OR field_categories LIKE '%,59,%' OR field_categories LIKE '%,78,%' OR field_categories LIKE '%,97,%'))OR (field_with_sub_categories = 1 AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,35,%' OR field_categories LIKE '%,48,%' OR field_categories LIKE '%,34,%' OR field_categories LIKE '%,88,%' OR field_categories LIKE '%,17,%' OR field_categories LIKE '%,13,%' OR field_categories LIKE '%,24,%' OR field_categories LIKE '%,33,%' OR field_categories LIKE '%,36,%' OR field_categories LIKE '%,37,%' OR field_categories LIKE '%,38,%' OR field_categories LIKE '%,39,%' OR field_categories LIKE '%,40,%' OR field_categories LIKE '%,41,%' OR field_categories LIKE '%,42,%' OR field_categories LIKE '%,45,%' OR field_categories LIKE '%,46,%' OR field_categories LIKE '%,82,%' OR field_categories LIKE '%,51,%' OR field_categories LIKE '%,52,%' OR field_categories LIKE '%,57,%' OR field_categories LIKE '%,59,%' OR field_categories LIKE '%,60,%' OR field_categories LIKE '%,91,%' OR field_categories LIKE '%,93,%' OR field_categories LIKE '%,96,%' OR field_categories LIKE '%,16,%' OR field_categories LIKE '%,15,%' OR field_categories LIKE '%,67,%' OR field_categories LIKE '%,78,%' OR field_categories LIKE '%,79,%' OR field_categories LIKE '%,97,%'))) AND field_products="") OR (field_products LIKE '%,11542,%' OR field_products LIKE '%,12705,%' OR field_products LIKE '%,14897,%' OR field_products LIKE '%,14916,%' OR field_products LIKE '%,15540,%' OR field_products LIKE '%,15795,%' OR field_products LIKE '%,15831,%' OR field_products LIKE '%,15915,%' OR field_products LIKE '%,15972,%')) ORDER BY a.`field_ordering` ASC
535μs2.73KB/administrator/components/com_hikashop/classes/field.php:167CopySELECT * FROM m37h2_hikashop_field as a WHERE a.`field_published` = 1 AND a.`field_frontcomp` = 1 AND a.field_table='item' AND (a.field_access = 'all' OR a.field_access LIKE '%,9,%') AND ((((field_with_sub_categories = 0 AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,38,%' OR field_categories LIKE '%,57,%' OR field_categories LIKE '%,46,%' OR field_categories LIKE '%,45,%' OR field_categories LIKE '%,42,%' OR field_categories LIKE '%,15,%' OR field_categories LIKE '%,91,%' OR field_categories LIKE '%,13,%' OR field_categories LIKE '%,67,%' OR field_categories LIKE '%,60,%' OR field_categories LIKE '%,82,%' OR field_categories LIKE '%,16,%' OR field_categories LIKE '%,93,%' OR field_categories LIKE '%,17,%' OR field_categories LIKE '%,24,%' OR field_categories LIKE '%,41,%' OR field_categories LIKE '%,51,%' OR field_categories LIKE '%,39,%' OR field_categories LIKE '%,79,%' OR field_categories LIKE '%,37,%' OR field_categories LIKE '%,33,%' OR field_categories LIKE '%,96,%' OR field_categories LIKE '%,40,%' OR field_categories LIKE '%,52,%' OR field_categories LIKE '%,36,%' OR field_categories LIKE '%,59,%' OR field_categories LIKE '%,78,%' OR field_categories LIKE '%,97,%'))OR (field_with_sub_categories = 1 AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,35,%' OR field_categories LIKE '%,48,%' OR field_categories LIKE '%,34,%' OR field_categories LIKE '%,88,%' OR field_categories LIKE '%,17,%' OR field_categories LIKE '%,13,%' OR field_categories LIKE '%,24,%' OR field_categories LIKE '%,33,%' OR field_categories LIKE '%,36,%' OR field_categories LIKE '%,37,%' OR field_categories LIKE '%,38,%' OR field_categories LIKE '%,39,%' OR field_categories LIKE '%,40,%' OR field_categories LIKE '%,41,%' OR field_categories LIKE '%,42,%' OR field_categories LIKE '%,45,%' OR field_categories LIKE '%,46,%' OR field_categories LIKE '%,82,%' OR field_categories LIKE '%,51,%' OR field_categories LIKE '%,52,%' OR field_categories LIKE '%,57,%' OR field_categories LIKE '%,59,%' OR field_categories LIKE '%,60,%' OR field_categories LIKE '%,91,%' OR field_categories LIKE '%,93,%' OR field_categories LIKE '%,96,%' OR field_categories LIKE '%,16,%' OR field_categories LIKE '%,15,%' OR field_categories LIKE '%,67,%' OR field_categories LIKE '%,78,%' OR field_categories LIKE '%,79,%' OR field_categories LIKE '%,97,%'))) AND field_products="") OR (field_products LIKE '%,11542,%' OR field_products LIKE '%,12705,%' OR field_products LIKE '%,14897,%' OR field_products LIKE '%,14916,%' OR field_products LIKE '%,15540,%' OR field_products LIKE '%,15795,%' OR field_products LIKE '%,15831,%' OR field_products LIKE '%,15915,%' OR field_products LIKE '%,15972,%')) ORDER BY a.`field_ordering` ASC
315μs2.73KB/administrator/components/com_hikashop/classes/field.php:167CopySELECT COUNT( DISTINCT b.product_id ) FROM m37h2_hikashop_product_related AS a LEFT JOIN m37h2_hikashop_product AS b ON a.product_related_id=b.product_id WHERE (b.product_published = 1) AND (a.product_related_type='related') AND (a.product_id=15360) AND (b.product_type = 'main') AND (b.product_quantity!=0) AND ((b.product_access = 'all' OR b.product_access LIKE '%,9,%')) ORDER BY a.product_related_ordering ASC, b.product_id ASC
899μs536B/components/com_hikashop/views/product/view.html.php:1134CopySELECT * FROM m37h2_hikashop_characteristic WHERE characteristic_values_on_listing > 0 ORDER BY characteristic_ordering ASC;
164μs1.27KB/components/com_hikashop/views/product/view.html.php:1361CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15795 ORDER BY pc.product_category_id ASC
320μs648B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15795 ORDER BY pc.product_category_id ASC
229μs648B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15795 ORDER BY pc.product_category_id ASC
207μs648B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15795 ORDER BY pc.product_category_id ASC
235μs648B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15972 ORDER BY pc.product_category_id ASC
205μs616B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15972 ORDER BY pc.product_category_id ASC
201μs616B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15972 ORDER BY pc.product_category_id ASC
203μs616B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15972 ORDER BY pc.product_category_id ASC
202μs616B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15915 ORDER BY pc.product_category_id ASC
167μs584B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT a.id FROM m37h2_menu AS a INNER JOIN `m37h2_menu_types` as b on a.menutype = b.menutype WHERE a.type='component' AND a.published=1 AND b.title IS NOT NULL AND a.access IN (1,2,5) AND a.client_id=0 AND a.link LIKE 'index.php?option=com_hikashop&view=category&layout=%' AND a.language IN ('*', '', 'en-GB')
570μs1.38KB/administrator/components/com_hikashop/classes/menus.php:333CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15915 ORDER BY pc.product_category_id ASC
175μs584B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15915 ORDER BY pc.product_category_id ASC
207μs584B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15915 ORDER BY pc.product_category_id ASC
179μs584B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 14897 ORDER BY pc.product_category_id ASC
226μs680B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 14897 ORDER BY pc.product_category_id ASC
255μs680B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 14897 ORDER BY pc.product_category_id ASC
351μs680B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 14897 ORDER BY pc.product_category_id ASC
200μs680B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15831 ORDER BY pc.product_category_id ASC
167μs600B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15831 ORDER BY pc.product_category_id ASC
326μs600B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15831 ORDER BY pc.product_category_id ASC
249μs600B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15831 ORDER BY pc.product_category_id ASC
218μs600B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 11542 ORDER BY pc.product_category_id ASC
261μs680B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 11542 ORDER BY pc.product_category_id ASC
225μs680B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 11542 ORDER BY pc.product_category_id ASC
242μs680B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 11542 ORDER BY pc.product_category_id ASC
207μs680B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 12705 ORDER BY pc.product_category_id ASC
256μs584B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 12705 ORDER BY pc.product_category_id ASC
201μs584B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 12705 ORDER BY pc.product_category_id ASC
212μs584B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 12705 ORDER BY pc.product_category_id ASC
209μs584B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15540 ORDER BY pc.product_category_id ASC
250μs648B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15540 ORDER BY pc.product_category_id ASC
221μs648B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15540 ORDER BY pc.product_category_id ASC
208μs648B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15540 ORDER BY pc.product_category_id ASC
224μs648B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 14916 ORDER BY pc.product_category_id ASC
237μs648B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 14916 ORDER BY pc.product_category_id ASC
218μs648B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 14916 ORDER BY pc.product_category_id ASC
202μs648B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT c.category_id FROM m37h2_hikashop_product_category AS pc INNER JOIN m37h2_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 14916 ORDER BY pc.product_category_id ASC
201μs648B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM m37h2_fields AS a
LEFT JOIN `m37h2_languages` AS l ON l.lang_code = a.language
LEFT JOIN m37h2_users AS uc ON uc.id=a.checked_out
LEFT JOIN m37h2_viewlevels AS ag ON ag.id = a.access
LEFT JOIN m37h2_users AS ua ON ua.id = a.created_user_id
LEFT JOIN m37h2_fields_groups AS g ON g.id = a.group_id
WHERE
(
(`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray4,:preparedArray5,:preparedArray6)) AND `a`.`state` = :state) AND
(`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform
ORDER BY a.ordering ASC
1.02ms4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT *
FROM `m37h2_rsform_forms`
WHERE `FormId`='3'
552μs10.41KB/administrator/components/com_rsform/helpers/rsform.php:3635CopySELECT `Lang`
FROM m37h2_rsform_forms
WHERE `FormId` = '3'
134μs536B/administrator/components/com_rsform/helpers/rsform.php:2956CopySELECT `ComponentId`
FROM `m37h2_rsform_components`
WHERE `ComponentTypeId` IN (6) AND `FormId` = '3' AND `Published` = '1'
248μs520B/administrator/components/com_rsform/helpers/rsform.php:1715CopySELECT `ComponentId`
FROM `m37h2_rsform_components`
WHERE `ComponentTypeId` IN (411) AND `FormId` = '3' AND `Published` = '1'
198μs520B/administrator/components/com_rsform/helpers/rsform.php:1715CopySELECT `ComponentId`
FROM `m37h2_rsform_components`
WHERE `ComponentTypeId` IN (355) AND `FormId` = '3' AND `Published` = '1'
180μs520B/administrator/components/com_rsform/helpers/rsform.php:1715CopySELECT `p`.`PropertyValue` AS `name`,`c`.`ComponentId`,`c`.`ComponentTypeId`,`ct`.`ComponentTypeName`,`c`.`Order`
FROM `m37h2_rsform_properties` AS `p`
LEFT JOIN `m37h2_rsform_components` AS `c` ON (`c`.`ComponentId` = `p`.`ComponentId`)
LEFT JOIN `m37h2_rsform_component_types` AS `ct` ON (`ct`.`ComponentTypeId` = `c`.`ComponentTypeId`)
WHERE `c`.`FormId` = '3' AND `p`.`PropertyName` = 'NAME' AND `c`.`Published` = '1'
ORDER BY `c`.`Order` ASC
367μs816B/administrator/components/com_rsform/helpers/rsform.php:2655CopySELECT `PropertyName`,`PropertyValue`,`ComponentId`
FROM `m37h2_rsform_properties`
WHERE `ComponentId` IN (25,26,27,28)
268μs1.63KB/administrator/components/com_rsform/helpers/rsform.php:740CopySELECT `FormId`
FROM `m37h2_rsform_components`
WHERE `ComponentId`='25'
138μs536B/administrator/components/com_rsform/helpers/rsform.php:755CopySELECT `ComponentId`
FROM `m37h2_rsform_components`
WHERE `ComponentTypeId` IN (41) AND `FormId` = '3' AND `Published` = '1'
211μs520B/administrator/components/com_rsform/helpers/rsform.php:1715CopySELECT `ComponentId`
FROM `m37h2_rsform_components`
WHERE `ComponentTypeId` IN (2422) AND `FormId` = '3' AND `Published` = '1'
195μs520B/administrator/components/com_rsform/helpers/rsform.php:1715CopySELECT `ComponentId`
FROM `m37h2_rsform_components`
WHERE `ComponentTypeId` IN (9) AND `FormId` = '3' AND `Published` = '1'
171μs520B/administrator/components/com_rsform/helpers/rsform.php:1715CopySELECT `ComponentId`
FROM `m37h2_rsform_components`
WHERE `ComponentTypeId` IN (2422) AND `FormId` = '3' AND `Published` = '1'
154μs520B/administrator/components/com_rsform/helpers/rsform.php:1715CopySELECT `p`.`PropertyValue` AS `ComponentName`,`p`.`ComponentId`
FROM `m37h2_rsform_components` AS `c`
LEFT JOIN `m37h2_rsform_properties` AS `p` ON (`c`.`ComponentId`=`p`.`ComponentId`)
WHERE `c`.`FormId`='3' AND `p`.`PropertyName`='NAME' AND `c`.`Published` = '1'
ORDER BY `c`.`Order` ASC
474μs640B/administrator/components/com_rsform/helpers/conditions.php:38CopySELECT *
FROM `m37h2_rsform_conditions`
WHERE `form_id` = '3' AND `lang_code` = 'en-GB'
ORDER BY `ordering` ASC
188μs912B/administrator/components/com_rsform/helpers/conditions.php:84CopySELECT *
FROM `m37h2_rsform_calculations`
WHERE `formId` = '3'
ORDER BY `ordering`
143μs752B/administrator/components/com_rsform/helpers/rsform.php:3602CopySELECT option_value FROM m37h2_imagerecycle_options WHERE option_name ='queue_process_lastRun' LIMIT 1
131μs536B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172CopySELECT option_value FROM m37h2_imagerecycle_options WHERE option_name ='queue_process_status' LIMIT 1
71μs536B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172CopySELECT *
FROM m37h2_jmap_metainfo
WHERE `linkurl` = 'https://offeringsjewelry.com/jewelry/earrings/product/iolite-and-lapis-latch-back-earrings/category_pathway-17/related_product-14916'
AND `published` = 1
242μs912B/plugins/system/jmap/jmap.php:818CopySELECT *
FROM m37h2_jmap_canonicals
WHERE `linkurl` = 'https://offeringsjewelry.com/jewelry/earrings/product/iolite-and-lapis-latch-back-earrings/category_pathway-17/related_product-14916'
92μs640B/plugins/system/jmap/jmap.php:920CopySELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count
FROM `m37h2_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
175μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465CopySELECT `value`
FROM `m37h2_admintools_storage`
WHERE `key` = 'criticalfiles'
227μs536B/plugins/system/admintools/src/Feature/CriticalFilesMonitoring.php:185CopySELECT r.*
FROM m37h2_rereplacer AS r
WHERE r.published = 1 AND (r.area = 'head' OR r.params LIKE '%\"use_xml\":\"1\"%')
ORDER BY r.ordering, r.id
242μs1.48KB/plugins/system/rereplacer/src/Items.php:97CopySELECT r.*
FROM m37h2_rereplacer AS r
WHERE r.published = 1 AND (r.area = 'body' OR r.params LIKE '%\"use_xml\":\"1\"%')
ORDER BY r.ordering, r.id
149μs1.5KB/plugins/system/rereplacer/src/Items.php:97CopySELECT m.condition_id,m.item_id
FROM m37h2_conditions_map as m
LEFT JOIN m37h2_conditions as c ON c.id = m.condition_id
WHERE `m`.`extension` = 'com_rereplacer' AND `c`.`published` = 1
357μs576B/administrator/components/com_conditions/src/Model/ItemModel.php:831CopySELECT r.*
FROM m37h2_rereplacer AS r
WHERE r.published = 1 AND (r.area = 'everywhere' OR r.params LIKE '%\"use_xml\":\"1\"%')
ORDER BY r.ordering, r.id
378μs1.48KB/plugins/system/rereplacer/src/Items.php:97CopySELECT *
FROM m37h2_jmap_headings
WHERE `linkurl` = 'https://offeringsjewelry.com/jewelry/earrings/product/iolite-and-lapis-latch-back-earrings/category_pathway-17/related_product-14916'
195μs752B/plugins/system/jmap/jmap.php:1135CopySELECT
`original_text`,
`target_text`,
`original_text_regex`,
`target_text_regex`
FROM
`m37h2_jmap_text_replacements`
WHERE
`published` = 1
247μs688B/plugins/system/jmap/jmap.php:508CopySELECT `session_id`
FROM `m37h2_session`
WHERE `session_id` = ?
231μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277CopyUPDATE `m37h2_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
2.59ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy