Joomla! Version | 4.4.13 |
PHP Version | 8.1.29 |
Identity | guest |
Response | 200 |
Template | t3_bs3_blank |
Database |
|
1 x afterRenderRawModule mod_hikashop (Associated products listing for category listing menu 648) (1.15MB) (37.19%) | 597.33ms |
1 x afterRoute (10.35MB) (16.79%) | 269.61ms |
1 x afterRenderRawModule mod_articles_latest (Bài viết mới cập nhật...) (797.86KB) (14.29%) | 229.51ms |
1 x afterRender (7.73MB) (12.28%) | 197.18ms |
1 x beforeRenderModule mod_hikashop (Associated products listing for category listing menu 648) (5.43MB) (8.86%) | 142.27ms |
1 x afterInitialise (7.13MB) (5.6%) | 90.01ms |
1 x afterLoad (4.1MB) (1.94%) | 31.19ms |
1 x beforeRenderModule mod_custom ( Mạng xã hội & Thống kê truy cập) (1.74MB) (1.56%) | 25.00ms |
1 x afterRenderRawModule mod_finder (Smart Search Module) (518.52KB) (0.81%) | 13.04ms |
1 x afterRenderRawModule mod_articles_categories (Demo Categories) (37.22KB) (0.17%) | 2.69ms |
1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (33.92KB) (0.08%) | 1.35ms |
1 x beforeRenderComponent com_hikashop (25.47KB) (0.08%) | 1.33ms |
1 x afterRenderRawModule mod_custom ( Mạng xã hội & Thống kê truy cập) (15.09KB) (0.07%) | 1.10ms |
1 x afterRenderModule mod_hikashop (Associated products listing for category listing menu 648) (37.78KB) (0.04%) | 679μs |
1 x afterRenderModule mod_articles_latest (Bài viết mới cập nhật...) (1.8KB) (0.02%) | 268μs |
1 x afterRenderModule mod_articles_categories (Demo Categories) (1.78KB) (0.02%) | 241μs |
1 x afterRenderModule mod_finder (Smart Search Module) (4.23KB) (0.01%) | 216μs |
1 x afterRenderModule mod_custom ( Mạng xã hội & Thống kê truy cập) (2.05KB) (0.01%) | 197μs |
1 x afterDispatch (2.95KB) (0.01%) | 176μs |
1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.08KB) (0.01%) | 161μs |
1 x afterRenderModule mod_custom (Công ty TNHH Tự động hóa và Tin học công nghiệp Bách Khoa (BKAII)) (3.34KB) (0.01%) | 157μs |
1 x afterRenderRawModule mod_custom (Công ty TNHH Tự động hóa và Tin học công nghiệp Bách Khoa (BKAII)) (992B) (0.01%) | 154μs |
1 x afterRenderComponent com_hikashop (45.7KB) (0.01%) | 124μs |
1 x beforeRenderModule mod_articles_categories (Demo Categories) (824B) (0.01%) | 99μs |
1 x beforeRenderModule mod_finder (Smart Search Module) (344B) (0.01%) | 82μs |
1 x beforeRenderModule mod_custom (Công ty TNHH Tự động hóa và Tin học công nghiệp Bách Khoa (BKAII)) (1.01KB) (0%) | 67μs |
1 x beforeRenderModule mod_articles_latest (Bài viết mới cập nhật...) (472B) (0%) | 64μs |
1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (824B) (0%) | 48μs |
1 x beforeRenderModule mod_articles_latest (Bài viết mới cập nhật...) (736B) (0%) | 13μs |
1 x beforeRenderModule mod_finder (Smart Search Module) (720B) (0%) | 13μs |
1 x beforeRenderModule mod_articles_categories (Demo Categories) (720B) (0%) | 11μs |
1 x beforeRenderModule mod_hikashop (Associated products listing for category listing menu 648) (768B) (0%) | 10μs |
1 x beforeRenderModule mod_custom ( Mạng xã hội & Thống kê truy cập) (752B) (0%) | 9μs |
1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%) | 7μs |
1 x beforeRenderModule mod_custom (Công ty TNHH Tự động hóa và Tin học công nghiệp Bách Khoa (BKAII)) (800B) (0%) | 6μs |
SELECT @@SESSION.sql_mode;
67μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `idc_session`
WHERE `session_id` = ?
24.78ms1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `idc_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
281μs1.73KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `idc_viewlevels`
75μs976B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `idc_usergroups` AS `a`
LEFT JOIN `idc_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
124μs2.27KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `idc_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`
575μs4.3KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component`
FROM `idc_menu` AS `m`
LEFT JOIN `idc_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id`
WHERE
(
(`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2)
ORDER BY `m`.`lft`
4.81ms820.55KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT * FROM idc_hikashop_config
340μs152.94KB/administrator/components/com_hikashop/classes/config.php:16CopySET sql_mode=(SELECT REPLACE(REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''), 'STRICT_TRANS_TABLES', ''));
45μs1.25KB/administrator/components/com_hikashop/helpers/helper.php:3422CopySELECT product_id FROM idc_hikashop_product WHERE product_alias = 'hd67737-mstp-a1-iec-61850-server-bacnet-mstp-master-converter'
78.86ms856B/components/com_hikashop/router.php:357CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `idc_template_styles` AS `s`
LEFT JOIN `idc_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id`
WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1
277μs1.2KB/administrator/components/com_templates/src/Model/StyleModel.php:773CopySELECT *
FROM `idc_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
152μs2.22KB/libraries/src/Language/LanguageHelper.php:142CopySELECT product.*, product_category.product_category_id, product_category.category_id, product_category.ordering FROM idc_hikashop_product AS product LEFT JOIN idc_hikashop_product_category AS product_category ON product.product_id = product_category.product_id WHERE (product.product_id = 7074) LIMIT 1
349μs24.06KB/components/com_hikashop/views/product/view.html.php:1274CopySELECT * FROM idc_modules WHERE id IN (152,0) AND language IN ('*', '', 'vi-VN')
176μs3.66KB/administrator/components/com_hikashop/helpers/module.php:123CopySELECT cart.cart_id FROM idc_hikashop_cart AS cart WHERE (cart.cart_type = 'cart') AND (cart.session_id = 'b1b666e3c78d56eef16265151c5619d1') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
91μs840B/administrator/components/com_hikashop/classes/cart.php:69CopySELECT * FROM idc_hikashop_currency WHERE currency_id IN (175)
106μs2.06KB/administrator/components/com_hikashop/classes/currency.php:1995CopyUPDATE idc_hikashop_product SET product_hit = product_hit + 1, product_last_seen_date = 1748990707 WHERE product_id = 7074
204μs2.55KB/administrator/components/com_hikashop/classes/product.php:4186CopySELECT p.* FROM idc_hikashop_product_related AS pr LEFT JOIN idc_hikashop_product AS p ON pr.product_related_id = p.product_id WHERE (pr.product_id = 7074) AND (pr.product_related_type = 'options') AND (p.product_published = 1) AND ((p.product_sale_start = '' OR p.product_sale_start <= 1748990707)) AND ((p.product_sale_end = '' OR p.product_sale_end > 1748990707)) ORDER BY pr.product_related_ordering ASC, pr.product_related_id ASC
459μs7.91KB/components/com_hikashop/views/product/view.html.php:1392CopySELECT * FROM idc_hikashop_product WHERE (product_parent_id IN (7074)) AND (product_published = 1)
201μs7.95KB/components/com_hikashop/views/product/view.html.php:1437CopySELECT v.*, c.* FROM idc_hikashop_variant AS v INNER JOIN idc_hikashop_characteristic AS c ON v.variant_characteristic_id = c.characteristic_id WHERE v.variant_product_id IN (7074) ORDER BY v.ordering ASC, c.characteristic_ordering ASC
86μs2.08KB/components/com_hikashop/views/product/view.html.php:1478CopySELECT * FROM idc_hikashop_file WHERE file_ref_id IN (7074) AND file_type IN ('product','file') ORDER BY file_ordering ASC, file_id ASC
7.59ms2.08KB/components/com_hikashop/views/product/view.html.php:1523CopySELECT currency_id FROM idc_hikashop_currency WHERE currency_published=1 OR currency_id = 175
132μs888B/administrator/components/com_hikashop/classes/currency.php:473CopySELECT p.* FROM idc_hikashop_price as p WHERE (p.price_currency_id IN (1,2,175)) AND (p.price_start_date < 1748990707) AND ((p.price_end_date < 1 OR p.price_end_date > 1748990707)) AND (p.price_product_id IN (7074)) AND ((p.price_users = '' OR p.price_users LIKE '%,0,%')) ORDER BY p.price_site_id ASC, p.price_value DESC
157μs1.95KB/administrator/components/com_hikashop/classes/currency.php:1718CopySELECT * FROM idc_hikashop_discount WHERE (discount_type = 'discount') AND (discount_published = 1) AND (discount_quota > discount_used_times OR discount_quota = 0) AND (discount_start < 1748990707) AND (discount_end > 1748990707 OR discount_end = 0) AND (discount_product_id IN ('','0','7074') OR discount_product_id LIKE '%,7074,%') AND (discount_flat_amount != 0 OR discount_percent_amount != 0) AND ((discount_flat_amount = 0 OR discount_currency_id =175)) AND ((discount_user_id = '' OR discount_user_id LIKE '%,0,%'))
184μs4.33KB/administrator/components/com_hikashop/classes/currency.php:1778CopySELECT category_id FROM idc_hikashop_product_category WHERE product_id IN (7074) ORDER BY ordering ASC
252μs872B/administrator/components/com_hikashop/classes/product.php:1192CopySELECT hk_parent.* FROM idc_hikashop_category AS hk_cat LEFT JOIN idc_hikashop_category AS hk_parent ON (hk_parent.category_left <= hk_cat.category_left AND hk_parent.category_right >= hk_cat.category_right) WHERE hk_cat.category_id IN (124,96) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left
1ms4.06KB/administrator/components/com_hikashop/classes/category.php:774CopySELECT * FROM idc_hikashop_field as a WHERE a.`field_published` = 1 AND a.`field_frontcomp` = 1 AND a.field_table='product' AND ((((field_with_sub_categories = 0 AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,124,%' OR field_categories LIKE '%,96,%'))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 '%,25,%' OR field_categories LIKE '%,96,%' OR field_categories LIKE '%,124,%'))) AND field_products="") OR (field_products LIKE '%,7074,%')) ORDER BY a.`field_ordering` ASC
199μs3.98KB/administrator/components/com_hikashop/classes/field.php:167CopySELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1748990707 AND (a.badge_end >= 1748990707 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 >= 166818932) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '124' OR badge_category_id LIKE '%,124,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%')) 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 = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '124' OR badge_category_id LIKE '%,124,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
176μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT b.* FROM idc_hikashop_product_category AS a LEFT JOIN idc_hikashop_category AS b ON a.category_id = b.category_id WHERE a.product_id = 7074 ORDER BY a.product_category_id ASC
214μs4.02KB/components/com_hikashop/views/product/view.html.php:1843CopySELECT a.id FROM idc_menu AS a INNER JOIN `idc_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,5) AND a.client_id=0 AND a.link='index.php?option=com_hikashop&view=checkout&layout=show' AND a.language IN ('*', '', 'vi-VN')
2.16ms840B/administrator/components/com_hikashop/classes/menus.php:327CopySELECT a.id FROM idc_menu AS a INNER JOIN `idc_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,5) AND a.client_id=0 AND a.link LIKE 'index.php?option=com_hikashop&view=%' AND a.language IN ('*', '', 'vi-VN')
2.07ms2.82KB/administrator/components/com_hikashop/classes/menus.php:327CopySELECT a.*, c.currency_symbol FROM idc_hikashop_shipping AS a INNER JOIN idc_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
142μs2.27KB/plugins/hikashop/shippingmanual_prices/shippingmanual_prices.php:45CopySELECT * FROM idc_extensions WHERE folder='hikashop' AND element='shippingmanual_prices' AND type='plugin'
188μs14.78KB/administrator/components/com_hikashop/classes/plugins.php:113CopySELECT * FROM idc_extensions WHERE folder='system' AND element='hikashopsocial' AND type='plugin'
172μs3.78KB/administrator/components/com_hikashop/classes/plugins.php:113CopySELECT * FROM idc_extensions WHERE folder='content' AND element='hikashopsocial' AND type='plugin'
153μs3.77KB/administrator/components/com_hikashop/classes/plugins.php:113CopySELECT product_average_score, product_total_vote FROM idc_hikashop_product WHERE product_id = 7074
143μs912B/components/com_hikashop/views/vote/view.html.php:346CopySELECT * FROM idc_hikashop_vote WHERE (vote_type = 'product') AND (vote_rating != 0) AND (vote_ref_id = 7074) AND (vote_ip = '3.15.220.128') AND (vote_user_id IN ( '' , '0', '3.15.220.128'))
6.18ms2.08KB/administrator/components/com_hikashop/classes/vote.php:688CopySELECT `m`.`tag_id`,`t`.*
FROM `idc_contentitem_tag_map` AS `m`
INNER JOIN `idc_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)
252μs5.22KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT * FROM idc_extensions WHERE folder='hikashop' AND element='google_products' AND type='plugin'
179μs3.77KB/administrator/components/com_hikashop/classes/plugins.php:113CopySELECT * FROM idc_hikashop_vote WHERE vote_type = 'product' AND vote_published > 0 AND vote_ref_id = 7074
6.07ms2.09KB/components/com_hikashop/views/product/tmpl/show_microdata.php:86CopySELECT params FROM idc_modules WHERE id = 152
102μs856B/modules/mod_hikashop/mod_hikashop.php:33CopySELECT a.category_id FROM idc_hikashop_product_category AS a INNER JOIN idc_hikashop_category AS b ON a.category_id=b.category_id WHERE b.category_published=1 AND a.product_id=7074 ORDER BY a.product_category_id ASC
192μs872B/components/com_hikashop/views/product/view.html.php:299CopySELECT cart.cart_id FROM idc_hikashop_cart AS cart WHERE (cart.cart_type = 'cart') AND (cart.session_id = 'b1b666e3c78d56eef16265151c5619d1') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
73μs840B/administrator/components/com_hikashop/classes/cart.php:69CopySELECT a.*,b.* FROM idc_hikashop_category AS a LEFT JOIN idc_hikashop_file AS b ON a.category_id = b.file_ref_id AND b.file_type = 'category' WHERE a.category_id = 96 LIMIT 1
358μs7.09KB/administrator/components/com_hikashop/classes/category.php:35CopySELECT DISTINCT b.* FROM idc_hikashop_product_category AS a LEFT JOIN idc_hikashop_product AS b ON a.product_id=b.product_id WHERE (b.product_published = 1) AND (b.product_id!=7074) AND (b.product_parent_id!=7074) AND (b.product_type = 'main') AND (a.category_id IN (96,124)) ORDER BY a.ordering ASC, b.product_id ASC LIMIT 20
194ms296.27KB/components/com_hikashop/views/product/view.html.php:898CopySELECT * FROM idc_hikashop_file WHERE file_ref_id IN (6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716) AND file_type IN ('product','file') ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
10.74ms2.8KB/administrator/components/com_hikashop/classes/product.php:2430CopySELECT variant_product_id FROM idc_hikashop_variant WHERE variant_product_id IN (6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716)
68μs840B/administrator/components/com_hikashop/classes/product.php:2458CopySELECT product_id FROM idc_hikashop_product_related WHERE product_related_type = 'options' AND product_id IN (6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716)
407μs840B/administrator/components/com_hikashop/classes/product.php:2474CopySELECT product_parent_id, product_id, product_tax_id FROM idc_hikashop_product WHERE product_parent_id IN ('6697','6698','6699','6700','6701','6702','6703','6704','6705','6706','6707','6708','6709','6710','6711','6712','6713','6714','6715','6716') AND product_published = 1 AND product_type = 'variant' AND product_sale_start < 1748990707 AND (product_sale_end > 1748990707 OR product_sale_end = 0)
321ms960B/administrator/components/com_hikashop/classes/currency.php:1060CopySELECT * FROM idc_hikashop_discount WHERE discount_type='discount' AND discount_published=1 AND (discount_quota > discount_used_times OR discount_quota = 0) AND discount_start < 1748990708 AND (discount_end > 1748990708 OR discount_end = 0) AND ( (discount_product_id IN ('','0','6697','6698','6699','6700','6701','6702','6703','6704','6705','6706','6707','6708','6709','6710','6711','6712','6713','6714','6715','6716')) OR (discount_product_id LIKE '%,6697,%') OR (discount_product_id LIKE '%,6698,%') OR (discount_product_id LIKE '%,6699,%') OR (discount_product_id LIKE '%,6700,%') OR (discount_product_id LIKE '%,6701,%') OR (discount_product_id LIKE '%,6702,%') OR (discount_product_id LIKE '%,6703,%') OR (discount_product_id LIKE '%,6704,%') OR (discount_product_id LIKE '%,6705,%') OR (discount_product_id LIKE '%,6706,%') OR (discount_product_id LIKE '%,6707,%') OR (discount_product_id LIKE '%,6708,%') OR (discount_product_id LIKE '%,6709,%') OR (discount_product_id LIKE '%,6710,%') OR (discount_product_id LIKE '%,6711,%') OR (discount_product_id LIKE '%,6712,%') OR (discount_product_id LIKE '%,6713,%') OR (discount_product_id LIKE '%,6714,%') OR (discount_product_id LIKE '%,6715,%') OR (discount_product_id LIKE '%,6716,%') ) AND (discount_flat_amount != 0 OR discount_percent_amount != 0) AND (discount_flat_amount = 0 OR discount_currency_id =175) AND (discount_user_id = '' OR discount_user_id LIKE '%,0,%')
268μs4.33KB/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 idc_hikashop_price AS a WHERE a.price_product_id IN (6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716) AND a.price_currency_id IN (1,2,175) AND a.price_start_date < 1748990708 AND (a.price_end_date < 1 OR a.price_end_date > 1748990708) AND (a.price_access = 'all' OR a.price_access LIKE '%,13,%' 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
249μs2.05KB/administrator/components/com_hikashop/classes/currency.php:589CopySELECT c.*, pc.* FROM idc_hikashop_category AS c LEFT JOIN idc_hikashop_product_category AS pc ON c.category_id = pc.category_id WHERE pc.product_id IN (6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716);
651μs20.98KB/administrator/components/com_hikashop/classes/product.php:2525CopySELECT hk_parent.* FROM idc_hikashop_category AS hk_cat LEFT JOIN idc_hikashop_category AS hk_parent ON (hk_parent.category_left <= hk_cat.category_left AND hk_parent.category_right >= hk_cat.category_right) WHERE hk_cat.category_id IN (96) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left
873μs4.05KB/administrator/components/com_hikashop/classes/category.php:774CopySELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1748990708 AND (a.badge_end >= 1748990708 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 >= 168267076) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%')) 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 = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
153μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1748990708 AND (a.badge_end >= 1748990708 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 >= 168212028) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%')) 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 = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
143μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1748990708 AND (a.badge_end >= 1748990708 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 >= 168211424) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%')) 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 = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
154μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1748990708 AND (a.badge_end >= 1748990708 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 >= 168210660) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%')) 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 = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
136μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT hk_parent.* FROM idc_hikashop_category AS hk_cat LEFT JOIN idc_hikashop_category AS hk_parent ON (hk_parent.category_left <= hk_cat.category_left AND hk_parent.category_right >= hk_cat.category_right) WHERE hk_cat.category_id IN (96,172,323) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left
968μs4.11KB/administrator/components/com_hikashop/classes/category.php:774CopySELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1748990708 AND (a.badge_end >= 1748990708 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 >= 168210014) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '172' OR badge_category_id LIKE '%,172,%' OR badge_category_id = '323' OR badge_category_id LIKE '%,323,%')) 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 = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '165' OR badge_category_id LIKE '%,165,%' OR badge_category_id = '172' OR badge_category_id LIKE '%,172,%' OR badge_category_id = '322' OR badge_category_id LIKE '%,322,%' OR badge_category_id = '323' OR badge_category_id LIKE '%,323,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
163μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1748990708 AND (a.badge_end >= 1748990708 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 >= 168209642) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '172' OR badge_category_id LIKE '%,172,%' OR badge_category_id = '323' OR badge_category_id LIKE '%,323,%')) 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 = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '165' OR badge_category_id LIKE '%,165,%' OR badge_category_id = '172' OR badge_category_id LIKE '%,172,%' OR badge_category_id = '322' OR badge_category_id LIKE '%,322,%' OR badge_category_id = '323' OR badge_category_id LIKE '%,323,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
162μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT hk_parent.* FROM idc_hikashop_category AS hk_cat LEFT JOIN idc_hikashop_category AS hk_parent ON (hk_parent.category_left <= hk_cat.category_left AND hk_parent.category_right >= hk_cat.category_right) WHERE hk_cat.category_id IN (172,323,96) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left
970μs4.11KB/administrator/components/com_hikashop/classes/category.php:774CopySELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1748990708 AND (a.badge_end >= 1748990708 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 >= 168209112) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '172' OR badge_category_id LIKE '%,172,%' OR badge_category_id = '323' OR badge_category_id LIKE '%,323,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%')) 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 = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '165' OR badge_category_id LIKE '%,165,%' OR badge_category_id = '172' OR badge_category_id LIKE '%,172,%' OR badge_category_id = '322' OR badge_category_id LIKE '%,322,%' OR badge_category_id = '323' OR badge_category_id LIKE '%,323,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
166μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1748990708 AND (a.badge_end >= 1748990708 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 >= 168208605) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '172' OR badge_category_id LIKE '%,172,%' OR badge_category_id = '323' OR badge_category_id LIKE '%,323,%')) 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 = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '165' OR badge_category_id LIKE '%,165,%' OR badge_category_id = '172' OR badge_category_id LIKE '%,172,%' OR badge_category_id = '322' OR badge_category_id LIKE '%,322,%' OR badge_category_id = '323' OR badge_category_id LIKE '%,323,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
169μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1748990708 AND (a.badge_end >= 1748990708 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 >= 168207984) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '172' OR badge_category_id LIKE '%,172,%' OR badge_category_id = '323' OR badge_category_id LIKE '%,323,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%')) 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 = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '165' OR badge_category_id LIKE '%,165,%' OR badge_category_id = '172' OR badge_category_id LIKE '%,172,%' OR badge_category_id = '322' OR badge_category_id LIKE '%,322,%' OR badge_category_id = '323' OR badge_category_id LIKE '%,323,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
155μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1748990708 AND (a.badge_end >= 1748990708 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 >= 168207540) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '172' OR badge_category_id LIKE '%,172,%' OR badge_category_id = '323' OR badge_category_id LIKE '%,323,%')) 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 = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '165' OR badge_category_id LIKE '%,165,%' OR badge_category_id = '172' OR badge_category_id LIKE '%,172,%' OR badge_category_id = '322' OR badge_category_id LIKE '%,322,%' OR badge_category_id = '323' OR badge_category_id LIKE '%,323,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
173μs11.8KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT hk_parent.* FROM idc_hikashop_category AS hk_cat LEFT JOIN idc_hikashop_category AS hk_parent ON (hk_parent.category_left <= hk_cat.category_left AND hk_parent.category_right >= hk_cat.category_right) WHERE hk_cat.category_id IN (323,172,96,345) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left
1.09ms4.14KB/administrator/components/com_hikashop/classes/category.php:774CopySELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1748990708 AND (a.badge_end >= 1748990708 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 >= 168207035) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '323' OR badge_category_id LIKE '%,323,%' OR badge_category_id = '172' OR badge_category_id LIKE '%,172,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '345' OR badge_category_id LIKE '%,345,%')) 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 = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '165' OR badge_category_id LIKE '%,165,%' OR badge_category_id = '172' OR badge_category_id LIKE '%,172,%' OR badge_category_id = '322' OR badge_category_id LIKE '%,322,%' OR badge_category_id = '323' OR badge_category_id LIKE '%,323,%' OR badge_category_id = '345' OR badge_category_id LIKE '%,345,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
176μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1748990708 AND (a.badge_end >= 1748990708 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 >= 168206464) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '323' OR badge_category_id LIKE '%,323,%' OR badge_category_id = '172' OR badge_category_id LIKE '%,172,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '345' OR badge_category_id LIKE '%,345,%')) 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 = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '165' OR badge_category_id LIKE '%,165,%' OR badge_category_id = '172' OR badge_category_id LIKE '%,172,%' OR badge_category_id = '322' OR badge_category_id LIKE '%,322,%' OR badge_category_id = '323' OR badge_category_id LIKE '%,323,%' OR badge_category_id = '345' OR badge_category_id LIKE '%,345,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
165μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT hk_parent.* FROM idc_hikashop_category AS hk_cat LEFT JOIN idc_hikashop_category AS hk_parent ON (hk_parent.category_left <= hk_cat.category_left AND hk_parent.category_right >= hk_cat.category_right) WHERE hk_cat.category_id IN (172,323,96,345) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left
1.07ms4.14KB/administrator/components/com_hikashop/classes/category.php:774CopySELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1748990708 AND (a.badge_end >= 1748990708 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 >= 168205993) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '172' OR badge_category_id LIKE '%,172,%' OR badge_category_id = '323' OR badge_category_id LIKE '%,323,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '345' OR badge_category_id LIKE '%,345,%')) 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 = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '165' OR badge_category_id LIKE '%,165,%' OR badge_category_id = '172' OR badge_category_id LIKE '%,172,%' OR badge_category_id = '322' OR badge_category_id LIKE '%,322,%' OR badge_category_id = '323' OR badge_category_id LIKE '%,323,%' OR badge_category_id = '345' OR badge_category_id LIKE '%,345,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
171μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT hk_parent.* FROM idc_hikashop_category AS hk_cat LEFT JOIN idc_hikashop_category AS hk_parent ON (hk_parent.category_left <= hk_cat.category_left AND hk_parent.category_right >= hk_cat.category_right) WHERE hk_cat.category_id IN (345,323,172,96) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left
1.06ms4.14KB/administrator/components/com_hikashop/classes/category.php:774CopySELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1748990708 AND (a.badge_end >= 1748990708 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 >= 168204413) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '345' OR badge_category_id LIKE '%,345,%' OR badge_category_id = '323' OR badge_category_id LIKE '%,323,%' OR badge_category_id = '172' OR badge_category_id LIKE '%,172,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%')) 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 = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '165' OR badge_category_id LIKE '%,165,%' OR badge_category_id = '172' OR badge_category_id LIKE '%,172,%' OR badge_category_id = '322' OR badge_category_id LIKE '%,322,%' OR badge_category_id = '323' OR badge_category_id LIKE '%,323,%' OR badge_category_id = '345' OR badge_category_id LIKE '%,345,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
174μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1748990708 AND (a.badge_end >= 1748990708 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 >= 168203918) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '323' OR badge_category_id LIKE '%,323,%' OR badge_category_id = '172' OR badge_category_id LIKE '%,172,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '345' OR badge_category_id LIKE '%,345,%')) 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 = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%' OR badge_category_id = '165' OR badge_category_id LIKE '%,165,%' OR badge_category_id = '172' OR badge_category_id LIKE '%,172,%' OR badge_category_id = '322' OR badge_category_id LIKE '%,322,%' OR badge_category_id = '323' OR badge_category_id LIKE '%,323,%' OR badge_category_id = '345' OR badge_category_id LIKE '%,345,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
167μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1748990708 AND (a.badge_end >= 1748990708 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 >= 168203354) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%')) 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 = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
153μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1748990708 AND (a.badge_end >= 1748990708 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 >= 168202703) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%')) 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 = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
151μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1748990708 AND (a.badge_end >= 1748990708 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 >= 168202025) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%')) 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 = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
136μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1748990708 AND (a.badge_end >= 1748990708 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 >= 168201224) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%')) 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 = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
145μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1748990708 AND (a.badge_end >= 1748990708 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 >= 168192525) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%')) 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 = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '96' OR badge_category_id LIKE '%,96,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
136μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT COUNT( DISTINCT b.product_id ) FROM idc_hikashop_product_category AS a LEFT JOIN idc_hikashop_product AS b ON a.product_id=b.product_id WHERE (b.product_published = 1) AND (b.product_id!=7074) AND (b.product_parent_id!=7074) AND (b.product_type = 'main') AND (a.category_id IN (96,124)) ORDER BY a.ordering ASC, b.product_id ASC
23.33ms856B/components/com_hikashop/views/product/view.html.php:950CopySELECT * FROM idc_hikashop_characteristic WHERE characteristic_values_on_listing > 0 ORDER BY characteristic_ordering ASC;
96μs1.89KB/components/com_hikashop/views/product/view.html.php:1177CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `idc_modules` AS `m`
LEFT JOIN `idc_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `idc_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id`
WHERE
(
(
(`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND
(`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0)
ORDER BY `m`.`position`,`m`.`ordering`
2.11ms1.36MBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count`
FROM `idc_content` AS `a`
LEFT JOIN `idc_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `idc_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `idc_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `idc_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `idc_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `idc_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)
ORDER BY a.created DESC LIMIT 15
212ms249.09KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug`
FROM `idc_categories` AS `s`
INNER JOIN `idc_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
393μs5.17KBParams/libraries/src/Categories/Categories.php:375CopySELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug`
FROM `idc_categories` AS `s`
INNER JOIN `idc_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
328μs5.17KBParams/libraries/src/Categories/Categories.php:375CopySELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug`
FROM `idc_categories` AS `s`
INNER JOIN `idc_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
329μs5.14KBParams/libraries/src/Categories/Categories.php:375CopySELECT `name`,`element`
FROM `idc_extensions`
WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1
297μs928B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135CopySELECT `title`
FROM `idc_finder_taxonomy`
WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)
154μs968B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314CopySELECT 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 `idc_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
137μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517CopySELECT `session_id`
FROM `idc_session`
WHERE `session_id` = ?
106μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyINSERT INTO `idc_session`
(`data`,`time`,`session_id`) VALUES
(?, ?, ?)
198μs864BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy