$124.00$81.84 each
Sterling Moonstone Pendant with Tourmaline and Quartz (B)
PV560B
2 items in stock
What beautiful chatoyance from this Rainbow Moonstone ring! Known for its healing properties, this stone measures 14x18mm. This large size of Rainbow Moonstone is becoming harder and harder to find in this quality! Total length is just over 3/4". This ring also features stunning sterling silver scroll and bead work all hand done by the Artisans of Bali. Marianna and Richard designed this beauty and added an open band for adjusting up to one ring size larger.
Please note: some Rainbow Moonstones contain dark spots within the genuine gemstone. Also, some of the solid Sterling silver bands have gentle scuffing. These factors have resulted in a deep discount for you!
What beautiful chatoyance from this Rainbow Moonstone ring! Known for its healing properties, this stone measures 14x18mm. This large size of Rainbow Moonstone is becoming harder and harder to find in this quality! Total length is just over 3/4". This ring also features stunning sterling silver scroll and bead work all hand done by the Artisans of Bali. Marianna and Richard designed this beauty and added an open band for adjusting up to one ring size larger.
Please note: some Rainbow Moonstones contain dark spots within the genuine gemstone. Also, some of the solid Sterling silver bands have gentle scuffing. These factors have resulted in a deep discount for you!
Joomla! Version | 5.2.3 |
PHP Version | 8.3.17 |
Identity | guest |
Response | 200 |
Template | g5_helium |
Database |
|
1 x afterRender (544.84KB) (21.23%) | 99.59ms |
1 x afterInitialise (2.92MB) (20.31%) | 95.25ms |
1 x beforeRenderRawModule mod_custom (Our Friends) (2MB) (16.79%) | 78.77ms |
1 x afterRoute (2.67MB) (11.98%) | 56.17ms |
1 x afterRenderRawModule mod_hikashop (Related products) (1.66MB) (11.01%) | 51.66ms |
1 x beforeRenderRawModule mod_gantry5_particle (Menu Search) (922.23KB) (3.55%) | 16.64ms |
1 x afterRenderRawModule mod_custom (Signup For Our Newsletter) (567.3KB) (2.66%) | 12.50ms |
1 x beforeRenderRawModule mod_gantry5_particle (Topbar Account) (570.45KB) (2.55%) | 11.96ms |
1 x afterDispatch (56.52KB) (2.17%) | 10.18ms |
1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (283.66KB) (2.04%) | 9.57ms |
1 x afterRenderRawModule mod_login (My Account) (53.88KB) (0.8%) | 3.73ms |
1 x beforeRenderRawModule mod_login (My Account) (126.68KB) (0.61%) | 2.86ms |
1 x afterRenderRawModule mod_hikashop_cart (HikaShop Cart Module) (51.81KB) (0.57%) | 2.66ms |
1 x beforeRenderRawModule mod_hikashop_cart (HikaShop Cart Module) (55.05KB) (0.46%) | 2.15ms |
1 x afterRenderModule mod_hikashop (Related products) (43.84KB) (0.44%) | 2.07ms |
1 x beforeRenderRawModule mod_custom (Signup For Our Newsletter) (19.49KB) (0.36%) | 1.68ms |
1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (11.26KB) (0.35%) | 1.63ms |
1 x afterRenderRawModule mod_gantry5_particle (Menu Search) (8.23KB) (0.25%) | 1.16ms |
1 x afterRenderRawModule mod_gantry5_particle (Topbar Account) (80.17KB) (0.18%) | 835μs |
1 x afterRenderModule mod_login (My Account) (10.92KB) (0.17%) | 805μs |
1 x afterRenderModule mod_gantry5_particle (Topbar Account) (19KB) (0.17%) | 778μs |
1 x afterRenderRawModule mod_custom (Our Friends) (4.48KB) (0.17%) | 774μs |
1 x afterLoad (110.8KB) (0.15%) | 717μs |
1 x beforeRenderRawModule mod_hikashop (Related products) (49.72KB) (0.12%) | 560μs |
1 x beforeRenderComponent com_hikashop (33.23KB) (0.12%) | 558μs |
1 x beforeRenderRawModule mod_hikashop_filter (Narrow Your Choices) (63.67KB) (0.1%) | 492μs |
1 x afterRenderModule mod_custom (Our Friends) (44.27KB) (0.1%) | 485μs |
1 x afterRenderModule mod_gantry5_particle (Menu Search) (31.24KB) (0.1%) | 455μs |
1 x afterRenderModule mod_custom (Signup For Our Newsletter) (8.5KB) (0.09%) | 415μs |
1 x afterRenderModule mod_hikashop_cart (HikaShop Cart Module) (5.91KB) (0.09%) | 407μs |
1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.92KB) (0.06%) | 300μs |
1 x afterRenderRawModule mod_hikashop_filter (Narrow Your Choices) (3.5KB) (0.06%) | 275μs |
1 x afterRenderComponent com_hikashop (18.53KB) (0.04%) | 178μs |
1 x afterRenderModule mod_hikashop_filter (Narrow Your Choices) (2.48KB) (0.03%) | 139μs |
1 x beforeRenderModule mod_login (My Account) (720B) (0%) | 15μs |
1 x beforeRenderModule mod_custom (Signup For Our Newsletter) (736B) (0%) | 15μs |
1 x beforeRenderModule mod_custom (Our Friends) (720B) (0%) | 12μs |
1 x beforeRenderModule mod_hikashop_cart (HikaShop Cart Module) (736B) (0%) | 12μs |
1 x beforeRenderModule mod_hikashop (Related products) (720B) (0%) | 12μs |
1 x beforeRenderModule mod_gantry5_particle (Topbar Account) (736B) (0%) | 9μs |
1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%) | 8μs |
1 x beforeRenderModule mod_gantry5_particle (Menu Search) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_hikashop_filter (Narrow Your Choices) (736B) (0%) | 5μs |
SELECT @@SESSION.sql_mode;
83μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308CopySELECT `data`
FROM `m37h2_session`
WHERE `session_id` = ?
174μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250CopySELECT `session_id`
FROM `m37h2_session`
WHERE `session_id` = :session_id LIMIT 1
73μ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.12ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `id`,`rules`
FROM `m37h2_viewlevels`
132μ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
230μs1.34KBParams/libraries/src/Access/Access.php:868CopySELECT `value`
FROM `m37h2_admintools_storage`
WHERE `key` = 'cparams'
194μs536B/administrator/components/com_admintools/src/Helper/Storage.php:120CopySELECT `option`,`view`,`query`
FROM `m37h2_admintools_wafexceptions`
87μs640B/plugins/system/admintools/src/Utility/Cache.php:196CopySELECT `params`
FROM `m37h2_extensions`
WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'
266μs1.15KB/plugins/system/admintools/src/Utility/RescueUrl.php:324CopySELECT manifest_cache FROM m37h2_extensions WHERE element = 'com_logman'
253μs536B/plugins/koowa/logman/logman.php:153CopySELECT `params`
FROM `m37h2_extensions`
WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'
315μs536B/plugins/system/admintools/src/Utility/RescueUrl.php:324CopySELECT *
FROM `m37h2_admintools_ipautoban`
92μs656B/plugins/system/admintools/src/Utility/Cache.php:126CopySELECT `ip`
FROM `m37h2_admintools_ipblock`
59μs520B/plugins/system/admintools/src/Utility/Cache.php:136CopySELECT *
FROM `m37h2_admintools_storage`
WHERE `key` LIKE 'timestamp_%'
102μs592B/plugins/system/admintools/src/Feature/Base.php:253CopySELECT `source`,`dest`,`keepurlparams`
FROM `m37h2_admintools_redirects`
WHERE `published` = 1
ORDER BY `ordering` ASC
216μs640B/plugins/system/admintools/src/Utility/Cache.php:162CopySELECT *
FROM m37h2_rsform_config
171μs1.19KB/administrator/components/com_rsform/helpers/config.php:52CopySELECT * FROM m37h2_hikashop_config
702μs381.88KB/administrator/components/com_hikashop/classes/config.php:16CopySET sql_mode=(SELECT REPLACE(REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''), 'STRICT_TRANS_TABLES', ''));
65μs0B/administrator/components/com_hikashop/helpers/helper.php:3561CopySELECT product_id FROM m37h2_hikashop_product WHERE product_alias = 'large-oval-rainbow-moonstone-silver-ring'
6.4ms536B/components/com_hikashop/router.php:363CopySELECT product_id FROM m37h2_hikashop_product WHERE product_alias = 'category_pathway-54'
5.52ms520B/components/com_hikashop/router.php:363CopySELECT * FROM m37h2_hikashop_product WHERE product_alias REGEXP '^ *p?category_pathway.+54 *$' OR product_name REGEXP '^ *p?category_pathway.+54 *$'
7.5ms5.48KB/components/com_hikashop/router.php:380CopySELECT product_id FROM m37h2_hikashop_product WHERE product_alias = 'related_product-11246'
4.36ms520B/components/com_hikashop/router.php:363CopySELECT * FROM m37h2_hikashop_product WHERE product_alias REGEXP '^ *p?related_product.+11246 *$' OR product_name REGEXP '^ *p?related_product.+11246 *$'
6.93ms5.48KB/components/com_hikashop/router.php:380CopySELECT `option`,`view`,`task`,`query`,`query_type`,`query_content`,`verb`,`application`
FROM `m37h2_admintools_wafblacklists`
WHERE `enabled` = 1
278μ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
387μs784B/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69CopySELECT DISTINCT a.*
FROM `m37h2_ampz` AS a LIMIT 20
149μ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 = 13580) AND ((product.product_access = 'all' OR product.product_access LIKE '%,9,%')) LIMIT 1
455μs21.84KB/components/com_hikashop/views/product/view.html.php:1458CopySELECT * FROM m37h2_modules WHERE id IN (155,0) AND language IN ('*', '', 'en-GB')
335μ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 = 'rubqkr5ct1t3b25d752c2u4cep') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
351μs520B/administrator/components/com_hikashop/classes/cart.php:69CopySELECT * FROM m37h2_hikashop_currency WHERE currency_id IN (2)
147μs1.44KB/administrator/components/com_hikashop/classes/currency.php:2019CopyUPDATE m37h2_hikashop_product SET product_hit = product_hit + 1, product_last_seen_date = 1739631582 WHERE product_id = 13580
180μ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 = 13580) AND (pr.product_related_type = 'options') AND (p.product_published = 1) AND ((p.product_sale_start = '' OR p.product_sale_start <= 1739631582)) AND ((p.product_sale_end = '' OR p.product_sale_end > 1739631582)) AND ((p.product_access = 'all' OR p.product_access LIKE '%,9,%')) ORDER BY pr.product_related_ordering ASC, pr.product_related_id ASC
476μ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 = 13580 AND pr.product_related_type = 'bundle' ORDER BY pr.product_related_ordering ASC, pr.product_related_id ASC
387μs8.02KB/components/com_hikashop/views/product/view.html.php:1593CopySELECT * FROM m37h2_hikashop_product WHERE (product_parent_id IN (13580)) AND (product_published = 1) AND ((product_access = 'all' OR product_access LIKE '%,9,%'))
378μs5.53KB/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 (13580,13581,15714,15715) ORDER BY v.ordering ASC, c.characteristic_id ASC
264μs1.53KB/components/com_hikashop/views/product/view.html.php:1662CopySELECT * FROM m37h2_hikashop_file WHERE file_ref_id IN (13580,13581,15714,15715) AND file_type IN ('product','file') AND (file_access = 'all' OR file_access LIKE '%,9,%') ORDER BY file_ordering ASC, file_id ASC
2.02ms1.44KB/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 = 'rubqkr5ct1t3b25d752c2u4cep') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
187μs520B/administrator/components/com_hikashop/classes/cart.php:69CopySELECT currency_id FROM m37h2_hikashop_currency WHERE currency_published=1 OR currency_id = 2
236μ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 < 1739631582) AND ((p.price_end_date < 1 OR p.price_end_date > 1739631582)) AND (p.price_product_id IN (13580,13581,15714,15715)) 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
309μ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 < 1739631582) AND (discount_end > 1739631582 OR discount_end = 0) AND (discount_product_id IN ('','0','13580','13581','15714','15715') OR discount_product_id LIKE '%,13580,%' OR discount_product_id LIKE '%,13581,%' OR discount_product_id LIKE '%,15714,%' OR discount_product_id LIKE '%,15715,%') 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,%'))
570μ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)
141μ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,%')
234μs536B/administrator/components/com_hikashop/classes/currency.php:1267CopySELECT product_id FROM m37h2_hikashop_product_category WHERE category_id IN (96,96)
216μs8.51KB/administrator/components/com_hikashop/classes/currency.php:1283CopySELECT product_id FROM m37h2_hikashop_product WHERE product_manufacturer_id IN (96,96)
4.53ms520B/administrator/components/com_hikashop/classes/currency.php:1287CopySELECT 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 = 13580) AND ((b.category_access = 'all' OR b.category_access LIKE '%,9,%'))
610μ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 = 13580) AND ((b.category_access = 'all' OR b.category_access LIKE '%,9,%'))
143μs576B/administrator/components/com_hikashop/classes/currency.php:1625CopySELECT category_id, category_left, category_right FROM m37h2_hikashop_category WHERE category_id IN (64,50)
122μ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,%')
148μs552B/administrator/components/com_hikashop/classes/currency.php:1267CopySELECT product_id FROM m37h2_hikashop_product_category WHERE category_id IN (50,64,50,64)
527μ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.83ms520B/administrator/components/com_hikashop/classes/currency.php:1287CopySELECT category_id, category_left, category_right FROM m37h2_hikashop_category WHERE category_id IN (74)
165μ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,%')
248μs536B/administrator/components/com_hikashop/classes/currency.php:1267CopySELECT product_id FROM m37h2_hikashop_product_category WHERE category_id IN (74,74)
369μs12.51KB/administrator/components/com_hikashop/classes/currency.php:1283CopySELECT product_id FROM m37h2_hikashop_product WHERE product_manufacturer_id IN (74,74)
4.42ms520B/administrator/components/com_hikashop/classes/currency.php:1287CopySELECT * FROM m37h2_menu WHERE id = '725' LIMIT 1
337μs2.84KB/administrator/components/com_hikashop/helpers/helper.php:2771CopySELECT * FROM m37h2_hikashop_category WHERE category_id = '23' LIMIT 1
241μ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 = 54 AND hk_parent.category_left >= 5 AND hk_parent.category_right <= 6 ORDER BY hk_parent.category_left
170μs2.77KB/administrator/components/com_hikashop/classes/category.php:780CopySELECT * FROM m37h2_hikashop_product WHERE product_id = '11246' LIMIT 1
330μs5.5KB/administrator/components/com_hikashop/helpers/helper.php:2771CopySELECT category_id FROM m37h2_hikashop_product_category WHERE product_id IN (13580) ORDER BY ordering ASC
223μ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 (46,57,96,15,23,37,38,42,45,91) ORDER BY hk_parent.category_left
222μ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
155μ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 '%,46,%' OR field_categories LIKE '%,57,%' OR field_categories LIKE '%,96,%' OR field_categories LIKE '%,15,%' OR field_categories LIKE '%,23,%' OR field_categories LIKE '%,37,%' OR field_categories LIKE '%,38,%' OR field_categories LIKE '%,42,%' OR field_categories LIKE '%,45,%' 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 '%,23,%' OR field_categories LIKE '%,37,%' OR field_categories LIKE '%,38,%' OR field_categories LIKE '%,42,%' OR field_categories LIKE '%,45,%' OR field_categories LIKE '%,46,%' OR field_categories LIKE '%,57,%' OR field_categories LIKE '%,91,%' OR field_categories LIKE '%,96,%' OR field_categories LIKE '%,15,%'))) AND field_products="") OR (field_products LIKE '%,13580,%')) ORDER BY a.`field_ordering` ASC
328μ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='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 '%,46,%' OR field_categories LIKE '%,57,%' OR field_categories LIKE '%,96,%' OR field_categories LIKE '%,15,%' OR field_categories LIKE '%,23,%' OR field_categories LIKE '%,37,%' OR field_categories LIKE '%,38,%' OR field_categories LIKE '%,42,%' OR field_categories LIKE '%,45,%' 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 '%,23,%' OR field_categories LIKE '%,37,%' OR field_categories LIKE '%,38,%' OR field_categories LIKE '%,42,%' OR field_categories LIKE '%,45,%' OR field_categories LIKE '%,46,%' OR field_categories LIKE '%,57,%' OR field_categories LIKE '%,91,%' OR field_categories LIKE '%,96,%' OR field_categories LIKE '%,15,%'))) AND field_products="") OR (field_products LIKE '%,13581,%' OR field_products LIKE '%,13580,%')) ORDER BY a.`field_ordering` ASC
326μ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 '%,46,%' OR field_categories LIKE '%,57,%' OR field_categories LIKE '%,96,%' OR field_categories LIKE '%,15,%' OR field_categories LIKE '%,23,%' OR field_categories LIKE '%,37,%' OR field_categories LIKE '%,38,%' OR field_categories LIKE '%,42,%' OR field_categories LIKE '%,45,%' 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 '%,23,%' OR field_categories LIKE '%,37,%' OR field_categories LIKE '%,38,%' OR field_categories LIKE '%,42,%' OR field_categories LIKE '%,45,%' OR field_categories LIKE '%,46,%' OR field_categories LIKE '%,57,%' OR field_categories LIKE '%,91,%' OR field_categories LIKE '%,96,%' OR field_categories LIKE '%,15,%'))) AND field_products="") OR (field_products LIKE '%,13581,%' OR field_products LIKE '%,13580,%')) ORDER BY a.`field_ordering` ASC
363μs13.73KB/administrator/components/com_hikashop/classes/field.php:167CopySELECT a.* FROM m37h2_hikashop_badge AS a WHERE a.badge_start <= 1739631582 AND (a.badge_end >= 1739631582 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = 0) AND (a.badge_new_period = 0 OR a.badge_new_period >= 235604114) 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 = '46' OR badge_category_id LIKE '%,46,%' OR badge_category_id = '57' OR badge_category_id LIKE '%,57,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '15' OR badge_category_id LIKE '%,15,%' OR badge_category_id = '23' OR badge_category_id LIKE '%,23,%' 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 = '42' OR badge_category_id LIKE '%,42,%' OR badge_category_id = '45' OR badge_category_id LIKE '%,45,%' 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 = '23' OR badge_category_id LIKE '%,23,%' 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 = '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 = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '15' OR badge_category_id LIKE '%,15,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
312μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM m37h2_hikashop_badge AS a WHERE a.badge_start <= 1739631582 AND (a.badge_end >= 1739631582 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 >= 96503587) 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 = '46' OR badge_category_id LIKE '%,46,%' OR badge_category_id = '57' OR badge_category_id LIKE '%,57,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '15' OR badge_category_id LIKE '%,15,%' OR badge_category_id = '23' OR badge_category_id LIKE '%,23,%' 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 = '42' OR badge_category_id LIKE '%,42,%' OR badge_category_id = '45' OR badge_category_id LIKE '%,45,%' 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 = '23' OR badge_category_id LIKE '%,23,%' 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 = '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 = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '15' OR badge_category_id LIKE '%,15,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
284μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM m37h2_hikashop_badge AS a WHERE a.badge_start <= 1739631582 AND (a.badge_end >= 1739631582 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = 0) AND (a.badge_new_period = 0 OR a.badge_new_period >= 96503596) 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 = '46' OR badge_category_id LIKE '%,46,%' OR badge_category_id = '57' OR badge_category_id LIKE '%,57,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '15' OR badge_category_id LIKE '%,15,%' OR badge_category_id = '23' OR badge_category_id LIKE '%,23,%' 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 = '42' OR badge_category_id LIKE '%,42,%' OR badge_category_id = '45' OR badge_category_id LIKE '%,45,%' 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 = '23' OR badge_category_id LIKE '%,23,%' 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 = '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 = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '15' OR badge_category_id LIKE '%,15,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
311μ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 = 54 LIMIT 1
533μs4.59KB/administrator/components/com_hikashop/classes/category.php:35CopySELECT * FROM m37h2_menu WHERE id = '725' LIMIT 1
401μs2.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 = 54) 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
2.77ms2.01KB/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 = 13580 ORDER BY a.product_category_id ASC
377μ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')
645μ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')
537μ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
503μs1.64KB/plugins/hikashop/shippingmanual_prices/shippingmanual_prices.php:45CopySELECT * FROM m37h2_extensions WHERE folder='hikashop' AND element='shippingmanual_prices' AND type='plugin'
331μs2.53KB/administrator/components/com_hikashop/classes/plugins.php:113CopySELECT * FROM m37h2_extensions WHERE folder='system' AND element='hikashopsocial' AND type='plugin'
271μs2.53KB/administrator/components/com_hikashop/classes/plugins.php:113CopySELECT * FROM m37h2_extensions WHERE folder='content' AND element='hikashopsocial' AND type='plugin'
219μ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)
480μ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
224μ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')
205μs568B/plugins/system/tabsaccordions/src/Sets.php:160CopySELECT LOWER(REPLACE(u.title, " ", ""))
FROM m37h2_usergroups as u
WHERE u.id IN ('1','2','9')
120μs568B/plugins/system/tabsaccordions/src/Sets.php:434CopySELECT option_value FROM m37h2_imagerecycle_options WHERE option_name ='queue_process_lastRun' LIMIT 1
173μs536B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172CopySELECT option_value FROM m37h2_imagerecycle_options WHERE option_name ='queue_process_status' LIMIT 1
96μs536B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172CopySELECT * FROM m37h2_extensions WHERE folder='hikashop' AND element='google_products' AND type='plugin'
254μ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 = 13580
99μ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
100μs536B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172CopySELECT option_value FROM m37h2_imagerecycle_options WHERE option_name ='queue_process_status' LIMIT 1
109μ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')
954μ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 = 13580 ORDER BY pc.product_category_id ASC
288μs680B/administrator/components/com_hikashop/helpers/helper.php:1260CopySELECT `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)
396μs4KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT option_value FROM m37h2_imagerecycle_options WHERE option_name ='queue_process_lastRun' LIMIT 1
153μs536B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172CopySELECT option_value FROM m37h2_imagerecycle_options WHERE option_name ='queue_process_status' LIMIT 1
162μs536B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172CopySELECT `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)
449μs4KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT option_value FROM m37h2_imagerecycle_options WHERE option_name ='queue_process_lastRun' LIMIT 1
170μs536B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172CopySELECT option_value FROM m37h2_imagerecycle_options WHERE option_name ='queue_process_status' LIMIT 1
189μs536B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172CopySELECT `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)
478μs36KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT option_value FROM m37h2_imagerecycle_options WHERE option_name ='queue_process_lastRun' LIMIT 1
178μs536B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172CopySELECT option_value FROM m37h2_imagerecycle_options WHERE option_name ='queue_process_status' LIMIT 1
158μs536B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172CopySELECT 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
412μs1.48KB/plugins/system/rereplacer/src/Items.php:97CopySELECT `content`
FROM `m37h2_modules`
WHERE `published` = 1 AND `client_id` = 0 AND `content` <> ''
387μs616B/plugins/system/ampz/helper.php:88CopySELECT `a`.`menutype`,`a`.`title`
FROM `m37h2_menu_types` AS `a`
WHERE `a`.`client_id` = 0
307μ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
969μ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
583μ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
466μ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 = 'rubqkr5ct1t3b25d752c2u4cep') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
386μ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
710μ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 = 'rubqkr5ct1t3b25d752c2u4cep') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
454μ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')
170μ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
248μ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
157μ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
163μ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
541μ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=13580) 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
1.92ms21.55KB/components/com_hikashop/views/product/view.html.php:1082CopySELECT * FROM m37h2_hikashop_file WHERE file_ref_id IN (15726,16226,12925,11246) AND file_type IN ('product','file') ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
2.5ms1.52KB/administrator/components/com_hikashop/classes/product.php:2466CopySELECT variant_product_id FROM m37h2_hikashop_variant WHERE variant_product_id IN (15726,16226,12925,11246)
219μs552B/administrator/components/com_hikashop/classes/product.php:2494CopySELECT product_id FROM m37h2_hikashop_product_related WHERE product_related_type = 'options' AND product_id IN (15726,16226,12925,11246)
645μ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 = 'rubqkr5ct1t3b25d752c2u4cep') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
325μ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 ('15726','16226','12925','11246') AND product_published = 1 AND product_type = 'variant' AND product_sale_start < 1739631582 AND (product_sale_end > 1739631582 OR product_sale_end = 0)
510μs656B/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 < 1739631582 AND (discount_end > 1739631582 OR discount_end = 0) AND ( (discount_product_id IN ('','0','15726','16226','12925','11246')) OR (discount_product_id LIKE '%,15726,%') OR (discount_product_id LIKE '%,16226,%') OR (discount_product_id LIKE '%,12925,%') OR (discount_product_id LIKE '%,11246,%') OR (discount_product_id LIKE '%,15729,%') ) 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,%')
516μ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 (15726,16226,12925,11246) AND a.price_currency_id IN (2) AND a.price_start_date < 1739631582 AND (a.price_end_date < 1 OR a.price_end_date > 1739631582) 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
331μs1.52KB/administrator/components/com_hikashop/classes/currency.php:589CopySELECT * FROM m37h2_hikashop_currency WHERE currency_id IN (2)
145μ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 = 16226) AND ((b.category_access = 'all' OR b.category_access LIKE '%,9,%'))
561μs896B/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 = 16226) AND ((b.category_access = 'all' OR b.category_access LIKE '%,9,%'))
155μs576B/administrator/components/com_hikashop/classes/currency.php:1625CopySELECT 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 = 11246) AND ((b.category_access = 'all' OR b.category_access LIKE '%,9,%'))
485μ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 = 11246) AND ((b.category_access = 'all' OR b.category_access LIKE '%,9,%'))
217μ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 (15726,16226,12925,11246);
517μs51.61KB/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,37,57,46,45,42,15,91,23) ORDER BY hk_parent.category_left
212μs736B/administrator/components/com_hikashop/classes/category.php:780CopySELECT a.* FROM m37h2_hikashop_badge AS a WHERE a.badge_start <= 1739631582 AND (a.badge_end >= 1739631582 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 >= 94602646) 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 = '37' OR badge_category_id LIKE '%,37,%' 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 = '23' OR badge_category_id LIKE '%,23,%')) 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 = '23' OR badge_category_id LIKE '%,23,%' 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 = '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
293μs10.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 (38,51,65,74,58,82,46,45,42,15,91,17) ORDER BY hk_parent.category_left
209μs768B/administrator/components/com_hikashop/classes/category.php:780CopySELECT a.* FROM m37h2_hikashop_badge AS a WHERE a.badge_start <= 1739631582 AND (a.badge_end >= 1739631582 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 >= 9408393) AND (badge_discount_id = 309 OR badge_discount_id = '0' OR badge_discount_id = '' OR badge_discount_id LIKE '%,309,%') 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 = '51' OR badge_category_id LIKE '%,51,%' OR badge_category_id = '65' OR badge_category_id LIKE '%,65,%' OR badge_category_id = '74' OR badge_category_id LIKE '%,74,%' OR badge_category_id = '58' OR badge_category_id LIKE '%,58,%' 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 = '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 = '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 = '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 = '82' OR badge_category_id LIKE '%,82,%' OR badge_category_id = '51' OR badge_category_id LIKE '%,51,%' OR badge_category_id = '58' OR badge_category_id LIKE '%,58,%' OR badge_category_id = '91' OR badge_category_id LIKE '%,91,%' OR badge_category_id = '15' OR badge_category_id LIKE '%,15,%' OR badge_category_id = '65' OR badge_category_id LIKE '%,65,%' OR badge_category_id = '74' OR badge_category_id LIKE '%,74,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
310μ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 (15,57,45,42,91,13) ORDER BY hk_parent.category_left
203μs672B/administrator/components/com_hikashop/classes/category.php:780CopySELECT a.* FROM m37h2_hikashop_badge AS a WHERE a.badge_start <= 1739631582 AND (a.badge_end >= 1739631582 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = 30) AND (a.badge_new_period = 0 OR a.badge_new_period >= 268700455) 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 = '15' OR badge_category_id LIKE '%,15,%' OR badge_category_id = '57' OR badge_category_id LIKE '%,57,%' 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 = '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 = '42' OR badge_category_id LIKE '%,42,%' OR badge_category_id = '45' OR badge_category_id LIKE '%,45,%' 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
272μ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 (49,52,82,45,40,74,13,15,57) ORDER BY hk_parent.category_left
162μs736B/administrator/components/com_hikashop/classes/category.php:780CopySELECT a.* FROM m37h2_hikashop_badge AS a WHERE a.badge_start <= 1739631582 AND (a.badge_end >= 1739631582 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 >= 337600782) AND (badge_discount_id = 309 OR badge_discount_id = '0' OR badge_discount_id = '' OR badge_discount_id LIKE '%,309,%') 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 = '49' OR badge_category_id LIKE '%,49,%' OR badge_category_id = '52' OR badge_category_id LIKE '%,52,%' OR badge_category_id = '82' OR badge_category_id LIKE '%,82,%' OR badge_category_id = '45' OR badge_category_id LIKE '%,45,%' OR badge_category_id = '40' OR badge_category_id LIKE '%,40,%' OR badge_category_id = '74' OR badge_category_id LIKE '%,74,%' OR badge_category_id = '13' OR badge_category_id LIKE '%,13,%' OR badge_category_id = '15' OR badge_category_id LIKE '%,15,%' OR badge_category_id = '57' OR badge_category_id LIKE '%,57,%')) 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 = '40' OR badge_category_id LIKE '%,40,%' OR badge_category_id = '45' OR badge_category_id LIKE '%,45,%' OR badge_category_id = '82' OR badge_category_id LIKE '%,82,%' OR badge_category_id = '49' OR badge_category_id LIKE '%,49,%' OR badge_category_id = '52' OR badge_category_id LIKE '%,52,%' OR badge_category_id = '57' OR badge_category_id LIKE '%,57,%' OR badge_category_id = '15' OR badge_category_id LIKE '%,15,%' OR badge_category_id = '74' OR badge_category_id LIKE '%,74,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
224μ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,37,57,46,45,42,15,91,23,51,65,74,58,82,17,13,49,52,40) ORDER BY hk_parent.category_left
214μs960B/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) ORDER BY hk_parent.category_left
175μs752B/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
81μ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 '%,37,%' 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 '%,23,%' OR field_categories LIKE '%,51,%' OR field_categories LIKE '%,65,%' OR field_categories LIKE '%,74,%' OR field_categories LIKE '%,58,%' OR field_categories LIKE '%,82,%' OR field_categories LIKE '%,17,%' OR field_categories LIKE '%,13,%' OR field_categories LIKE '%,49,%' OR field_categories LIKE '%,52,%' OR field_categories LIKE '%,40,%'))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 '%,23,%' OR field_categories LIKE '%,17,%' OR field_categories LIKE '%,13,%' OR field_categories LIKE '%,37,%' OR field_categories LIKE '%,38,%' OR field_categories LIKE '%,40,%' OR field_categories LIKE '%,42,%' OR field_categories LIKE '%,45,%' OR field_categories LIKE '%,46,%' OR field_categories LIKE '%,82,%' OR field_categories LIKE '%,49,%' OR field_categories LIKE '%,51,%' OR field_categories LIKE '%,52,%' OR field_categories LIKE '%,57,%' OR field_categories LIKE '%,58,%' OR field_categories LIKE '%,91,%' OR field_categories LIKE '%,15,%' OR field_categories LIKE '%,65,%' OR field_categories LIKE '%,74,%'))) AND field_products="") OR (field_products LIKE '%,11246,%' OR field_products LIKE '%,12925,%' OR field_products LIKE '%,15726,%' OR field_products LIKE '%,16226,%')) ORDER BY a.`field_ordering` ASC
376μ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 '%,37,%' 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 '%,23,%' OR field_categories LIKE '%,51,%' OR field_categories LIKE '%,65,%' OR field_categories LIKE '%,74,%' OR field_categories LIKE '%,58,%' OR field_categories LIKE '%,82,%' OR field_categories LIKE '%,17,%' OR field_categories LIKE '%,13,%' OR field_categories LIKE '%,49,%' OR field_categories LIKE '%,52,%' OR field_categories LIKE '%,40,%'))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 '%,23,%' OR field_categories LIKE '%,17,%' OR field_categories LIKE '%,13,%' OR field_categories LIKE '%,37,%' OR field_categories LIKE '%,38,%' OR field_categories LIKE '%,40,%' OR field_categories LIKE '%,42,%' OR field_categories LIKE '%,45,%' OR field_categories LIKE '%,46,%' OR field_categories LIKE '%,82,%' OR field_categories LIKE '%,49,%' OR field_categories LIKE '%,51,%' OR field_categories LIKE '%,52,%' OR field_categories LIKE '%,57,%' OR field_categories LIKE '%,58,%' OR field_categories LIKE '%,91,%' OR field_categories LIKE '%,15,%' OR field_categories LIKE '%,65,%' OR field_categories LIKE '%,74,%'))) AND field_products="") OR (field_products LIKE '%,11246,%' OR field_products LIKE '%,12925,%' OR field_products LIKE '%,15726,%' OR field_products LIKE '%,16226,%')) ORDER BY a.`field_ordering` ASC
237μ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=13580) 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
668μ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;
105μ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 = 15726 ORDER BY pc.product_category_id ASC
227μ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 = 15726 ORDER BY pc.product_category_id ASC
245μ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 = 15726 ORDER BY pc.product_category_id ASC
192μ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 = 15726 ORDER BY pc.product_category_id ASC
201μ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 = 15726 ORDER BY pc.product_category_id ASC
228μ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 = 16226 ORDER BY pc.product_category_id ASC
280μs712B/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 = 16226 ORDER BY pc.product_category_id ASC
266μs712B/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 = 16226 ORDER BY pc.product_category_id ASC
265μs712B/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 = 16226 ORDER BY pc.product_category_id ASC
302μs712B/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 = 12925 ORDER BY pc.product_category_id ASC
243μ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 = 12925 ORDER BY pc.product_category_id ASC
268μ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 = 12925 ORDER BY pc.product_category_id ASC
301μ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 = 12925 ORDER BY pc.product_category_id ASC
279μ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 = 11246 ORDER BY pc.product_category_id ASC
360μ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 = 11246 ORDER BY pc.product_category_id ASC
322μ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 = 11246 ORDER BY pc.product_category_id ASC
338μ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 = 11246 ORDER BY pc.product_category_id ASC
291μs680B/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.11ms4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT *
FROM `m37h2_rsform_forms`
WHERE `FormId`='3'
496μs10.41KB/administrator/components/com_rsform/helpers/rsform.php:3635CopySELECT `Lang`
FROM m37h2_rsform_forms
WHERE `FormId` = '3'
120μs536B/administrator/components/com_rsform/helpers/rsform.php:2956CopySELECT `ComponentId`
FROM `m37h2_rsform_components`
WHERE `ComponentTypeId` IN (6) AND `FormId` = '3' AND `Published` = '1'
207μs520B/administrator/components/com_rsform/helpers/rsform.php:1715CopySELECT `ComponentId`
FROM `m37h2_rsform_components`
WHERE `ComponentTypeId` IN (411) AND `FormId` = '3' AND `Published` = '1'
148μs520B/administrator/components/com_rsform/helpers/rsform.php:1715CopySELECT `ComponentId`
FROM `m37h2_rsform_components`
WHERE `ComponentTypeId` IN (355) AND `FormId` = '3' AND `Published` = '1'
145μ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
314μs816B/administrator/components/com_rsform/helpers/rsform.php:2655CopySELECT `PropertyName`,`PropertyValue`,`ComponentId`
FROM `m37h2_rsform_properties`
WHERE `ComponentId` IN (25,26,27,28)
211μs1.63KB/administrator/components/com_rsform/helpers/rsform.php:740CopySELECT `FormId`
FROM `m37h2_rsform_components`
WHERE `ComponentId`='25'
102μs536B/administrator/components/com_rsform/helpers/rsform.php:755CopySELECT `ComponentId`
FROM `m37h2_rsform_components`
WHERE `ComponentTypeId` IN (41) AND `FormId` = '3' AND `Published` = '1'
181μs520B/administrator/components/com_rsform/helpers/rsform.php:1715CopySELECT `ComponentId`
FROM `m37h2_rsform_components`
WHERE `ComponentTypeId` IN (2422) AND `FormId` = '3' AND `Published` = '1'
282μs520B/administrator/components/com_rsform/helpers/rsform.php:1715CopySELECT `ComponentId`
FROM `m37h2_rsform_components`
WHERE `ComponentTypeId` IN (9) AND `FormId` = '3' AND `Published` = '1'
148μs520B/administrator/components/com_rsform/helpers/rsform.php:1715CopySELECT `ComponentId`
FROM `m37h2_rsform_components`
WHERE `ComponentTypeId` IN (2422) AND `FormId` = '3' AND `Published` = '1'
176μ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
283μ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
194μs912B/administrator/components/com_rsform/helpers/conditions.php:84CopySELECT *
FROM `m37h2_rsform_calculations`
WHERE `formId` = '3'
ORDER BY `ordering`
139μs752B/administrator/components/com_rsform/helpers/rsform.php:3602CopySELECT option_value FROM m37h2_imagerecycle_options WHERE option_name ='queue_process_lastRun' LIMIT 1
136μs536B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172CopySELECT option_value FROM m37h2_imagerecycle_options WHERE option_name ='queue_process_status' LIMIT 1
101μs536B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172CopySELECT *
FROM m37h2_jmap_metainfo
WHERE `linkurl` = 'https://offeringsjewelry.com/jewelry/rings/product/large-oval-rainbow-moonstone-silver-ring/category_pathway-54/related_product-11246'
AND `published` = 1
300μs912B/plugins/system/jmap/jmap.php:818CopySELECT *
FROM m37h2_jmap_canonicals
WHERE `linkurl` = 'https://offeringsjewelry.com/jewelry/rings/product/large-oval-rainbow-moonstone-silver-ring/category_pathway-54/related_product-11246'
110μ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
208μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465CopySELECT `value`
FROM `m37h2_admintools_storage`
WHERE `key` = 'criticalfiles'
142μ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
328μ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
188μ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
220μ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
190μs1.48KB/plugins/system/rereplacer/src/Items.php:97CopySELECT *
FROM m37h2_jmap_headings
WHERE `linkurl` = 'https://offeringsjewelry.com/jewelry/rings/product/large-oval-rainbow-moonstone-silver-ring/category_pathway-54/related_product-11246'
237μ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
119μs688B/plugins/system/jmap/jmap.php:508CopySELECT `session_id`
FROM `m37h2_session`
WHERE `session_id` = ?
178μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277CopyUPDATE `m37h2_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
2.46ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy