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...
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.62MB) (13.53%) | 50.82ms |
1 x afterRenderRawModule mod_hikashop (Related products) (463.98KB) (9.75%) | 36.63ms |
1 x afterRenderRawModule mod_articles_category (Most Popular) (193.33KB) (9.2%) | 34.56ms |
1 x afterRenderRawModule mod_hikashop (Best sellers) (646.29KB) (7.44%) | 27.95ms |
1 x afterRenderRawModule mod_articles_latest (Latest Footer ) (60.02KB) (7.4%) | 27.81ms |
1 x afterRenderRawModule mod_hikashop (Latest products) (468.73KB) (5.83%) | 21.89ms |
1 x afterInitialise (950.56KB) (5.72%) | 21.49ms |
1 x afterRenderRawModule mod_hikashop (Product Banner) (214.09KB) (5.09%) | 19.14ms |
1 x afterRender (616.95KB) (4.32%) | 16.25ms |
1 x afterRenderRawModule mod_articles_category (Editor's Picks) (114.06KB) (3.5%) | 13.17ms |
1 x afterRoute (1.44MB) (3.17%) | 11.89ms |
1 x afterRenderRawModule mod_articles_category (Celebrity) (112.73KB) (2.78%) | 10.43ms |
1 x afterRenderRawModule mod_articles_category (Beauty) (74.8KB) (2.37%) | 8.91ms |
1 x afterRenderRawModule mod_articles_category (Featured Article) (40.89KB) (2.33%) | 8.74ms |
1 x afterRenderRawModule mod_articles_category (Fashion) (81.3KB) (2.07%) | 7.76ms |
1 x afterRenderRawModule mod_banners (Banner 4) (17.91KB) (1.94%) | 7.29ms |
1 x afterRenderRawModule mod_banners (Banner Top) (17.57KB) (1.38%) | 5.18ms |
1 x afterLoad (457.09KB) (1.3%) | 4.89ms |
1 x beforeRenderModule mod_footer (Footer) (124.91KB) (1.14%) | 4.27ms |
1 x afterRenderRawModule mod_banners (Banner 3) (17.57KB) (1.1%) | 4.14ms |
1 x afterRenderRawModule mod_articles_category (Lead Article) (28.79KB) (0.97%) | 3.66ms |
1 x afterDispatch (54.08KB) (0.94%) | 3.53ms |
1 x afterRenderRawModule mod_banners (Banner 2) (17.57KB) (0.87%) | 3.26ms |
1 x afterRenderRawModule mod_banners (Banner) (17.57KB) (0.77%) | 2.89ms |
1 x afterRenderRawModule mod_menu (Bonus pages) (186.63KB) (0.72%) | 2.70ms |
1 x afterRenderRawModule mod_banners (Banner right) (32.63KB) (0.68%) | 2.56ms |
1 x afterRenderRawModule mod_menu (Menu Footer) (59.25KB) (0.6%) | 2.27ms |
1 x afterRenderRawModule mod_footer (Footer) (4.93KB) (0.25%) | 940μs |
1 x beforeRenderComponent com_hikashop (19.32KB) (0.17%) | 634μs |
1 x afterRenderModule mod_hikashop (Related products) (2.25KB) (0.17%) | 631μs |
1 x afterRenderRawModule mod_custom (Social) (3.81KB) (0.15%) | 546μs |
1 x afterRenderRawModule mod_menu (Top Bar) (15.33KB) (0.13%) | 480μs |
1 x afterRenderModule mod_menu (Menu Footer) (2.31KB) (0.11%) | 420μs |
1 x afterRenderComponent com_hikashop (75.94KB) (0.1%) | 394μs |
1 x afterRenderModule mod_articles_category (Fashion) (1.69KB) (0.06%) | 224μs |
1 x afterRenderModule mod_custom (Social) (1.8KB) (0.06%) | 219μs |
1 x afterRenderModule mod_articles_category (Beauty) (4.19KB) (0.05%) | 201μs |
1 x afterRenderModule mod_articles_category (Celebrity) (1.69KB) (0.05%) | 194μs |
1 x afterRenderModule mod_articles_category (Editor's Picks) (1.7KB) (0.05%) | 190μs |
1 x afterRenderModule mod_articles_category (Most Popular) (5.89KB) (0.05%) | 184μs |
1 x afterRenderModule mod_articles_category (Lead Article) (2.3KB) (0.05%) | 181μs |
1 x afterRenderModule mod_hikashop (Best sellers) (3.26KB) (0.04%) | 167μs |
1 x afterRenderModule mod_articles_category (Featured Article) (1.7KB) (0.04%) | 160μs |
1 x beforeRenderModule mod_articles_category (Celebrity) (7.54KB) (0.04%) | 157μs |
1 x afterRenderModule mod_banners (Banner Top) (2.02KB) (0.04%) | 150μs |
1 x afterRenderModule mod_banners (Banner 4) (3.27KB) (0.04%) | 147μs |
1 x afterRenderModule mod_menu (Bonus pages) (1.64KB) (0.04%) | 147μs |
1 x afterRenderModule mod_articles_latest (Latest Footer ) (1.61KB) (0.04%) | 139μs |
1 x afterRenderModule mod_hikashop (Product Banner) (1.92KB) (0.04%) | 132μs |
1 x afterRenderModule mod_banners (Banner) (2KB) (0.03%) | 131μs |
1 x afterRenderModule mod_banners (Banner 3) (2.02KB) (0.03%) | 127μs |
1 x beforeRenderModule mod_articles_category (Editor's Picks) (7.4KB) (0.03%) | 124μs |
1 x beforeRenderModule mod_menu (Bonus pages) (8B) (0.03%) | 122μs |
1 x afterRenderModule mod_banners (Banner right) (1.81KB) (0.03%) | 122μs |
1 x beforeRenderModule mod_articles_category (Beauty) (776B) (0.03%) | 117μs |
1 x beforeRenderModule mod_articles_category (Fashion) (264B) (0.03%) | 116μs |
1 x afterRenderModule mod_banners (Banner 2) (2.02KB) (0.03%) | 116μs |
1 x beforeRenderModule mod_articles_category (Featured Article) (296B) (0.03%) | 108μs |
1 x beforeRenderModule mod_banners (Banner) (7.18KB) (0.03%) | 107μs |
1 x beforeRenderModule mod_hikashop (Product Banner) (9.73KB) (0.03%) | 104μs |
1 x afterRenderModule mod_footer (Footer) (1.98KB) (0.03%) | 104μs |
1 x beforeRenderModule mod_banners (Banner 3) (3.34KB) (0.03%) | 104μs |
1 x afterRenderModule mod_hikashop (Latest products) (2.25KB) (0.03%) | 102μs |
1 x beforeRenderModule mod_banners (Banner 2) (7.16KB) (0.03%) | 100μs |
1 x beforeRenderModule mod_articles_category (Lead Article) (2.07KB) (0.03%) | 99μs |
1 x beforeRenderModule mod_banners (Banner Top) (7.16KB) (0.03%) | 98μs |
1 x beforeRenderModule mod_custom (Social) (2.26KB) (0.03%) | 95μs |
1 x beforeRenderModule mod_banners (Banner 4) (1.37KB) (0.02%) | 87μs |
1 x beforeRenderModule mod_articles_latest (Latest Footer ) (840B) (0.02%) | 79μs |
1 x beforeRenderModule mod_hikashop (Latest products) (15.48KB) (0.02%) | 75μs |
1 x beforeRenderModule mod_menu (Top Bar) (1.24KB) (0.02%) | 72μs |
1 x afterRenderModule mod_menu (Top Bar) (1.95KB) (0.02%) | 68μs |
1 x beforeRenderModule mod_menu (Menu Footer) (2.63KB) (0.02%) | 64μs |
1 x beforeRenderModule mod_articles_category (Most Popular) (8.75KB) (0.01%) | 44μs |
1 x beforeRenderModule mod_banners (Banner right) (2KB) (0.01%) | 39μs |
1 x beforeRenderModule mod_hikashop (Related products) (536B) (0.01%) | 36μs |
1 x beforeRenderModule mod_articles_category (Most Popular) (704B) (0.01%) | 36μs |
1 x beforeRenderModule mod_banners (Banner 4) (720B) (0.01%) | 19μs |
1 x beforeRenderModule mod_banners (Banner) (704B) (0%) | 18μs |
1 x beforeRenderModule mod_articles_category (Celebrity) (704B) (0%) | 16μs |
1 x beforeRenderModule mod_articles_category (Beauty) (704B) (0%) | 16μs |
1 x beforeRenderModule mod_banners (Banner Top) (720B) (0%) | 16μs |
1 x beforeRenderModule mod_banners (Banner 3) (720B) (0%) | 15μs |
1 x beforeRenderModule mod_banners (Banner 2) (720B) (0%) | 15μs |
1 x beforeRenderModule mod_articles_category (Featured Article) (720B) (0%) | 15μs |
1 x beforeRenderModule mod_articles_latest (Latest Footer ) (704B) (0%) | 14μs |
1 x beforeRenderModule mod_articles_category (Editor's Picks) (720B) (0%) | 14μs |
1 x beforeRenderModule mod_articles_category (Lead Article) (704B) (0%) | 14μs |
1 x beforeRenderModule mod_articles_category (Fashion) (704B) (0%) | 14μs |
1 x beforeRenderModule mod_hikashop (Best sellers) (720B) (0%) | 13μs |
1 x beforeRenderModule mod_menu (Menu Footer) (720B) (0%) | 13μs |
1 x beforeRenderModule mod_hikashop (Related products) (720B) (0%) | 12μs |
1 x beforeRenderModule mod_custom (Social) (704B) (0%) | 12μs |
1 x beforeRenderModule mod_hikashop (Latest products) (720B) (0%) | 11μs |
1 x beforeRenderModule mod_hikashop (Product Banner) (720B) (0%) | 11μs |
1 x beforeRenderModule mod_footer (Footer) (704B) (0%) | 10μs |
1 x beforeRenderModule mod_menu (Bonus pages) (720B) (0%) | 10μs |
1 x beforeRenderModule mod_banners (Banner right) (720B) (0%) | 9μs |
1 x beforeRenderModule mod_menu (Top Bar) (704B) (0%) | 6μs |
SELECT @@SESSION.sql_mode;
177μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `ajr4k_session`
WHERE `session_id` = ?
188μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `ajr4k_session`
WHERE `session_id` = :session_id LIMIT 1
177μs1.31KBParams/libraries/src/Session/MetadataManager.php:187CopyUPDATE `ajr4k_session`
SET `guest` = :guest
, `time` = :time
, `userid` = :user_id
, `username` = :username
, `client_id` = :client_id
WHERE `session_id` = :session_id
284μs992BParams/libraries/src/Session/MetadataManager.php:316CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ajr4k_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
415μs1.56KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `ajr4k_viewlevels`
152μs656B/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
206μs1.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`
1.13ms3.98KBParams/libraries/src/Plugin/PluginHelper.php:294CopyUPDATE ajr4k_extensions
SET enabled=1
WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'
403μs688B/plugins/system/jacontenttype/jacontenttype.php:76CopySELECT *
FROM `ajr4k_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
338μ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
274μs848B/libraries/src/Language/LanguageHelper.php:213CopySELECT * FROM ajr4k_hikashop_config
452μs40.63KB/administrator/components/com_hikashop/classes/config.php:16CopySET sql_mode=(SELECT REPLACE(REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''), 'STRICT_TRANS_TABLES', ''));
66μ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`
1.08ms52.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
378μs848B/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 = 345) LIMIT 1
421μ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')
329μs3.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 = '8b1f738289ce13c79c2d37299f80552e') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
291μs520B/administrator/components/com_hikashop/classes/cart.php:69CopySELECT * FROM ajr4k_hikashop_currency WHERE currency_id IN (2)
156μs1.44KB/administrator/components/com_hikashop/classes/currency.php:1926CopySELECT product.*, product_category.* 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 = 19) ORDER BY product_category_id ASC LIMIT 1
552μs21.84KB/components/com_hikashop/views/product/view.html.php:1299CopyUPDATE ajr4k_hikashop_product SET product_hit = product_hit + 1, product_last_seen_date = 1743194063 WHERE product_id = 19
212μ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 = 19) AND (pr.product_related_type = 'options') AND (p.product_published = 1) AND ((p.product_sale_start = '' OR p.product_sale_start <= 1743194063)) AND ((p.product_sale_end = '' OR p.product_sale_end > 1743194063)) ORDER BY pr.product_related_ordering ASC, pr.product_related_id ASC
268μs5.41KB/components/com_hikashop/views/product/view.html.php:1341CopySELECT * FROM ajr4k_hikashop_product WHERE (product_parent_id IN (19)) AND (product_published = 1)
356μ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 (19,338,339,340,341,342,343,344,345,346,347,348,349) ORDER BY v.ordering ASC, c.characteristic_ordering ASC
992μs1.95KB/components/com_hikashop/views/product/view.html.php:1427CopySELECT * FROM ajr4k_hikashop_file WHERE file_ref_id IN (19,338,339,340,341,342,343,344,345,346,347,348,349) AND file_type IN ('product','file') ORDER BY file_ordering ASC, file_id ASC
391μs1.45KB/components/com_hikashop/views/product/view.html.php:1472CopySELECT currency_id FROM ajr4k_hikashop_currency WHERE currency_published=1 OR currency_id = 2
198μ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 < 1743194063) AND ((p.price_end_date < 1 OR p.price_end_date > 1743194063)) AND (p.price_product_id IN (19,338,339,340,341,342,343,344,345,346,347,348,349)) AND ((p.price_users = '' OR p.price_users LIKE '%,0,%')) ORDER BY p.price_site_id ASC, p.price_value DESC
236μ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 <= 1743194063 AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1743194063) ORDER BY b.taxation_id ASC
255μs2.38KB/administrator/components/com_hikashop/classes/currency.php:199CopySELECT * FROM ajr4k_hikashop_zone WHERE zone_id = 73
130μ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 < 1743194063) AND (discount_end > 1743194063 OR discount_end = 0) AND (discount_product_id IN ('','0','19','338','339','340','341','342','343','344','345','346','347','348','349') OR discount_product_id LIKE '%,19,%' OR discount_product_id LIKE '%,338,%' OR discount_product_id LIKE '%,339,%' OR discount_product_id LIKE '%,340,%' OR discount_product_id LIKE '%,341,%' OR discount_product_id LIKE '%,342,%' OR discount_product_id LIKE '%,343,%' OR discount_product_id LIKE '%,344,%' OR discount_product_id LIKE '%,345,%' OR discount_product_id LIKE '%,346,%' OR discount_product_id LIKE '%,347,%' OR discount_product_id LIKE '%,348,%' OR discount_product_id LIKE '%,349,%') 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,%'))
219μs3.08KB/administrator/components/com_hikashop/classes/currency.php:1709CopySELECT category_id FROM ajr4k_hikashop_product_category WHERE product_id IN (19) ORDER BY ordering ASC
168μ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 (18) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left
696μ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 '%,18,%'))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 '%,18,%'))) AND field_products="") OR (field_products LIKE '%,19,%')) ORDER BY a.`field_ordering` ASC
272μs5.23KB/administrator/components/com_hikashop/classes/field.php:167CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743194063 AND (a.badge_end >= 1743194063 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 >= 229863591) 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
268μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743194063 AND (a.badge_end >= 1743194063 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 >= 229863625) 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
408μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743194063 AND (a.badge_end >= 1743194063 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 >= 229863619) 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
348μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743194063 AND (a.badge_end >= 1743194063 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 >= 229863614) 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
231μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743194063 AND (a.badge_end >= 1743194063 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 >= 229863609) 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
217μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743194063 AND (a.badge_end >= 1743194063 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 >= 229863605) 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
168μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743194063 AND (a.badge_end >= 1743194063 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 >= 229863600) 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
173μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743194063 AND (a.badge_end >= 1743194063 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 >= 229863595) 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
158μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743194063 AND (a.badge_end >= 1743194063 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 >= 229863585) 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
171μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743194063 AND (a.badge_end >= 1743194063 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 >= 229863578) 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
156μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743194063 AND (a.badge_end >= 1743194063 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 >= 229863573) 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
162μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743194063 AND (a.badge_end >= 1743194063 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 >= 229863567) 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
160μ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 = 19 ORDER BY a.product_category_id ASC
268μ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')
491μ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
310μ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 (338,339,340,341,342,343,344,345,346,347,348,349) AND b.shipping_price_ref_type = 'product')) ORDER BY b.shipping_price_min_quantity
106μs912B/plugins/hikashop/shippingmanual_prices/shippingmanual_prices.php:58CopySELECT * FROM ajr4k_extensions WHERE folder='hikashop' AND element='shippingmanual_prices' AND type='plugin'
428μs2.53KB/administrator/components/com_hikashop/classes/plugins.php:113CopySELECT product_average_score, product_total_vote FROM ajr4k_hikashop_product WHERE product_id = 19
130μ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 = 19) AND (vote_ip = '18.191.246.216') AND (vote_user_id = '')
178μ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 = 19 AND vote_comment != ''
186μ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 = 19 AND vote_comment != '' ORDER BY `vote_date` ASC LIMIT 0,5
283μs21.23KB/components/com_hikashop/views/vote/view.html.php:115CopySELECT product_id FROM ajr4k_hikashop_product WHERE product_parent_id = 19
191μs712B/components/com_hikashop/views/vote/view.html.php:120CopySELECT * FROM ajr4k_hikashop_product WHERE product_id = '19' LIMIT 1
267μs5.47KB/administrator/components/com_hikashop/helpers/helper.php:2492CopySELECT product_average_score, product_total_vote FROM ajr4k_hikashop_product WHERE product_id = 19
101μ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 = 19) AND (vote_ip = '18.191.246.216') AND (vote_user_id = '')
128μs1.45KB/administrator/components/com_hikashop/classes/vote.php:688CopySELECT * FROM ajr4k_extensions WHERE folder='system' AND element='hikashopsocial' AND type='plugin'
276μs2.53KB/administrator/components/com_hikashop/classes/plugins.php:113CopySELECT * FROM ajr4k_extensions WHERE folder='content' AND element='hikashopsocial' AND type='plugin'
183μ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)
416μ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 = '8b1f738289ce13c79c2d37299f80552e') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
410μ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
382μs4.59KB/administrator/components/com_hikashop/classes/category.php:35CopySELECT * FROM ajr4k_hikashop_category WHERE category_id = '2' LIMIT 1
175μ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
253μs13.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 36, 3
575μs568B/components/com_hikashop/views/product/view.html.php:863CopySELECT b.* FROM ajr4k_hikashop_product AS b WHERE product_id IN ( 12,29,55 ) ORDER BY b.product_sales DESC
429μs5.5KB/components/com_hikashop/views/product/view.html.php:870CopySELECT * FROM ajr4k_hikashop_file WHERE file_ref_id IN (12,29,55) AND file_type IN ('product','file') ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
299μs1.58KB/administrator/components/com_hikashop/classes/product.php:2401CopySELECT variant_product_id FROM ajr4k_hikashop_variant WHERE variant_product_id IN (12,29,55)
162μ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 (12,29,55)
102μ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 ('12','29','55') AND product_published = 1 AND product_type = 'variant' AND product_sale_start < 1743194063 AND (product_sale_end > 1743194063 OR product_sale_end = 0)
373μ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 < 1743194063 AND (discount_end > 1743194063 OR discount_end = 0) AND ( (discount_product_id IN ('','0','12','29','55')) OR (discount_product_id LIKE '%,12,%') OR (discount_product_id LIKE '%,29,%') OR (discount_product_id LIKE '%,55,%') 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 '%,470,%') OR (discount_product_id LIKE '%,471,%') OR (discount_product_id LIKE '%,472,%') OR (discount_product_id LIKE '%,473,%') OR (discount_product_id LIKE '%,474,%') OR (discount_product_id LIKE '%,475,%') OR (discount_product_id LIKE '%,476,%') OR (discount_product_id LIKE '%,477,%') OR (discount_product_id LIKE '%,478,%') OR (discount_product_id LIKE '%,479,%') OR (discount_product_id LIKE '%,480,%') OR (discount_product_id LIKE '%,481,%') OR (discount_product_id LIKE '%,494,%') OR (discount_product_id LIKE '%,495,%') OR (discount_product_id LIKE '%,496,%') OR (discount_product_id LIKE '%,497,%') OR (discount_product_id LIKE '%,498,%') OR (discount_product_id LIKE '%,499,%') OR (discount_product_id LIKE '%,500,%') OR (discount_product_id LIKE '%,501,%') OR (discount_product_id LIKE '%,502,%') OR (discount_product_id LIKE '%,503,%') ) 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 (12,29,55) AND a.price_currency_id IN (1,2) AND a.price_start_date < 1743194063 AND (a.price_end_date < 1 OR a.price_end_date > 1743194063) 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
233μ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 (12,29,55);
259μ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 (15) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left
670μs2.78KB/administrator/components/com_hikashop/classes/category.php:771CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743194063 AND (a.badge_end >= 1743194063 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 >= 231159802) 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
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 (16) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left
440μs2.78KB/administrator/components/com_hikashop/classes/category.php:771CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743194063 AND (a.badge_end >= 1743194063 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 >= 230664775) 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 = '16' OR badge_category_id LIKE '%,16,%')) 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 = '16' OR badge_category_id LIKE '%,16,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
172μ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 (13) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left
417μs2.78KB/administrator/components/com_hikashop/classes/category.php:771CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743194063 AND (a.badge_end >= 1743194063 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 >= 230040841) 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
366μ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
510μ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;
319μ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')
453μ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 = 12 ORDER BY pc.product_category_id ASC
179μ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
168μ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 = 12) AND (vote_ip = '18.191.246.216') AND (vote_user_id = '')
192μ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 = 29 ORDER BY pc.product_category_id ASC
189μ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 = 29 ORDER BY pc.product_category_id ASC
277μ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 = 29) AND (vote_ip = '18.191.246.216') AND (vote_user_id = '')
264μ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 = 55 ORDER BY pc.product_category_id ASC
180μ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 = 55 ORDER BY pc.product_category_id ASC
246μ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 = 55) AND (vote_ip = '18.191.246.216') AND (vote_user_id = '')
286μ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 = '8b1f738289ce13c79c2d37299f80552e') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
293μ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
436μs4.59KB/administrator/components/com_hikashop/classes/category.php:35CopySELECT * FROM ajr4k_hikashop_category WHERE category_id = '2' LIMIT 1
170μ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
346μ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 36, 3
639μs568B/components/com_hikashop/views/product/view.html.php:863CopySELECT b.* FROM ajr4k_hikashop_product AS b WHERE product_id IN ( 51,52,53 ) ORDER BY b.product_created ASC
315μs5.5KB/components/com_hikashop/views/product/view.html.php:870CopySELECT * FROM ajr4k_hikashop_file WHERE file_ref_id IN (51,52,53) AND file_type IN ('product','file') ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
258μs1.52KB/administrator/components/com_hikashop/classes/product.php:2401CopySELECT variant_product_id FROM ajr4k_hikashop_variant WHERE variant_product_id IN (51,52,53)
102μ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 (51,52,53)
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 ('51','52','53') AND product_published = 1 AND product_type = 'variant' AND product_sale_start < 1743194063 AND (product_sale_end > 1743194063 OR product_sale_end = 0)
289μ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 < 1743194063 AND (discount_end > 1743194063 OR discount_end = 0) AND ( (discount_product_id IN ('','0','51','52','53')) OR (discount_product_id LIKE '%,51,%') OR (discount_product_id LIKE '%,52,%') OR (discount_product_id LIKE '%,53,%') OR (discount_product_id LIKE '%,552,%') OR (discount_product_id LIKE '%,553,%') OR (discount_product_id LIKE '%,554,%') OR (discount_product_id LIKE '%,555,%') OR (discount_product_id LIKE '%,556,%') OR (discount_product_id LIKE '%,557,%') OR (discount_product_id LIKE '%,558,%') OR (discount_product_id LIKE '%,559,%') OR (discount_product_id LIKE '%,560,%') OR (discount_product_id LIKE '%,561,%') OR (discount_product_id LIKE '%,562,%') OR (discount_product_id LIKE '%,563,%') OR (discount_product_id LIKE '%,576,%') OR (discount_product_id LIKE '%,577,%') OR (discount_product_id LIKE '%,578,%') OR (discount_product_id LIKE '%,579,%') OR (discount_product_id LIKE '%,580,%') OR (discount_product_id LIKE '%,581,%') OR (discount_product_id LIKE '%,582,%') OR (discount_product_id LIKE '%,583,%') OR (discount_product_id LIKE '%,584,%') OR (discount_product_id LIKE '%,585,%') OR (discount_product_id LIKE '%,586,%') OR (discount_product_id LIKE '%,587,%') OR (discount_product_id LIKE '%,588,%') OR (discount_product_id LIKE '%,589,%') OR (discount_product_id LIKE '%,590,%') OR (discount_product_id LIKE '%,591,%') OR (discount_product_id LIKE '%,592,%') OR (discount_product_id LIKE '%,593,%') OR (discount_product_id LIKE '%,594,%') OR (discount_product_id LIKE '%,595,%') OR (discount_product_id LIKE '%,596,%') OR (discount_product_id LIKE '%,597,%') OR (discount_product_id LIKE '%,598,%') OR (discount_product_id LIKE '%,599,%') ) 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,%')
181μ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 (51,52,53) AND a.price_currency_id IN (1,2) AND a.price_start_date < 1743194063 AND (a.price_end_date < 1 OR a.price_end_date > 1743194063) 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
200μ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 (51,52,53);
193μ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 (14) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left
615μs2.78KB/administrator/components/com_hikashop/classes/category.php:771CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743194063 AND (a.badge_end >= 1743194063 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 >= 230042528) 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 = '14' OR badge_category_id LIKE '%,14,%')) 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 = '14' OR badge_category_id LIKE '%,14,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
179μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743194063 AND (a.badge_end >= 1743194063 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 >= 230042445) 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 = '14' OR badge_category_id LIKE '%,14,%')) 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 = '14' OR badge_category_id LIKE '%,14,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
137μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743194063 AND (a.badge_end >= 1743194063 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 >= 230042336) 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 = '14' OR badge_category_id LIKE '%,14,%')) 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 = '14' OR badge_category_id LIKE '%,14,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
149μ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
477μ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;
116μ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 = 51 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 = 51 ORDER BY pc.product_category_id ASC
287μ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 = 51) AND (vote_ip = '18.191.246.216') AND (vote_user_id = '')
465μ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 = 52 ORDER BY pc.product_category_id ASC
204μ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 = 52 ORDER BY pc.product_category_id ASC
393μ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 = 52) AND (vote_ip = '18.191.246.216') AND (vote_user_id = '')
176μ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 = 53 ORDER BY pc.product_category_id ASC
179μ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 = 53 ORDER BY pc.product_category_id ASC
180μ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 = 53) AND (vote_ip = '18.191.246.216') AND (vote_user_id = '')
169μ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 = '8b1f738289ce13c79c2d37299f80552e') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
334μ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
687μs4.59KB/administrator/components/com_hikashop/classes/category.php:35CopySELECT * FROM ajr4k_hikashop_category WHERE category_id = '2' LIMIT 1
200μ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
285μ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 36, 3
2.32ms21.5KB/components/com_hikashop/views/product/view.html.php:874CopySELECT * FROM ajr4k_hikashop_file WHERE file_ref_id IN (57,55,60) AND file_type IN ('product','file') ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
600μs1.58KB/administrator/components/com_hikashop/classes/product.php:2401CopySELECT variant_product_id FROM ajr4k_hikashop_variant WHERE variant_product_id IN (57,55,60)
470μ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 (57,55,60)
388μ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 ('57','55','60') AND product_published = 1 AND product_type = 'variant' AND product_sale_start < 1743194063 AND (product_sale_end > 1743194063 OR product_sale_end = 0)
676μs9.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 < 1743194063 AND (discount_end > 1743194063 OR discount_end = 0) AND ( (discount_product_id IN ('','0','57','55','60')) OR (discount_product_id LIKE '%,57,%') OR (discount_product_id LIKE '%,55,%') OR (discount_product_id LIKE '%,60,%') OR (discount_product_id LIKE '%,494,%') OR (discount_product_id LIKE '%,495,%') OR (discount_product_id LIKE '%,496,%') OR (discount_product_id LIKE '%,497,%') OR (discount_product_id LIKE '%,498,%') OR (discount_product_id LIKE '%,499,%') OR (discount_product_id LIKE '%,500,%') OR (discount_product_id LIKE '%,501,%') OR (discount_product_id LIKE '%,502,%') OR (discount_product_id LIKE '%,503,%') OR (discount_product_id LIKE '%,446,%') OR (discount_product_id LIKE '%,447,%') OR (discount_product_id LIKE '%,448,%') OR (discount_product_id LIKE '%,449,%') OR (discount_product_id LIKE '%,450,%') OR (discount_product_id LIKE '%,451,%') OR (discount_product_id LIKE '%,452,%') OR (discount_product_id LIKE '%,453,%') OR (discount_product_id LIKE '%,454,%') OR (discount_product_id LIKE '%,455,%') OR (discount_product_id LIKE '%,456,%') OR (discount_product_id LIKE '%,457,%') OR (discount_product_id LIKE '%,504,%') OR (discount_product_id LIKE '%,505,%') OR (discount_product_id LIKE '%,506,%') OR (discount_product_id LIKE '%,507,%') OR (discount_product_id LIKE '%,508,%') OR (discount_product_id LIKE '%,509,%') OR (discount_product_id LIKE '%,510,%') OR (discount_product_id LIKE '%,511,%') OR (discount_product_id LIKE '%,512,%') OR (discount_product_id LIKE '%,513,%') OR (discount_product_id LIKE '%,514,%') OR (discount_product_id LIKE '%,515,%') ) 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,%')
431μ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 (57,55,60) AND a.price_currency_id IN (1,2) AND a.price_start_date < 1743194063 AND (a.price_end_date < 1 OR a.price_end_date > 1743194063) 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
483μ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 (57,55,60);
525μ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 (12) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left
3.42ms2.78KB/administrator/components/com_hikashop/classes/category.php:771CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743194063 AND (a.badge_end >= 1743194063 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 >= 230040260) 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
269μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743194063 AND (a.badge_end >= 1743194063 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 >= 230036030) 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
170μ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
621μ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;
195μ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 = 57 ORDER BY pc.product_category_id ASC
321μ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 = 57 ORDER BY pc.product_category_id ASC
317μ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 = 57) AND (vote_ip = '18.191.246.216') AND (vote_user_id = '')
542μ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 = 55 ORDER BY pc.product_category_id ASC
232μ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 = 55 ORDER BY pc.product_category_id ASC
184μ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 = 55) AND (vote_ip = '18.191.246.216') AND (vote_user_id = '')
281μ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 = 60 ORDER BY pc.product_category_id ASC
192μ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 = 60 ORDER BY pc.product_category_id ASC
233μ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 = 60) AND (vote_ip = '18.191.246.216') AND (vote_user_id = '')
329μ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
392μ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
311μ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`
1.12ms18.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
16.84ms55.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`
3.49ms3.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)
594μ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
520μs2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
331μ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)
351μ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
420μs2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
271μ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`
1.03ms4.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
3.9ms55.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`
684μ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`
538μ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
4.04ms704B/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
454μ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
4.3ms704B/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
3.09ms704B/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
587μ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)
434μ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
907μs2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
301μ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.5ms39.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.5ms4.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
500μ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
371μ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
347μ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
301μ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)
389μ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
693μs2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
353μ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
986μ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`
567μ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
452μ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
357μ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
570μ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
327μ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
301μ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
352μ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
2.1ms39.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
445μ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
443μ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
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 = 9
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
351μ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
295μ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
299μ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
1.07ms39.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
363μ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
594μ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
310μ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
295μ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
267μ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
390μ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)
422μ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
448μs2.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 cart.cart_id FROM ajr4k_hikashop_cart AS cart WHERE (cart.cart_type = 'cart') AND (cart.session_id = '8b1f738289ce13c79c2d37299f80552e') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
289μ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
409μ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.97ms5.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
442μs1.52KB/administrator/components/com_hikashop/classes/product.php:2401CopySELECT variant_product_id FROM ajr4k_hikashop_variant WHERE variant_product_id IN (13,12)
191μ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)
115μ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 ('13','12') AND product_published = 1 AND product_type = 'variant' AND product_sale_start < 1743194063 AND (product_sale_end > 1743194063 OR product_sale_end = 0)
623μ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 < 1743194063 AND (discount_end > 1743194063 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,%')
324μ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 < 1743194063 AND (a.price_end_date < 1 OR a.price_end_date > 1743194063) 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
391μ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);
349μs3.02KB/administrator/components/com_hikashop/classes/product.php:2492CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743194063 AND (a.badge_end >= 1743194063 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 >= 231159802) 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 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
606μ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;
163μ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
464μ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
227μ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
207μ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
419μ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.08ms23.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
482μ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
3.39ms23.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
605μ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
622μ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)
381μ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
495μs2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
435μ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
282μs1.32KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466CopySELECT `session_id`
FROM `ajr4k_session`
WHERE `session_id` = ?
216μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyUPDATE `ajr4k_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
411μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy