Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem.
Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis...
Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis...
Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis...
Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis...
Phasellus bibendum neque metus, id pellentesque leo dictum sit amet. Aliquam ac velit ipsum. Phasellus semper dictum massa ut faucibus. Morbi lacinia justo eu lacus mollis sollicitudin id at arcu. Donec tempor mauris id libero blandit viverra. Integer volutpat, nisl sit amet pulvinar porta, ante orci malesuada nulla, id facilisis tortor eros sed neque. Nunc porta lorem in velit molestie, id gravida dolor aliquet.
Joomla! Version | 4.4.9 |
PHP Version | 8.2.24 |
Identity | guest |
Response | 200 |
Template | ja_allure |
Database |
|
1 x beforeRenderModule mod_hikashop (Best sellers) (1.64MB) (16.59%) | 64.53ms |
1 x afterInitialise (948.3KB) (13.59%) | 52.86ms |
1 x afterRenderRawModule mod_hikashop (Best sellers) (626.59KB) (8.5%) | 33.08ms |
1 x afterRenderRawModule mod_articles_category (Most Popular) (193.33KB) (5.57%) | 21.65ms |
1 x afterRender (648.94KB) (5.38%) | 20.94ms |
1 x afterRoute (1.44MB) (5.2%) | 20.24ms |
1 x afterRenderRawModule mod_hikashop (Related products) (464.46KB) (5.14%) | 20.00ms |
1 x afterRenderRawModule mod_hikashop (Latest products) (448.08KB) (5.09%) | 19.80ms |
1 x afterRenderRawModule mod_articles_latest (Latest Footer ) (60.02KB) (4.59%) | 17.86ms |
1 x afterRenderRawModule mod_hikashop (Product Banner) (230.61KB) (4.11%) | 16.00ms |
1 x afterRenderRawModule mod_articles_category (Fashion) (75.8KB) (2.93%) | 11.40ms |
1 x afterRenderRawModule mod_articles_category (Editor's Picks) (114.06KB) (2.75%) | 10.70ms |
1 x afterRenderRawModule mod_articles_category (Beauty) (74.8KB) (2.37%) | 9.23ms |
1 x afterRenderRawModule mod_articles_category (Featured Article) (40.89KB) (2.05%) | 7.97ms |
1 x afterRenderRawModule mod_banners (Banner 4) (17.91KB) (1.89%) | 7.36ms |
1 x afterRenderRawModule mod_articles_category (Celebrity) (112.73KB) (1.76%) | 6.86ms |
1 x beforeRenderModule mod_footer (Footer) (124.91KB) (1.66%) | 6.47ms |
1 x afterDispatch (54.08KB) (1.4%) | 5.45ms |
1 x afterRenderRawModule mod_banners (Banner 3) (17.57KB) (1.15%) | 4.46ms |
1 x afterRenderRawModule mod_banners (Banner) (17.57KB) (0.94%) | 3.65ms |
1 x afterLoad (456.93KB) (0.93%) | 3.62ms |
1 x afterRenderRawModule mod_articles_category (Lead Article) (28.79KB) (0.76%) | 2.96ms |
1 x afterRenderRawModule mod_banners (Banner 2) (17.57KB) (0.69%) | 2.68ms |
1 x afterRenderRawModule mod_banners (Banner right) (32.63KB) (0.63%) | 2.43ms |
1 x afterRenderRawModule mod_menu (Bonus pages) (186.63KB) (0.59%) | 2.28ms |
1 x afterRenderRawModule mod_menu (Menu Footer) (59.25KB) (0.55%) | 2.14ms |
1 x afterRenderRawModule mod_banners (Banner Top) (17.57KB) (0.46%) | 1.79ms |
1 x afterRenderRawModule mod_footer (Footer) (4.93KB) (0.22%) | 865μs |
1 x afterRenderRawModule mod_custom (Social) (3.81KB) (0.16%) | 610μs |
1 x beforeRenderComponent com_hikashop (19.32KB) (0.15%) | 565μs |
1 x beforeRenderModule mod_menu (Menu Footer) (720B) (0.14%) | 532μs |
1 x afterRenderModule mod_articles_category (Beauty) (4.19KB) (0.12%) | 448μs |
1 x afterRenderRawModule mod_menu (Top Bar) (15.33KB) (0.11%) | 413μs |
1 x afterRenderComponent com_hikashop (83.94KB) (0.08%) | 329μs |
1 x beforeRenderModule mod_banners (Banner) (7.18KB) (0.08%) | 319μs |
1 x afterRenderModule mod_custom (Social) (1.8KB) (0.06%) | 238μs |
1 x afterRenderModule mod_articles_category (Fashion) (1.69KB) (0.06%) | 234μs |
1 x afterRenderModule mod_banners (Banner right) (1.81KB) (0.05%) | 203μs |
1 x afterRenderModule mod_articles_category (Editor's Picks) (1.7KB) (0.04%) | 171μs |
1 x afterRenderModule mod_articles_category (Most Popular) (5.89KB) (0.04%) | 162μs |
1 x afterRenderModule mod_menu (Menu Footer) (2.31KB) (0.04%) | 157μs |
1 x afterRenderModule mod_articles_latest (Latest Footer ) (1.61KB) (0.04%) | 156μs |
1 x afterRenderModule mod_hikashop (Best sellers) (3.26KB) (0.04%) | 154μs |
1 x afterRenderModule mod_articles_category (Celebrity) (1.69KB) (0.04%) | 141μs |
1 x afterRenderModule mod_hikashop (Product Banner) (1.92KB) (0.04%) | 140μs |
1 x afterRenderModule mod_articles_category (Featured Article) (1.7KB) (0.04%) | 137μs |
1 x afterRenderModule mod_banners (Banner 4) (3.27KB) (0.03%) | 134μs |
1 x beforeRenderModule mod_banners (Banner 3) (3.34KB) (0.03%) | 134μs |
1 x afterRenderModule mod_articles_category (Lead Article) (2.3KB) (0.03%) | 124μs |
1 x afterRenderModule mod_banners (Banner) (2KB) (0.03%) | 115μs |
1 x beforeRenderModule mod_hikashop (Product Banner) (9.73KB) (0.03%) | 113μs |
1 x beforeRenderModule mod_articles_category (Fashion) (264B) (0.03%) | 107μs |
1 x afterRenderModule mod_menu (Bonus pages) (1.64KB) (0.03%) | 104μs |
1 x beforeRenderModule mod_hikashop (Latest products) (15.48KB) (0.03%) | 103μs |
1 x afterRenderModule mod_footer (Footer) (1.98KB) (0.03%) | 102μs |
1 x beforeRenderModule mod_banners (Banner 2) (7.16KB) (0.03%) | 102μs |
1 x afterRenderModule mod_hikashop (Related products) (2.25KB) (0.02%) | 94μs |
1 x beforeRenderModule mod_articles_category (Editor's Picks) (7.4KB) (0.02%) | 94μs |
1 x afterRenderModule mod_hikashop (Latest products) (2.25KB) (0.02%) | 93μs |
1 x beforeRenderModule mod_banners (Banner Top) (7.16KB) (0.02%) | 90μs |
1 x beforeRenderModule mod_articles_category (Lead Article) (2.07KB) (0.02%) | 89μs |
1 x beforeRenderModule mod_banners (Banner 4) (1.37KB) (0.02%) | 88μs |
1 x beforeRenderModule mod_banners (Banner right) (2KB) (0.02%) | 88μs |
1 x afterRenderModule mod_banners (Banner 3) (2.02KB) (0.02%) | 87μs |
1 x beforeRenderModule mod_custom (Social) (2.26KB) (0.02%) | 86μs |
1 x afterRenderModule mod_banners (Banner 2) (2.02KB) (0.02%) | 86μs |
1 x beforeRenderModule mod_articles_category (Beauty) (776B) (0.02%) | 81μs |
1 x beforeRenderModule mod_articles_category (Celebrity) (7.54KB) (0.02%) | 80μs |
1 x beforeRenderModule mod_articles_latest (Latest Footer ) (840B) (0.02%) | 76μs |
1 x beforeRenderModule mod_articles_category (Featured Article) (296B) (0.02%) | 75μs |
1 x afterRenderModule mod_banners (Banner Top) (2.02KB) (0.02%) | 72μs |
1 x afterRenderModule mod_menu (Top Bar) (1.95KB) (0.02%) | 64μs |
1 x beforeRenderModule mod_menu (Menu Footer) (2.63KB) (0.02%) | 61μs |
1 x beforeRenderModule mod_menu (Top Bar) (1.24KB) (0.01%) | 56μs |
1 x beforeRenderModule mod_menu (Bonus pages) (8B) (0.01%) | 54μs |
1 x beforeRenderModule mod_articles_category (Most Popular) (8.75KB) (0.01%) | 52μs |
1 x beforeRenderModule mod_hikashop (Related products) (536B) (0.01%) | 40μs |
1 x beforeRenderModule mod_articles_category (Beauty) (704B) (0%) | 17μs |
1 x beforeRenderModule mod_articles_latest (Latest Footer ) (704B) (0%) | 15μs |
1 x beforeRenderModule mod_articles_category (Fashion) (704B) (0%) | 15μs |
1 x beforeRenderModule mod_banners (Banner 4) (720B) (0%) | 14μs |
1 x beforeRenderModule mod_custom (Social) (704B) (0%) | 14μs |
1 x beforeRenderModule mod_articles_category (Most Popular) (704B) (0%) | 14μs |
1 x beforeRenderModule mod_articles_category (Editor's Picks) (720B) (0%) | 14μs |
1 x beforeRenderModule mod_banners (Banner) (704B) (0%) | 14μs |
1 x beforeRenderModule mod_hikashop (Best sellers) (720B) (0%) | 13μs |
1 x beforeRenderModule mod_banners (Banner right) (720B) (0%) | 12μs |
1 x beforeRenderModule mod_articles_category (Featured Article) (720B) (0%) | 12μs |
1 x beforeRenderModule mod_articles_category (Celebrity) (704B) (0%) | 11μs |
1 x beforeRenderModule mod_banners (Banner 3) (720B) (0%) | 11μs |
1 x beforeRenderModule mod_banners (Banner 2) (720B) (0%) | 11μs |
1 x beforeRenderModule mod_articles_category (Lead Article) (704B) (0%) | 11μs |
1 x beforeRenderModule mod_menu (Bonus pages) (720B) (0%) | 11μs |
1 x beforeRenderModule mod_hikashop (Latest products) (720B) (0%) | 10μs |
1 x beforeRenderModule mod_hikashop (Related products) (720B) (0%) | 10μs |
1 x beforeRenderModule mod_hikashop (Product Banner) (720B) (0%) | 10μs |
1 x beforeRenderModule mod_footer (Footer) (704B) (0%) | 9μs |
1 x beforeRenderModule mod_banners (Banner Top) (720B) (0%) | 9μs |
1 x beforeRenderModule mod_menu (Top Bar) (704B) (0%) | 6μs |
SELECT @@SESSION.sql_mode;
190μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `ajr4k_session`
WHERE `session_id` = ?
6.8ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `ajr4k_session`
WHERE `session_id` = :session_id LIMIT 1
357μs1.3KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `ajr4k_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
2.91ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ajr4k_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
6.3ms1.61KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `ajr4k_viewlevels`
1.9ms656B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `ajr4k_usergroups` AS `a`
LEFT JOIN `ajr4k_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
1.4ms1.33KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `ajr4k_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`
2.69ms3.98KBParams/libraries/src/Plugin/PluginHelper.php:294CopyUPDATE ajr4k_extensions
SET enabled=1
WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'
1.45ms688B/plugins/system/jacontenttype/jacontenttype.php:76CopySELECT *
FROM `ajr4k_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
781μs1.58KB/libraries/src/Language/LanguageHelper.php:142CopySELECT `element`,`name`,`client_id`,`extension_id`
FROM `ajr4k_extensions`
WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1
262μs784B/libraries/src/Language/LanguageHelper.php:213CopySELECT * FROM ajr4k_hikashop_config
809μs40.63KB/administrator/components/com_hikashop/classes/config.php:16CopySET sql_mode=(SELECT REPLACE(REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''), 'STRICT_TRANS_TABLES', ''));
108μs0B/administrator/components/com_hikashop/helpers/helper.php:3226CopySELECT `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 `ajr4k_menu` AS `m`
LEFT JOIN `ajr4k_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`
714μs52.05KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `ajr4k_template_styles` AS `s`
LEFT JOIN `ajr4k_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
1.61ms848B/administrator/components/com_templates/src/Model/StyleModel.php:773CopySELECT product.*, product_category.product_category_id, product_category.category_id, product_category.ordering FROM ajr4k_hikashop_product AS product LEFT JOIN ajr4k_hikashop_product_category AS product_category ON product.product_id = product_category.product_id WHERE (product.product_id = 12) LIMIT 1
479μs5.56KB/components/com_hikashop/views/product/view.html.php:1230CopySELECT * FROM ajr4k_modules WHERE id IN (173,174,175,0) AND language IN ('*', '', 'en-GB')
2.72ms3.69KB/administrator/components/com_hikashop/helpers/module.php:123CopySELECT cart.cart_id FROM ajr4k_hikashop_cart AS cart WHERE (cart.cart_type = 'cart') AND (cart.session_id = '7e8b498575c3e3675027801fc3ca1ec7') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
791μs520B/administrator/components/com_hikashop/classes/cart.php:69CopySELECT * FROM ajr4k_hikashop_currency WHERE currency_id IN (2)
281μs1.44KB/administrator/components/com_hikashop/classes/currency.php:1926CopyUPDATE ajr4k_hikashop_product SET product_hit = product_hit + 1, product_last_seen_date = 1744826673 WHERE product_id = 12
213μs48B/administrator/components/com_hikashop/classes/product.php:4141CopySELECT p.* FROM ajr4k_hikashop_product_related AS pr LEFT JOIN ajr4k_hikashop_product AS p ON pr.product_related_id = p.product_id WHERE (pr.product_id = 12) AND (pr.product_related_type = 'options') AND (p.product_published = 1) AND ((p.product_sale_start = '' OR p.product_sale_start <= 1744826673)) AND ((p.product_sale_end = '' OR p.product_sale_end > 1744826673)) ORDER BY pr.product_related_ordering ASC, pr.product_related_id ASC
384μs5.41KB/components/com_hikashop/views/product/view.html.php:1341CopySELECT * FROM ajr4k_hikashop_product WHERE (product_parent_id IN (12)) AND (product_published = 1)
386μs21.64KB/components/com_hikashop/views/product/view.html.php:1386CopySELECT v.*, c.* FROM ajr4k_hikashop_variant AS v INNER JOIN ajr4k_hikashop_characteristic AS c ON v.variant_characteristic_id = c.characteristic_id WHERE v.variant_product_id IN (12,134,135,136,137,138,139,140,141,142,143,144,145) ORDER BY v.ordering ASC, c.characteristic_ordering ASC
873μs1.95KB/components/com_hikashop/views/product/view.html.php:1427CopySELECT * FROM ajr4k_hikashop_file WHERE file_ref_id IN (12,134,135,136,137,138,139,140,141,142,143,144,145) AND file_type IN ('product','file') ORDER BY file_ordering ASC, file_id ASC
931μs1.47KB/components/com_hikashop/views/product/view.html.php:1472CopySELECT currency_id FROM ajr4k_hikashop_currency WHERE currency_published=1 OR currency_id = 2
378μs552B/administrator/components/com_hikashop/classes/currency.php:473CopySELECT p.* FROM ajr4k_hikashop_price as p WHERE (p.price_currency_id IN (1,2)) AND (p.price_start_date < 1744826673) AND ((p.price_end_date < 1 OR p.price_end_date > 1744826673)) AND (p.price_product_id IN (12,134,135,136,137,138,139,140,141,142,143,144,145)) AND ((p.price_users = '' OR p.price_users LIKE '%,0,%')) ORDER BY p.price_site_id ASC, p.price_value DESC
279μs1.34KB/administrator/components/com_hikashop/classes/currency.php:1649CopySELECT b.*,c.* FROM ajr4k_hikashop_category AS a LEFT JOIN ajr4k_hikashop_taxation AS b ON a.category_namekey=b.category_namekey LEFT JOIN ajr4k_hikashop_tax AS c ON b.tax_namekey=c.tax_namekey WHERE a.category_id = 11 AND b.taxation_published=1 AND ( taxation_type = '' OR (taxation_type = 'individual' OR taxation_type LIKE '%individual%') ) AND b.taxation_date_start <= 1744826673 AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1744826673) ORDER BY b.taxation_id ASC
420μs2.38KB/administrator/components/com_hikashop/classes/currency.php:199CopySELECT * FROM ajr4k_hikashop_zone WHERE zone_id = 73
320μs1.28KB/administrator/components/com_hikashop/classes/currency.php:220CopySELECT * FROM ajr4k_hikashop_discount WHERE (discount_type = 'discount') AND (discount_published = 1) AND (discount_quota > discount_used_times OR discount_quota = 0) AND (discount_start < 1744826673) AND (discount_end > 1744826673 OR discount_end = 0) AND (discount_product_id IN ('','0','12','134','135','136','137','138','139','140','141','142','143','144','145') OR discount_product_id LIKE '%,12,%' OR discount_product_id LIKE '%,134,%' OR discount_product_id LIKE '%,135,%' OR discount_product_id LIKE '%,136,%' OR discount_product_id LIKE '%,137,%' OR discount_product_id LIKE '%,138,%' OR discount_product_id LIKE '%,139,%' OR discount_product_id LIKE '%,140,%' OR discount_product_id LIKE '%,141,%' OR discount_product_id LIKE '%,142,%' OR discount_product_id LIKE '%,143,%' OR discount_product_id LIKE '%,144,%' OR discount_product_id LIKE '%,145,%') AND (discount_flat_amount != 0 OR discount_percent_amount != 0) AND ((discount_flat_amount = 0 OR discount_currency_id =2)) AND ((discount_user_id = '' OR discount_user_id LIKE '%,0,%'))
524μs3.08KB/administrator/components/com_hikashop/classes/currency.php:1709CopySELECT category_id FROM ajr4k_hikashop_product_category WHERE product_id IN (12) ORDER BY ordering ASC
415μs536B/administrator/components/com_hikashop/classes/product.php:1192CopySELECT hk_parent.* FROM ajr4k_hikashop_category AS hk_cat LEFT JOIN ajr4k_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 (15) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left
749μs2.78KB/administrator/components/com_hikashop/classes/category.php:771CopySELECT * FROM ajr4k_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 '%,15,%'))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 '%,15,%'))) AND field_products="") OR (field_products LIKE '%,12,%')) ORDER BY a.`field_ordering` ASC
604μs2.73KB/administrator/components/com_hikashop/classes/field.php:167CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1744826673 AND (a.badge_end >= 1744826673 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 >= 231500482) 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 = '15' OR badge_category_id LIKE '%,15,%')) 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 = '15' OR badge_category_id LIKE '%,15,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
574μs5.05KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1744826673 AND (a.badge_end >= 1744826673 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 >= 231500477) 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 = '15' OR badge_category_id LIKE '%,15,%')) 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 = '15' OR badge_category_id LIKE '%,15,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
465μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1744826673 AND (a.badge_end >= 1744826673 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 >= 231500472) 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 = '15' OR badge_category_id LIKE '%,15,%')) 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 = '15' OR badge_category_id LIKE '%,15,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
488μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1744826673 AND (a.badge_end >= 1744826673 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 >= 231500468) 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 = '15' OR badge_category_id LIKE '%,15,%')) 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 = '15' OR badge_category_id LIKE '%,15,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
223μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1744826673 AND (a.badge_end >= 1744826673 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 >= 231500463) 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 = '15' OR badge_category_id LIKE '%,15,%')) 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 = '15' OR badge_category_id LIKE '%,15,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
397μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1744826673 AND (a.badge_end >= 1744826673 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 >= 231500452) 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 = '15' OR badge_category_id LIKE '%,15,%')) 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 = '15' OR badge_category_id LIKE '%,15,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
303μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1744826673 AND (a.badge_end >= 1744826673 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 >= 231500420) 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 = '15' OR badge_category_id LIKE '%,15,%')) 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 = '15' OR badge_category_id LIKE '%,15,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
181μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1744826673 AND (a.badge_end >= 1744826673 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 >= 231500414) 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 = '15' OR badge_category_id LIKE '%,15,%')) 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 = '15' OR badge_category_id LIKE '%,15,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
665μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1744826673 AND (a.badge_end >= 1744826673 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 >= 231500409) 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 = '15' OR badge_category_id LIKE '%,15,%')) 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 = '15' OR badge_category_id LIKE '%,15,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
1.31ms2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1744826673 AND (a.badge_end >= 1744826673 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 >= 231500399) 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 = '15' OR badge_category_id LIKE '%,15,%')) 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 = '15' OR badge_category_id LIKE '%,15,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
471μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1744826673 AND (a.badge_end >= 1744826673 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 >= 231500386) 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 = '15' OR badge_category_id LIKE '%,15,%')) 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 = '15' OR badge_category_id LIKE '%,15,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
452μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1744826673 AND (a.badge_end >= 1744826673 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 >= 231500380) 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 = '15' OR badge_category_id LIKE '%,15,%')) 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 = '15' OR badge_category_id LIKE '%,15,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
199μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT b.* FROM ajr4k_hikashop_product_category AS a LEFT JOIN ajr4k_hikashop_category AS b ON a.category_id = b.category_id WHERE a.product_id = 12 ORDER BY a.product_category_id ASC
529μs2.75KB/components/com_hikashop/views/product/view.html.php:1792CopySELECT a.id FROM ajr4k_menu AS a INNER JOIN `ajr4k_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 ('*', '', 'en-GB')
477μs552B/administrator/components/com_hikashop/classes/menus.php:323CopySELECT a.*, c.currency_symbol FROM ajr4k_hikashop_shipping AS a INNER JOIN ajr4k_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
256μs1.64KB/plugins/hikashop/shippingmanual_prices/shippingmanual_prices.php:45CopySELECT b.* FROM ajr4k_hikashop_shipping_price AS b WHERE b.shipping_id IN (1,2) AND (b.shipping_price_ref_id IS NULL OR (b.shipping_price_ref_id IN (134,135,136,137,138,139,140,141,142,143,144,145,134) AND b.shipping_price_ref_type = 'product')) ORDER BY b.shipping_price_min_quantity
86μs912B/plugins/hikashop/shippingmanual_prices/shippingmanual_prices.php:58CopySELECT * FROM ajr4k_extensions WHERE folder='hikashop' AND element='shippingmanual_prices' AND type='plugin'
252μs2.53KB/administrator/components/com_hikashop/classes/plugins.php:113CopySELECT product_average_score, product_total_vote FROM ajr4k_hikashop_product WHERE product_id = 12
274μs592B/components/com_hikashop/views/vote/view.html.php:346CopySELECT * FROM ajr4k_hikashop_vote WHERE (vote_type = 'product') AND (vote_rating != 0) AND (vote_ref_id = 12) AND (vote_ip = '3.144.251.44') AND (vote_user_id = '')
175μs1.45KB/administrator/components/com_hikashop/classes/vote.php:688CopySELECT COUNT(*) FROM `ajr4k_hikashop_vote` AS hika_vote LEFT JOIN `ajr4k_hikashop_user` AS hika_user ON hika_vote.vote_user_id=hika_user.user_id LEFT JOIN `ajr4k_users`AS users ON hika_user.user_cms_id=users.id WHERE vote_published = 1 AND vote_type = 'product' AND vote_ref_id = 12 AND vote_comment != ''
185μs536B/components/com_hikashop/views/vote/view.html.php:109CopySELECT * FROM `ajr4k_hikashop_vote` AS hika_vote LEFT JOIN `ajr4k_hikashop_user` AS hika_user ON hika_vote.vote_user_id=hika_user.user_id LEFT JOIN `ajr4k_users`AS users ON hika_user.user_cms_id=users.id WHERE vote_published = 1 AND vote_type = 'product' AND vote_ref_id = 12 AND vote_comment != '' ORDER BY `vote_date` ASC LIMIT 0,5
279μs21.23KB/components/com_hikashop/views/vote/view.html.php:115CopySELECT product_id FROM ajr4k_hikashop_product WHERE product_parent_id = 12
219μs712B/components/com_hikashop/views/vote/view.html.php:120CopySELECT * FROM ajr4k_hikashop_product WHERE product_id = '12' LIMIT 1
323μs5.47KB/administrator/components/com_hikashop/helpers/helper.php:2492CopySELECT product_average_score, product_total_vote FROM ajr4k_hikashop_product WHERE product_id = 12
95μs592B/components/com_hikashop/views/vote/view.html.php:243CopySELECT * FROM ajr4k_hikashop_vote WHERE (vote_type = 'product') AND (vote_rating != 0) AND (vote_ref_id = 12) AND (vote_ip = '3.144.251.44') AND (vote_user_id = '')
113μs1.45KB/administrator/components/com_hikashop/classes/vote.php:688CopySELECT * FROM ajr4k_extensions WHERE folder='system' AND element='hikashopsocial' AND type='plugin'
190μs2.53KB/administrator/components/com_hikashop/classes/plugins.php:113CopySELECT * FROM ajr4k_extensions WHERE folder='content' AND element='hikashopsocial' AND type='plugin'
139μs2.52KB/administrator/components/com_hikashop/classes/plugins.php:113CopySELECT `m`.`tag_id`,`t`.*
FROM `ajr4k_contentitem_tag_map` AS `m`
INNER JOIN `ajr4k_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)
436μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT cart.cart_id FROM ajr4k_hikashop_cart AS cart WHERE (cart.cart_type = 'cart') AND (cart.session_id = '7e8b498575c3e3675027801fc3ca1ec7') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
641μs520B/administrator/components/com_hikashop/classes/cart.php:69CopySELECT a.*,b.* FROM ajr4k_hikashop_category AS a LEFT JOIN ajr4k_hikashop_file AS b ON a.category_id = b.file_ref_id AND b.file_type = 'category' WHERE a.category_id = 2 LIMIT 1
1.02ms4.59KB/administrator/components/com_hikashop/classes/category.php:35CopySELECT * FROM ajr4k_hikashop_category WHERE category_id = '2' LIMIT 1
691μs2.75KB/administrator/components/com_hikashop/helpers/helper.php:2492CopySELECT a.* FROM ajr4k_hikashop_category AS a WHERE a.category_left > 2 AND a.category_right < 15 AND (a.category_type = 'product' OR a.category_type = 'vendor') AND a.category_published=1
327μs2.83KB/administrator/components/com_hikashop/classes/category.php:612CopySELECT DISTINCT b.product_id FROM ajr4k_hikashop_product_category AS a LEFT JOIN ajr4k_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 IN (12,13,14,15,16,18,2)) ORDER BY b.product_sales DESC LIMIT 3
1.11ms11.55KB/components/com_hikashop/views/product/view.html.php:863CopySELECT b.* FROM ajr4k_hikashop_product AS b WHERE product_id IN ( 3,7,56 ) ORDER BY b.product_sales DESC
571μs21.5KB/components/com_hikashop/views/product/view.html.php:870CopySELECT * FROM ajr4k_hikashop_file WHERE file_ref_id IN (3,7,56) AND file_type IN ('product','file') ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
704μs1.58KB/administrator/components/com_hikashop/classes/product.php:2401CopySELECT variant_product_id FROM ajr4k_hikashop_variant WHERE variant_product_id IN (3,7,56)
235μs712B/administrator/components/com_hikashop/classes/product.php:2425CopySELECT product_id FROM ajr4k_hikashop_product_related WHERE product_related_type = 'options' AND product_id IN (3,7,56)
134μs520B/administrator/components/com_hikashop/classes/product.php:2441CopySELECT product_parent_id, product_id, product_tax_id FROM ajr4k_hikashop_product WHERE product_parent_id IN ('3','7','56') AND product_published = 1 AND product_type = 'variant' AND product_sale_start < 1744826673 AND (product_sale_end > 1744826673 OR product_sale_end = 0)
1.13ms1.25KB/administrator/components/com_hikashop/classes/currency.php:991CopySELECT * FROM ajr4k_hikashop_discount WHERE discount_type='discount' AND discount_published=1 AND (discount_quota > discount_used_times OR discount_quota = 0) AND discount_start < 1744826673 AND (discount_end > 1744826673 OR discount_end = 0) AND ( (discount_product_id IN ('','0','3','7','56')) OR (discount_product_id LIKE '%,3,%') OR (discount_product_id LIKE '%,7,%') OR (discount_product_id LIKE '%,56,%') OR (discount_product_id LIKE '%,182,%') OR (discount_product_id LIKE '%,183,%') OR (discount_product_id LIKE '%,184,%') OR (discount_product_id LIKE '%,185,%') OR (discount_product_id LIKE '%,186,%') OR (discount_product_id LIKE '%,187,%') OR (discount_product_id LIKE '%,188,%') OR (discount_product_id LIKE '%,189,%') OR (discount_product_id LIKE '%,190,%') OR (discount_product_id LIKE '%,191,%') OR (discount_product_id LIKE '%,192,%') OR (discount_product_id LIKE '%,193,%') OR (discount_product_id LIKE '%,254,%') OR (discount_product_id LIKE '%,255,%') OR (discount_product_id LIKE '%,256,%') OR (discount_product_id LIKE '%,257,%') OR (discount_product_id LIKE '%,258,%') OR (discount_product_id LIKE '%,259,%') OR (discount_product_id LIKE '%,260,%') OR (discount_product_id LIKE '%,261,%') OR (discount_product_id LIKE '%,262,%') OR (discount_product_id LIKE '%,263,%') OR (discount_product_id LIKE '%,264,%') OR (discount_product_id LIKE '%,265,%') OR (discount_product_id LIKE '%,434,%') OR (discount_product_id LIKE '%,435,%') OR (discount_product_id LIKE '%,436,%') OR (discount_product_id LIKE '%,437,%') OR (discount_product_id LIKE '%,438,%') OR (discount_product_id LIKE '%,439,%') OR (discount_product_id LIKE '%,440,%') OR (discount_product_id LIKE '%,441,%') OR (discount_product_id LIKE '%,442,%') OR (discount_product_id LIKE '%,443,%') OR (discount_product_id LIKE '%,444,%') OR (discount_product_id LIKE '%,445,%') ) AND (discount_flat_amount != 0 OR discount_percent_amount != 0) AND (discount_flat_amount = 0 OR discount_currency_id =2) AND (discount_user_id = '' OR discount_user_id LIKE '%,0,%')
341μs3.08KB/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 ajr4k_hikashop_price AS a WHERE a.price_product_id IN (3,7,56) AND a.price_currency_id IN (1,2) AND a.price_start_date < 1744826673 AND (a.price_end_date < 1 OR a.price_end_date > 1744826673) 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
492μs1.47KB/administrator/components/com_hikashop/classes/currency.php:589CopySELECT c.*, pc.* FROM ajr4k_hikashop_category AS c LEFT JOIN ajr4k_hikashop_product_category AS pc ON c.category_id = pc.category_id WHERE pc.product_id IN (3,7,56);
300μs3.03KB/administrator/components/com_hikashop/classes/product.php:2492CopySELECT hk_parent.* FROM ajr4k_hikashop_category AS hk_cat LEFT JOIN ajr4k_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 (13) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left
623μs2.78KB/administrator/components/com_hikashop/classes/category.php:771CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1744826673 AND (a.badge_end >= 1744826673 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 >= 232794012) 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 = '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 = '13' OR badge_category_id LIKE '%,13,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
189μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT hk_parent.* FROM ajr4k_hikashop_category AS hk_cat LEFT JOIN ajr4k_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 (12) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left
496μs2.78KB/administrator/components/com_hikashop/classes/category.php:771CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1744826673 AND (a.badge_end >= 1744826673 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 >= 232793272) 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 = '12' OR badge_category_id LIKE '%,12,%')) 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 = '12' OR badge_category_id LIKE '%,12,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
224μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1744826673 AND (a.badge_end >= 1744826673 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 >= 231672930) 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 = '12' OR badge_category_id LIKE '%,12,%')) 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 = '12' OR badge_category_id LIKE '%,12,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
429μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT COUNT( DISTINCT b.product_id ) FROM ajr4k_hikashop_product_category AS a LEFT JOIN ajr4k_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 IN (12,13,14,15,16,18,2)) ORDER BY b.product_sales DESC
1.11ms536B/components/com_hikashop/views/product/view.html.php:926CopySELECT * FROM ajr4k_hikashop_characteristic WHERE characteristic_values_on_listing > 0 ORDER BY characteristic_ordering ASC;
144μs1.27KB/components/com_hikashop/views/product/view.html.php:1151CopySELECT a.id, a.link, a.params FROM ajr4k_menu AS a INNER JOIN `ajr4k_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=category&layout=listing' OR a.link='index.php?option=com_hikashop&view=product&layout=listing') AND a.language IN ('*', '', 'en-GB')
491μs16.81KB/administrator/components/com_hikashop/helpers/helper.php:1075CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 3 ORDER BY pc.product_category_id ASC
215μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 3 ORDER BY pc.product_category_id ASC
244μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT * FROM ajr4k_hikashop_vote WHERE (vote_type = 'product') AND (vote_rating != 0) AND (vote_ref_id = 3) AND (vote_ip = '3.144.251.44') AND (vote_user_id = '')
214μs1.45KB/administrator/components/com_hikashop/classes/vote.php:688CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 7 ORDER BY pc.product_category_id ASC
143μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 7 ORDER BY pc.product_category_id ASC
152μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT * FROM ajr4k_hikashop_vote WHERE (vote_type = 'product') AND (vote_rating != 0) AND (vote_ref_id = 7) AND (vote_ip = '3.144.251.44') AND (vote_user_id = '')
116μs1.45KB/administrator/components/com_hikashop/classes/vote.php:688CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 56 ORDER BY pc.product_category_id ASC
201μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 56 ORDER BY pc.product_category_id ASC
114μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT * FROM ajr4k_hikashop_vote WHERE (vote_type = 'product') AND (vote_rating != 0) AND (vote_ref_id = 56) AND (vote_ip = '3.144.251.44') AND (vote_user_id = '')
118μs1.45KB/administrator/components/com_hikashop/classes/vote.php:688CopySELECT cart.cart_id FROM ajr4k_hikashop_cart AS cart WHERE (cart.cart_type = 'cart') AND (cart.session_id = '7e8b498575c3e3675027801fc3ca1ec7') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
190μs520B/administrator/components/com_hikashop/classes/cart.php:69CopySELECT a.*,b.* FROM ajr4k_hikashop_category AS a LEFT JOIN ajr4k_hikashop_file AS b ON a.category_id = b.file_ref_id AND b.file_type = 'category' WHERE a.category_id = 2 LIMIT 1
272μs4.59KB/administrator/components/com_hikashop/classes/category.php:35CopySELECT * FROM ajr4k_hikashop_category WHERE category_id = '2' LIMIT 1
107μs2.75KB/administrator/components/com_hikashop/helpers/helper.php:2492CopySELECT a.* FROM ajr4k_hikashop_category AS a WHERE a.category_left > 2 AND a.category_right < 15 AND (a.category_type = 'product' OR a.category_type = 'vendor') AND a.category_published=1
609μs2.83KB/administrator/components/com_hikashop/classes/category.php:612CopySELECT DISTINCT b.product_id FROM ajr4k_hikashop_product_category AS a LEFT JOIN ajr4k_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 IN (12,13,14,15,16,18,2)) ORDER BY b.product_created ASC LIMIT 3
462μs568B/components/com_hikashop/views/product/view.html.php:863CopySELECT b.* FROM ajr4k_hikashop_product AS b WHERE product_id IN ( 1,2,3 ) ORDER BY b.product_created ASC
432μs5.5KB/components/com_hikashop/views/product/view.html.php:870CopySELECT * FROM ajr4k_hikashop_file WHERE file_ref_id IN (1,2,3) AND file_type IN ('product','file') ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
431μs1.58KB/administrator/components/com_hikashop/classes/product.php:2401CopySELECT variant_product_id FROM ajr4k_hikashop_variant WHERE variant_product_id IN (1,2,3)
99μs712B/administrator/components/com_hikashop/classes/product.php:2425CopySELECT product_id FROM ajr4k_hikashop_product_related WHERE product_related_type = 'options' AND product_id IN (1,2,3)
52μs520B/administrator/components/com_hikashop/classes/product.php:2441CopySELECT product_parent_id, product_id, product_tax_id FROM ajr4k_hikashop_product WHERE product_parent_id IN ('1','2','3') AND product_published = 1 AND product_type = 'variant' AND product_sale_start < 1744826673 AND (product_sale_end > 1744826673 OR product_sale_end = 0)
483μs1.25KB/administrator/components/com_hikashop/classes/currency.php:991CopySELECT * FROM ajr4k_hikashop_discount WHERE discount_type='discount' AND discount_published=1 AND (discount_quota > discount_used_times OR discount_quota = 0) AND discount_start < 1744826673 AND (discount_end > 1744826673 OR discount_end = 0) AND ( (discount_product_id IN ('','0','1','2','3')) OR (discount_product_id LIKE '%,1,%') OR (discount_product_id LIKE '%,2,%') OR (discount_product_id LIKE '%,3,%') OR (discount_product_id LIKE '%,64,%') OR (discount_product_id LIKE '%,66,%') OR (discount_product_id LIKE '%,63,%') OR (discount_product_id LIKE '%,61,%') OR (discount_product_id LIKE '%,65,%') OR (discount_product_id LIKE '%,67,%') OR (discount_product_id LIKE '%,68,%') OR (discount_product_id LIKE '%,69,%') OR (discount_product_id LIKE '%,70,%') OR (discount_product_id LIKE '%,71,%') OR (discount_product_id LIKE '%,72,%') OR (discount_product_id LIKE '%,73,%') OR (discount_product_id LIKE '%,122,%') OR (discount_product_id LIKE '%,123,%') OR (discount_product_id LIKE '%,124,%') OR (discount_product_id LIKE '%,125,%') OR (discount_product_id LIKE '%,126,%') OR (discount_product_id LIKE '%,127,%') OR (discount_product_id LIKE '%,128,%') OR (discount_product_id LIKE '%,129,%') OR (discount_product_id LIKE '%,130,%') OR (discount_product_id LIKE '%,131,%') OR (discount_product_id LIKE '%,132,%') OR (discount_product_id LIKE '%,133,%') OR (discount_product_id LIKE '%,182,%') OR (discount_product_id LIKE '%,183,%') OR (discount_product_id LIKE '%,184,%') OR (discount_product_id LIKE '%,185,%') OR (discount_product_id LIKE '%,186,%') OR (discount_product_id LIKE '%,187,%') OR (discount_product_id LIKE '%,188,%') OR (discount_product_id LIKE '%,189,%') OR (discount_product_id LIKE '%,190,%') OR (discount_product_id LIKE '%,191,%') OR (discount_product_id LIKE '%,192,%') OR (discount_product_id LIKE '%,193,%') ) AND (discount_flat_amount != 0 OR discount_percent_amount != 0) AND (discount_flat_amount = 0 OR discount_currency_id =2) AND (discount_user_id = '' OR discount_user_id LIKE '%,0,%')
258μs3.08KB/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 ajr4k_hikashop_price AS a WHERE a.price_product_id IN (1,2,3) AND a.price_currency_id IN (1,2) AND a.price_start_date < 1744826673 AND (a.price_end_date < 1 OR a.price_end_date > 1744826673) 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
571μs1.45KB/administrator/components/com_hikashop/classes/currency.php:589CopySELECT * FROM ajr4k_hikashop_price WHERE price_product_id IN (64,66,63,61,65,67,68,69,70,71,72,73) AND price_currency_id IN (1,2) AND price_start_date < 1744826673 AND (price_end_date < 1 OR price_end_date > 1744826673) AND (price_access = 'all' OR price_access LIKE '%,9,%' OR ISNULL(price_access)) AND (price_users = '' OR price_users LIKE '%,0,%')
242μs1.33KB/administrator/components/com_hikashop/classes/currency.php:770CopySELECT c.*, pc.* FROM ajr4k_hikashop_category AS c LEFT JOIN ajr4k_hikashop_product_category AS pc ON c.category_id = pc.category_id WHERE pc.product_id IN (1,2,3);
213μs3.03KB/administrator/components/com_hikashop/classes/product.php:2492CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1744826673 AND (a.badge_end >= 1744826673 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 >= 232794207) 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 = '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 = '13' OR badge_category_id LIKE '%,13,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
624μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1744826673 AND (a.badge_end >= 1744826673 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 >= 232794021) 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 = '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 = '13' OR badge_category_id LIKE '%,13,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
153μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT COUNT( DISTINCT b.product_id ) FROM ajr4k_hikashop_product_category AS a LEFT JOIN ajr4k_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 IN (12,13,14,15,16,18,2)) ORDER BY b.product_created ASC
438μs536B/components/com_hikashop/views/product/view.html.php:926CopySELECT * FROM ajr4k_hikashop_characteristic WHERE characteristic_values_on_listing > 0 ORDER BY characteristic_ordering ASC;
106μs1.27KB/components/com_hikashop/views/product/view.html.php:1151CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 1 ORDER BY pc.product_category_id ASC
134μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 1 ORDER BY pc.product_category_id ASC
131μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT * FROM ajr4k_hikashop_vote WHERE (vote_type = 'product') AND (vote_rating != 0) AND (vote_ref_id = 1) AND (vote_ip = '3.144.251.44') AND (vote_user_id = '')
212μs1.45KB/administrator/components/com_hikashop/classes/vote.php:688CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 2 ORDER BY pc.product_category_id ASC
212μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 2 ORDER BY pc.product_category_id ASC
159μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT * FROM ajr4k_hikashop_vote WHERE (vote_type = 'product') AND (vote_rating != 0) AND (vote_ref_id = 2) AND (vote_ip = '3.144.251.44') AND (vote_user_id = '')
198μs1.45KB/administrator/components/com_hikashop/classes/vote.php:688CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 3 ORDER BY pc.product_category_id ASC
264μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 3 ORDER BY pc.product_category_id ASC
193μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT * FROM ajr4k_hikashop_vote WHERE (vote_type = 'product') AND (vote_rating != 0) AND (vote_ref_id = 3) AND (vote_ip = '3.144.251.44') AND (vote_user_id = '')
126μs1.45KB/administrator/components/com_hikashop/classes/vote.php:688CopySELECT cart.cart_id FROM ajr4k_hikashop_cart AS cart WHERE (cart.cart_type = 'cart') AND (cart.session_id = '7e8b498575c3e3675027801fc3ca1ec7') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
209μs520B/administrator/components/com_hikashop/classes/cart.php:69CopySELECT a.*,b.* FROM ajr4k_hikashop_category AS a LEFT JOIN ajr4k_hikashop_file AS b ON a.category_id = b.file_ref_id AND b.file_type = 'category' WHERE a.category_id = 2 LIMIT 1
263μs4.59KB/administrator/components/com_hikashop/classes/category.php:35CopySELECT * FROM ajr4k_hikashop_category WHERE category_id = '2' LIMIT 1
108μs2.75KB/administrator/components/com_hikashop/helpers/helper.php:2492CopySELECT a.* FROM ajr4k_hikashop_category AS a WHERE a.category_left > 2 AND a.category_right < 15 AND (a.category_type = 'product' OR a.category_type = 'vendor') AND a.category_published=1
232μs2.83KB/administrator/components/com_hikashop/classes/category.php:612CopySELECT DISTINCT b.* FROM ajr4k_hikashop_product_category AS a LEFT JOIN ajr4k_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 IN (12,13,14,15,16,18,2)) ORDER BY a.ordering ASC LIMIT 3
3.36ms5.5KB/components/com_hikashop/views/product/view.html.php:874CopySELECT * FROM ajr4k_hikashop_file WHERE file_ref_id IN (1,10,15) AND file_type IN ('product','file') ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
282μs1.55KB/administrator/components/com_hikashop/classes/product.php:2401CopySELECT variant_product_id FROM ajr4k_hikashop_variant WHERE variant_product_id IN (1,10,15)
88μs712B/administrator/components/com_hikashop/classes/product.php:2425CopySELECT product_id FROM ajr4k_hikashop_product_related WHERE product_related_type = 'options' AND product_id IN (1,10,15)
52μs520B/administrator/components/com_hikashop/classes/product.php:2441CopySELECT product_parent_id, product_id, product_tax_id FROM ajr4k_hikashop_product WHERE product_parent_id IN ('1','10','15') AND product_published = 1 AND product_type = 'variant' AND product_sale_start < 1744826673 AND (product_sale_end > 1744826673 OR product_sale_end = 0)
476μs1.25KB/administrator/components/com_hikashop/classes/currency.php:991CopySELECT * FROM ajr4k_hikashop_discount WHERE discount_type='discount' AND discount_published=1 AND (discount_quota > discount_used_times OR discount_quota = 0) AND discount_start < 1744826673 AND (discount_end > 1744826673 OR discount_end = 0) AND ( (discount_product_id IN ('','0','1','10','15')) OR (discount_product_id LIKE '%,1,%') OR (discount_product_id LIKE '%,10,%') OR (discount_product_id LIKE '%,15,%') OR (discount_product_id LIKE '%,64,%') OR (discount_product_id LIKE '%,66,%') OR (discount_product_id LIKE '%,63,%') OR (discount_product_id LIKE '%,61,%') OR (discount_product_id LIKE '%,65,%') OR (discount_product_id LIKE '%,67,%') OR (discount_product_id LIKE '%,68,%') OR (discount_product_id LIKE '%,69,%') OR (discount_product_id LIKE '%,70,%') OR (discount_product_id LIKE '%,71,%') OR (discount_product_id LIKE '%,72,%') OR (discount_product_id LIKE '%,73,%') OR (discount_product_id LIKE '%,74,%') OR (discount_product_id LIKE '%,75,%') OR (discount_product_id LIKE '%,76,%') OR (discount_product_id LIKE '%,77,%') OR (discount_product_id LIKE '%,78,%') OR (discount_product_id LIKE '%,79,%') OR (discount_product_id LIKE '%,80,%') OR (discount_product_id LIKE '%,81,%') OR (discount_product_id LIKE '%,82,%') OR (discount_product_id LIKE '%,83,%') OR (discount_product_id LIKE '%,84,%') OR (discount_product_id LIKE '%,85,%') OR (discount_product_id LIKE '%,86,%') OR (discount_product_id LIKE '%,87,%') OR (discount_product_id LIKE '%,88,%') OR (discount_product_id LIKE '%,89,%') OR (discount_product_id LIKE '%,90,%') OR (discount_product_id LIKE '%,91,%') OR (discount_product_id LIKE '%,92,%') OR (discount_product_id LIKE '%,93,%') OR (discount_product_id LIKE '%,94,%') OR (discount_product_id LIKE '%,95,%') OR (discount_product_id LIKE '%,96,%') OR (discount_product_id LIKE '%,97,%') ) AND (discount_flat_amount != 0 OR discount_percent_amount != 0) AND (discount_flat_amount = 0 OR discount_currency_id =2) AND (discount_user_id = '' OR discount_user_id LIKE '%,0,%')
237μs3.08KB/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 ajr4k_hikashop_price AS a WHERE a.price_product_id IN (1,10,15) AND a.price_currency_id IN (1,2) AND a.price_start_date < 1744826673 AND (a.price_end_date < 1 OR a.price_end_date > 1744826673) 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
365μs1.45KB/administrator/components/com_hikashop/classes/currency.php:589CopySELECT * FROM ajr4k_hikashop_price WHERE price_product_id IN (64,66,63,61,65,67,68,69,70,71,72,73) AND price_currency_id IN (1,2) AND price_start_date < 1744826673 AND (price_end_date < 1 OR price_end_date > 1744826673) AND (price_access = 'all' OR price_access LIKE '%,9,%' OR ISNULL(price_access)) AND (price_users = '' OR price_users LIKE '%,0,%')
170μs9.33KB/administrator/components/com_hikashop/classes/currency.php:770CopySELECT c.*, pc.* FROM ajr4k_hikashop_category AS c LEFT JOIN ajr4k_hikashop_product_category AS pc ON c.category_id = pc.category_id WHERE pc.product_id IN (1,10,15);
249μs3.03KB/administrator/components/com_hikashop/classes/product.php:2492CopySELECT hk_parent.* FROM ajr4k_hikashop_category AS hk_cat LEFT JOIN ajr4k_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 (18) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left
530μs2.78KB/administrator/components/com_hikashop/classes/category.php:771CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1744826673 AND (a.badge_end >= 1744826673 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 >= 232792412) 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 = '18' OR badge_category_id LIKE '%,18,%')) 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 = '18' OR badge_category_id LIKE '%,18,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
193μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT COUNT( DISTINCT b.product_id ) FROM ajr4k_hikashop_product_category AS a LEFT JOIN ajr4k_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 IN (12,13,14,15,16,18,2)) ORDER BY a.ordering ASC
436μs536B/components/com_hikashop/views/product/view.html.php:926CopySELECT * FROM ajr4k_hikashop_characteristic WHERE characteristic_values_on_listing > 0 ORDER BY characteristic_ordering ASC;
119μs1.27KB/components/com_hikashop/views/product/view.html.php:1151CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 1 ORDER BY pc.product_category_id ASC
218μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 1 ORDER BY pc.product_category_id ASC
198μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT * FROM ajr4k_hikashop_vote WHERE (vote_type = 'product') AND (vote_rating != 0) AND (vote_ref_id = 1) AND (vote_ip = '3.144.251.44') AND (vote_user_id = '')
136μs1.45KB/administrator/components/com_hikashop/classes/vote.php:688CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 10 ORDER BY pc.product_category_id ASC
112μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 10 ORDER BY pc.product_category_id ASC
115μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT * FROM ajr4k_hikashop_vote WHERE (vote_type = 'product') AND (vote_rating != 0) AND (vote_ref_id = 10) AND (vote_ip = '3.144.251.44') AND (vote_user_id = '')
115μs1.45KB/administrator/components/com_hikashop/classes/vote.php:688CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15 ORDER BY pc.product_category_id ASC
105μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15 ORDER BY pc.product_category_id ASC
100μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT * FROM ajr4k_hikashop_vote WHERE (vote_type = 'product') AND (vote_rating != 0) AND (vote_ref_id = 15) AND (vote_ip = '3.144.251.44') AND (vote_user_id = '')
151μs1.45KB/administrator/components/com_hikashop/classes/vote.php:688CopySELECT `language`,`id`
FROM `ajr4k_menu`
WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0
701μs592B/libraries/src/Language/Multilanguage.php:123CopySELECT `c2`.`language`,`c2`.`id`
FROM `ajr4k_menu` AS `c`
INNER JOIN `ajr4k_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context
INNER JOIN `ajr4k_associations` AS `a2` ON `a`.`key` = `a2`.`key`
INNER JOIN `ajr4k_menu` AS `c2` ON `a2`.`id` = `c2`.`id`
WHERE `c`.`id` = :id
802μs1.38KBParams/libraries/src/Language/Associations.php:145CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `ajr4k_modules` AS `m`
LEFT JOIN `ajr4k_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `ajr4k_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) AND `m`.`language` IN (:preparedArray3,:preparedArray4)
ORDER BY `m`.`position`,`m`.`ordering`
2.69ms18.22KBParams/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`,`fp`.`ordering`
FROM `ajr4k_content` AS `a`
LEFT JOIN `ajr4k_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `ajr4k_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `ajr4k_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `ajr4k_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `ajr4k_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray11,:preparedArray12)
ORDER BY a.created DESC LIMIT 5
12.47ms55.2KBParams/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 `ajr4k_categories` AS `s`
INNER JOIN `ajr4k_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
551μs3.98KBParams/libraries/src/Categories/Categories.php:375CopySELECT *
FROM `ajr4k_banners`
WHERE
(`reset` <= :date AND `reset` IS NOT NULL) AND
(`checked_out` IS NULL OR `checked_out` = :userId)
1.35ms5.39KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69CopySELECT `a`.`id`,`a`.`type`,`a`.`name`,`a`.`clickurl`,`a`.`sticky`,`a`.`cid`,`a`.`description`,`a`.`params`,`a`.`custombannercode`,`a`.`track_impressions`,`cl`.`track_impressions` AS `client_track_impressions`
FROM `ajr4k_banners` AS `a`
LEFT JOIN `ajr4k_banner_clients` AS `cl` ON `cl`.`id` = `a`.`cid`
WHERE
(
(
(`a`.`state` = 1) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2)) AND
(`a`.`imptotal` = 0 OR `a`.`impmade` < `a`.`imptotal`) AND `a`.`catid` IN (:preparedArray1) AND `a`.`language` IN (:preparedArray2,:preparedArray3)
ORDER BY `a`.`sticky` DESC, `a`.`ordering` LIMIT 5
2.38ms2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
296μs856BParams/components/com_banners/src/Model/BannersModel.php:315CopySELECT *
FROM `ajr4k_banners`
WHERE
(`reset` <= :date AND `reset` IS NOT NULL) AND
(`checked_out` IS NULL OR `checked_out` = :userId)
223μs5.34KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69CopySELECT `a`.`id`,`a`.`type`,`a`.`name`,`a`.`clickurl`,`a`.`sticky`,`a`.`cid`,`a`.`description`,`a`.`params`,`a`.`custombannercode`,`a`.`track_impressions`,`cl`.`track_impressions` AS `client_track_impressions`
FROM `ajr4k_banners` AS `a`
LEFT JOIN `ajr4k_banner_clients` AS `cl` ON `cl`.`id` = `a`.`cid`
WHERE
(
(
(`a`.`state` = 1) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2)) AND
(`a`.`imptotal` = 0 OR `a`.`impmade` < `a`.`imptotal`) AND `a`.`catid` IN (:preparedArray1) AND `a`.`language` IN (:preparedArray2,:preparedArray3)
ORDER BY `a`.`sticky` DESC, `a`.`ordering` LIMIT 5
371μs2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
156μs856BParams/components/com_banners/src/Model/BannersModel.php:315CopySELECT `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`,(
SELECT COUNT(`i`.`id`)
FROM `ajr4k_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1 AND `i`.`language` IN (:preparedArray5,:preparedArray6)) AS `numitems`
FROM `ajr4k_categories` AS `s`
INNER JOIN `ajr4k_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
696μs4.08KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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`,`fp`.`ordering`
FROM `ajr4k_content` AS `a`
LEFT JOIN `ajr4k_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `ajr4k_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `ajr4k_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `ajr4k_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `ajr4k_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10) AND `a`.`created_by_alias` IN (:preparedArray11) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray12,:preparedArray13)
ORDER BY a.title ASC LIMIT 5
1.85ms55.2KBParams/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 `ajr4k_categories` AS `s`
INNER JOIN `ajr4k_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
751μs3.98KBParams/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 `ajr4k_categories` AS `s`
INNER JOIN `ajr4k_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
440μs3.98KBParams/libraries/src/Categories/Categories.php:375CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 11
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
2.92ms704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 11
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
263μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 9
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
209μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 12
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
188μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 9
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
318μs704B/templates/ja_allure/helper.php:41CopySELECT *
FROM `ajr4k_banners`
WHERE
(`reset` <= :date AND `reset` IS NOT NULL) AND
(`checked_out` IS NULL OR `checked_out` = :userId)
772μs5.39KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69CopySELECT `a`.`id`,`a`.`type`,`a`.`name`,`a`.`clickurl`,`a`.`sticky`,`a`.`cid`,`a`.`description`,`a`.`params`,`a`.`custombannercode`,`a`.`track_impressions`,`cl`.`track_impressions` AS `client_track_impressions`
FROM `ajr4k_banners` AS `a`
LEFT JOIN `ajr4k_banner_clients` AS `cl` ON `cl`.`id` = `a`.`cid`
WHERE
(
(
(`a`.`state` = 1) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2)) AND
(`a`.`imptotal` = 0 OR `a`.`impmade` < `a`.`imptotal`) AND `a`.`catid` IN (:preparedArray1) AND `a`.`language` IN (:preparedArray2,:preparedArray3)
ORDER BY `a`.`sticky` DESC, `a`.`ordering` LIMIT 5
959μs2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
168μs856BParams/components/com_banners/src/Model/BannersModel.php:315CopySELECT `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`,`fp`.`ordering`
FROM `ajr4k_content` AS `a`
LEFT JOIN `ajr4k_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `ajr4k_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `ajr4k_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `ajr4k_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `ajr4k_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10) AND `a`.`created_by_alias` IN (:preparedArray11) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray12,:preparedArray13)
ORDER BY a.title ASC LIMIT 4
3.23ms39.14KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT 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 ajr4k_fields AS a
LEFT JOIN `ajr4k_languages` AS l ON l.lang_code = a.language
LEFT JOIN ajr4k_users AS uc ON uc.id=a.checked_out
LEFT JOIN ajr4k_viewlevels AS ag ON ag.id = a.access
LEFT JOIN ajr4k_users AS ua ON ua.id = a.created_user_id
LEFT JOIN ajr4k_fields_groups AS g ON g.id = a.group_id
WHERE
(
(`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND
(`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform
ORDER BY a.ordering ASC
1.02ms4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 11
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
300μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 11
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
252μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 9
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
219μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 12
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
208μs704B/templates/ja_allure/helper.php:41CopySELECT *
FROM `ajr4k_banners`
WHERE
(`reset` <= :date AND `reset` IS NOT NULL) AND
(`checked_out` IS NULL OR `checked_out` = :userId)
248μs5.39KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69CopySELECT `a`.`id`,`a`.`type`,`a`.`name`,`a`.`clickurl`,`a`.`sticky`,`a`.`cid`,`a`.`description`,`a`.`params`,`a`.`custombannercode`,`a`.`track_impressions`,`cl`.`track_impressions` AS `client_track_impressions`
FROM `ajr4k_banners` AS `a`
LEFT JOIN `ajr4k_banner_clients` AS `cl` ON `cl`.`id` = `a`.`cid`
WHERE
(
(
(`a`.`state` = 1) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2)) AND
(`a`.`imptotal` = 0 OR `a`.`impmade` < `a`.`imptotal`) AND `a`.`catid` IN (:preparedArray1) AND `a`.`language` IN (:preparedArray2,:preparedArray3)
ORDER BY `a`.`sticky` DESC, `a`.`ordering` LIMIT 5
637μs2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
207μs856BParams/components/com_banners/src/Model/BannersModel.php:315CopySELECT `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`,`fp`.`ordering`
FROM `ajr4k_content` AS `a`
LEFT JOIN `ajr4k_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `ajr4k_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `ajr4k_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `ajr4k_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `ajr4k_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5) AND `a`.`created_by_alias` IN (:preparedArray6) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray7,:preparedArray8)
ORDER BY a.title ASC LIMIT 3
696μs39.06KBParams/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 `ajr4k_categories` AS `s`
INNER JOIN `ajr4k_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
376μs3.98KBParams/libraries/src/Categories/Categories.php:375CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 10
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
238μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 10
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
323μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 10
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
156μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 10
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
216μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 10
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
156μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 10
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
533μs704B/templates/ja_allure/helper.php:41CopySELECT `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`,`fp`.`ordering`
FROM `ajr4k_content` AS `a`
LEFT JOIN `ajr4k_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `ajr4k_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `ajr4k_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `ajr4k_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `ajr4k_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5) AND `a`.`created_by_alias` IN (:preparedArray6) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray7,:preparedArray8)
ORDER BY fp.ordering ASC LIMIT 3
1.7ms39.11KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 9
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
746μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 9
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
264μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 9
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
210μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 9
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
242μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 9
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
503μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 9
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
309μs704B/templates/ja_allure/helper.php:41CopySELECT `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`,`fp`.`ordering`
FROM `ajr4k_content` AS `a`
LEFT JOIN `ajr4k_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `ajr4k_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `ajr4k_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `ajr4k_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `ajr4k_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5) AND `a`.`created_by_alias` IN (:preparedArray6) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray7,:preparedArray8)
ORDER BY a.title ASC LIMIT 3
769μs39.11KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 11
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
284μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 11
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
262μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 11
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
360μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 11
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
213μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 11
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
674μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 11
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
230μs704B/templates/ja_allure/helper.php:41CopySELECT *
FROM `ajr4k_banners`
WHERE
(`reset` <= :date AND `reset` IS NOT NULL) AND
(`checked_out` IS NULL OR `checked_out` = :userId)
876μs5.39KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69CopySELECT `a`.`id`,`a`.`type`,`a`.`name`,`a`.`clickurl`,`a`.`sticky`,`a`.`cid`,`a`.`description`,`a`.`params`,`a`.`custombannercode`,`a`.`track_impressions`,`cl`.`track_impressions` AS `client_track_impressions`
FROM `ajr4k_banners` AS `a`
LEFT JOIN `ajr4k_banner_clients` AS `cl` ON `cl`.`id` = `a`.`cid`
WHERE
(
(
(`a`.`state` = 1) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2)) AND
(`a`.`imptotal` = 0 OR `a`.`impmade` < `a`.`imptotal`) AND `a`.`catid` IN (:preparedArray1) AND `a`.`language` IN (:preparedArray2,:preparedArray3)
ORDER BY `a`.`sticky` DESC, `a`.`ordering` LIMIT 5
886μs2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
199μs856BParams/components/com_banners/src/Model/BannersModel.php:315CopySELECT cart.cart_id FROM ajr4k_hikashop_cart AS cart WHERE (cart.cart_type = 'cart') AND (cart.session_id = '7e8b498575c3e3675027801fc3ca1ec7') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
396μs472B/administrator/components/com_hikashop/classes/cart.php:69CopySELECT a.*,b.* FROM ajr4k_hikashop_category AS a LEFT JOIN ajr4k_hikashop_file AS b ON a.category_id = b.file_ref_id AND b.file_type = 'category' WHERE a.category_id = 15 LIMIT 1
437μs4.59KB/administrator/components/com_hikashop/classes/category.php:35CopySELECT DISTINCT b.* FROM ajr4k_hikashop_product_category AS a LEFT JOIN ajr4k_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 IN (15)) ORDER BY a.ordering ASC LIMIT 2
1.35ms5.48KB/components/com_hikashop/views/product/view.html.php:874CopySELECT * FROM ajr4k_hikashop_file WHERE file_ref_id IN (13,12) AND file_type IN ('product','file') ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
354μs1.52KB/administrator/components/com_hikashop/classes/product.php:2401CopySELECT variant_product_id FROM ajr4k_hikashop_variant WHERE variant_product_id IN (13,12)
139μs648B/administrator/components/com_hikashop/classes/product.php:2425CopySELECT product_id FROM ajr4k_hikashop_product_related WHERE product_related_type = 'options' AND product_id IN (13,12)
1.09ms520B/administrator/components/com_hikashop/classes/product.php:2441CopySELECT product_parent_id, product_id, product_tax_id FROM ajr4k_hikashop_product WHERE product_parent_id IN ('13','12') AND product_published = 1 AND product_type = 'variant' AND product_sale_start < 1744826673 AND (product_sale_end > 1744826673 OR product_sale_end = 0)
332μs1KB/administrator/components/com_hikashop/classes/currency.php:991CopySELECT * FROM ajr4k_hikashop_discount WHERE discount_type='discount' AND discount_published=1 AND (discount_quota > discount_used_times OR discount_quota = 0) AND discount_start < 1744826673 AND (discount_end > 1744826673 OR discount_end = 0) AND ( (discount_product_id IN ('','0','13','12')) OR (discount_product_id LIKE '%,13,%') OR (discount_product_id LIKE '%,12,%') OR (discount_product_id LIKE '%,134,%') OR (discount_product_id LIKE '%,135,%') OR (discount_product_id LIKE '%,136,%') OR (discount_product_id LIKE '%,137,%') OR (discount_product_id LIKE '%,138,%') OR (discount_product_id LIKE '%,139,%') OR (discount_product_id LIKE '%,140,%') OR (discount_product_id LIKE '%,141,%') OR (discount_product_id LIKE '%,142,%') OR (discount_product_id LIKE '%,143,%') OR (discount_product_id LIKE '%,144,%') OR (discount_product_id LIKE '%,145,%') OR (discount_product_id LIKE '%,32,%') OR (discount_product_id LIKE '%,33,%') OR (discount_product_id LIKE '%,34,%') OR (discount_product_id LIKE '%,35,%') OR (discount_product_id LIKE '%,36,%') OR (discount_product_id LIKE '%,37,%') OR (discount_product_id LIKE '%,38,%') OR (discount_product_id LIKE '%,39,%') OR (discount_product_id LIKE '%,40,%') OR (discount_product_id LIKE '%,41,%') OR (discount_product_id LIKE '%,42,%') ) AND (discount_flat_amount != 0 OR discount_percent_amount != 0) AND (discount_flat_amount = 0 OR discount_currency_id =2) AND (discount_user_id = '' OR discount_user_id LIKE '%,0,%')
282μs3.08KB/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 ajr4k_hikashop_price AS a WHERE a.price_product_id IN (13,12) AND a.price_currency_id IN (1,2) AND a.price_start_date < 1744826673 AND (a.price_end_date < 1 OR a.price_end_date > 1744826673) 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
386μs1.45KB/administrator/components/com_hikashop/classes/currency.php:589CopySELECT c.*, pc.* FROM ajr4k_hikashop_category AS c LEFT JOIN ajr4k_hikashop_product_category AS pc ON c.category_id = pc.category_id WHERE pc.product_id IN (13,12);
288μs3.02KB/administrator/components/com_hikashop/classes/product.php:2492CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1744826673 AND (a.badge_end >= 1744826673 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = 99) AND (a.badge_new_period = 0 OR a.badge_new_period >= 232792412) 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 = '15' OR badge_category_id LIKE '%,15,%')) 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 = '15' OR badge_category_id LIKE '%,15,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
300μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1744826673 AND (a.badge_end >= 1744826673 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 >= 232792412) 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 = '15' OR badge_category_id LIKE '%,15,%')) 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 = '15' OR badge_category_id LIKE '%,15,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
209μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT COUNT( DISTINCT b.product_id ) FROM ajr4k_hikashop_product_category AS a LEFT JOIN ajr4k_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 IN (15)) ORDER BY a.ordering ASC
286μs536B/components/com_hikashop/views/product/view.html.php:926CopySELECT * FROM ajr4k_hikashop_characteristic WHERE characteristic_values_on_listing > 0 ORDER BY characteristic_ordering ASC;
191μs1.27KB/components/com_hikashop/views/product/view.html.php:1151CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 13 ORDER BY pc.product_category_id ASC
250μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 13 ORDER BY pc.product_category_id ASC
326μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 12 ORDER BY pc.product_category_id ASC
172μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 12 ORDER BY pc.product_category_id ASC
110μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT `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`,`fp`.`ordering`
FROM `ajr4k_content` AS `a`
LEFT JOIN `ajr4k_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `ajr4k_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `ajr4k_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `ajr4k_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `ajr4k_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5) AND `a`.`created_by_alias` IN (:preparedArray6) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray7,:preparedArray8)
ORDER BY a.title ASC LIMIT 1
1.06ms23.08KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 10
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
289μs704B/templates/ja_allure/helper.php:41CopySELECT `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`,`fp`.`ordering`
FROM `ajr4k_content` AS `a`
LEFT JOIN `ajr4k_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `ajr4k_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `ajr4k_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `ajr4k_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `ajr4k_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10) AND `a`.`created_by_alias` IN (:preparedArray11) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray12,:preparedArray13)
ORDER BY a.title ASC LIMIT 2
1.99ms23.16KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 11
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
409μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 11
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
230μs704B/templates/ja_allure/helper.php:41CopySELECT *
FROM `ajr4k_banners`
WHERE
(`reset` <= :date AND `reset` IS NOT NULL) AND
(`checked_out` IS NULL OR `checked_out` = :userId)
217μs5.39KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69CopySELECT `a`.`id`,`a`.`type`,`a`.`name`,`a`.`clickurl`,`a`.`sticky`,`a`.`cid`,`a`.`description`,`a`.`params`,`a`.`custombannercode`,`a`.`track_impressions`,`cl`.`track_impressions` AS `client_track_impressions`
FROM `ajr4k_banners` AS `a`
LEFT JOIN `ajr4k_banner_clients` AS `cl` ON `cl`.`id` = `a`.`cid`
WHERE
(
(
(`a`.`state` = 1) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2)) AND
(`a`.`imptotal` = 0 OR `a`.`impmade` < `a`.`imptotal`) AND `a`.`catid` IN (:preparedArray1) AND `a`.`language` IN (:preparedArray2,:preparedArray3)
ORDER BY `a`.`sticky` DESC, `a`.`ordering` LIMIT 5
324μs2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
157μs856BParams/components/com_banners/src/Model/BannersModel.php:315CopySELECT 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 `ajr4k_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
1.03ms1.32KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466CopySELECT `session_id`
FROM `ajr4k_session`
WHERE `session_id` = ?
184μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyUPDATE `ajr4k_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
1.36ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy