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 afterRenderRawModule mod_articles_latest (Latest Footer ) (124.02KB) (24.26%) | 149.04ms |
1 x beforeRenderModule mod_hikashop (Best sellers) (1.65MB) (18.28%) | 112.32ms |
1 x afterInitialise (946.79KB) (15.58%) | 95.72ms |
1 x afterRoute (1.44MB) (4.91%) | 30.17ms |
1 x afterRenderRawModule mod_hikashop (Best sellers) (607.09KB) (4.14%) | 25.42ms |
1 x beforeRenderModule mod_footer (Footer) (124.91KB) (4.07%) | 25.02ms |
1 x afterRenderRawModule mod_hikashop (Related products) (464.46KB) (3.82%) | 23.47ms |
1 x afterRenderRawModule mod_hikashop (Product Banner) (245.68KB) (3.68%) | 22.60ms |
1 x afterRenderRawModule mod_hikashop (Latest products) (448.08KB) (3.49%) | 21.47ms |
1 x afterRenderRawModule mod_articles_category (Most Popular) (193.33KB) (2.86%) | 17.59ms |
1 x afterDispatch (54.09KB) (2.74%) | 16.83ms |
1 x afterRender (648.97KB) (1.87%) | 11.47ms |
1 x afterRenderRawModule mod_articles_category (Editor's Picks) (114.06KB) (1.48%) | 9.07ms |
1 x afterRenderRawModule mod_banners (Banner 4) (17.91KB) (0.97%) | 5.98ms |
1 x afterRenderRawModule mod_articles_category (Fashion) (75.8KB) (0.97%) | 5.96ms |
1 x afterRenderRawModule mod_articles_category (Celebrity) (112.73KB) (0.94%) | 5.80ms |
1 x afterRenderRawModule mod_articles_category (Beauty) (74.8KB) (0.92%) | 5.63ms |
1 x afterRenderRawModule mod_articles_category (Featured Article) (40.89KB) (0.67%) | 4.09ms |
1 x afterLoad (457.03KB) (0.46%) | 2.85ms |
1 x afterRenderRawModule mod_banners (Banner right) (32.63KB) (0.41%) | 2.51ms |
1 x afterRenderRawModule mod_articles_category (Lead Article) (28.79KB) (0.37%) | 2.29ms |
1 x afterRenderRawModule mod_menu (Menu Footer) (59.3KB) (0.36%) | 2.20ms |
1 x afterRenderRawModule mod_banners (Banner Top) (17.57KB) (0.34%) | 2.08ms |
1 x afterRenderRawModule mod_menu (Bonus pages) (122.63KB) (0.31%) | 1.92ms |
1 x afterRenderRawModule mod_banners (Banner) (17.57KB) (0.3%) | 1.85ms |
1 x afterRenderRawModule mod_banners (Banner 3) (17.57KB) (0.28%) | 1.73ms |
1 x afterRenderRawModule mod_banners (Banner 2) (17.57KB) (0.27%) | 1.66ms |
1 x afterRenderRawModule mod_footer (Footer) (4.93KB) (0.15%) | 899μs |
1 x beforeRenderComponent com_hikashop (19.32KB) (0.07%) | 435μs |
1 x afterRenderRawModule mod_custom (Social) (3.81KB) (0.07%) | 406μs |
1 x afterRenderRawModule mod_menu (Top Bar) (15.33KB) (0.06%) | 341μs |
1 x afterRenderComponent com_hikashop (83.94KB) (0.05%) | 333μs |
1 x afterRenderModule mod_custom (Social) (1.8KB) (0.03%) | 158μs |
1 x afterRenderModule mod_hikashop (Best sellers) (3.26KB) (0.02%) | 143μs |
1 x afterRenderModule mod_articles_category (Most Popular) (5.89KB) (0.02%) | 138μs |
1 x afterRenderModule mod_articles_category (Lead Article) (2.3KB) (0.02%) | 132μs |
1 x afterRenderModule mod_footer (Footer) (1.98KB) (0.02%) | 130μs |
1 x afterRenderModule mod_hikashop (Latest products) (2.25KB) (0.02%) | 129μs |
1 x afterRenderModule mod_articles_category (Featured Article) (1.7KB) (0.02%) | 129μs |
1 x afterRenderModule mod_articles_category (Editor's Picks) (1.7KB) (0.02%) | 126μs |
1 x afterRenderModule mod_articles_category (Fashion) (1.69KB) (0.02%) | 126μs |
1 x afterRenderModule mod_articles_category (Celebrity) (1.69KB) (0.02%) | 121μs |
1 x afterRenderModule mod_hikashop (Related products) (2.25KB) (0.02%) | 120μs |
1 x afterRenderModule mod_banners (Banner right) (1.81KB) (0.02%) | 118μs |
1 x afterRenderModule mod_hikashop (Product Banner) (1.92KB) (0.02%) | 117μs |
1 x beforeRenderModule mod_hikashop (Latest products) (15.48KB) (0.02%) | 110μs |
1 x afterRenderModule mod_articles_latest (Latest Footer ) (1.61KB) (0.02%) | 110μs |
1 x afterRenderModule mod_articles_category (Beauty) (4.19KB) (0.02%) | 106μs |
1 x afterRenderModule mod_menu (Menu Footer) (2.31KB) (0.02%) | 103μs |
1 x afterRenderModule mod_banners (Banner 4) (3.27KB) (0.02%) | 98μs |
1 x beforeRenderModule mod_menu (Menu Footer) (2.63KB) (0.01%) | 92μs |
1 x afterRenderModule mod_banners (Banner Top) (2.02KB) (0.01%) | 89μs |
1 x beforeRenderModule mod_articles_category (Lead Article) (2.07KB) (0.01%) | 83μs |
1 x beforeRenderModule mod_banners (Banner 3) (3.34KB) (0.01%) | 81μs |
1 x afterRenderModule mod_menu (Bonus pages) (1.64KB) (0.01%) | 79μs |
1 x afterRenderModule mod_banners (Banner 3) (2.02KB) (0.01%) | 75μs |
1 x beforeRenderModule mod_articles_category (Beauty) (776B) (0.01%) | 74μs |
1 x beforeRenderModule mod_articles_category (Editor's Picks) (7.4KB) (0.01%) | 73μs |
1 x afterRenderModule mod_banners (Banner 2) (2.02KB) (0.01%) | 73μs |
1 x beforeRenderModule mod_articles_latest (Latest Footer ) (840B) (0.01%) | 71μs |
1 x beforeRenderModule mod_articles_category (Fashion) (264B) (0.01%) | 70μs |
1 x beforeRenderModule mod_articles_category (Featured Article) (296B) (0.01%) | 70μs |
1 x beforeRenderModule mod_articles_category (Celebrity) (7.54KB) (0.01%) | 68μs |
1 x beforeRenderModule mod_menu (Bonus pages) (8B) (0.01%) | 67μs |
1 x afterRenderModule mod_banners (Banner) (2KB) (0.01%) | 66μs |
1 x beforeRenderModule mod_hikashop (Product Banner) (9.73KB) (0.01%) | 66μs |
1 x beforeRenderModule mod_banners (Banner 4) (1.37KB) (0.01%) | 65μs |
1 x beforeRenderModule mod_custom (Social) (2.26KB) (0.01%) | 65μs |
1 x beforeRenderModule mod_banners (Banner 2) (7.16KB) (0.01%) | 64μs |
1 x beforeRenderModule mod_hikashop (Related products) (536B) (0.01%) | 61μs |
1 x beforeRenderModule mod_banners (Banner) (7.18KB) (0.01%) | 61μs |
1 x beforeRenderModule mod_banners (Banner Top) (7.16KB) (0.01%) | 57μs |
1 x afterRenderModule mod_menu (Top Bar) (1.95KB) (0.01%) | 55μs |
1 x beforeRenderModule mod_menu (Top Bar) (1.24KB) (0.01%) | 45μs |
1 x beforeRenderModule mod_articles_category (Most Popular) (8.75KB) (0.01%) | 37μs |
1 x beforeRenderModule mod_banners (Banner right) (2KB) (0.01%) | 31μs |
1 x beforeRenderModule mod_articles_latest (Latest Footer ) (704B) (0%) | 15μs |
1 x beforeRenderModule mod_articles_category (Most Popular) (704B) (0%) | 13μs |
1 x beforeRenderModule mod_hikashop (Related products) (720B) (0%) | 12μs |
1 x beforeRenderModule mod_menu (Menu Footer) (720B) (0%) | 12μs |
1 x beforeRenderModule mod_footer (Footer) (704B) (0%) | 11μs |
1 x beforeRenderModule mod_hikashop (Latest products) (720B) (0%) | 11μs |
1 x beforeRenderModule mod_banners (Banner 4) (720B) (0%) | 10μs |
1 x beforeRenderModule mod_custom (Social) (704B) (0%) | 10μs |
1 x beforeRenderModule mod_articles_category (Featured Article) (720B) (0%) | 10μs |
1 x beforeRenderModule mod_articles_category (Editor's Picks) (720B) (0%) | 10μs |
1 x beforeRenderModule mod_banners (Banner 3) (720B) (0%) | 9μs |
1 x beforeRenderModule mod_banners (Banner 2) (720B) (0%) | 9μs |
1 x beforeRenderModule mod_articles_category (Beauty) (704B) (0%) | 9μs |
1 x beforeRenderModule mod_articles_category (Fashion) (704B) (0%) | 9μs |
1 x beforeRenderModule mod_banners (Banner Top) (720B) (0%) | 9μs |
1 x beforeRenderModule mod_hikashop (Best sellers) (720B) (0%) | 9μs |
1 x beforeRenderModule mod_articles_category (Celebrity) (704B) (0%) | 9μs |
1 x beforeRenderModule mod_hikashop (Product Banner) (720B) (0%) | 9μs |
1 x beforeRenderModule mod_articles_category (Lead Article) (704B) (0%) | 8μs |
1 x beforeRenderModule mod_banners (Banner right) (720B) (0%) | 7μs |
1 x beforeRenderModule mod_banners (Banner) (704B) (0%) | 7μs |
1 x beforeRenderModule mod_menu (Bonus pages) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_menu (Top Bar) (704B) (0%) | 5μs |
SELECT @@SESSION.sql_mode;
146μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `ajr4k_session`
WHERE `session_id` = ?
1.93ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `ajr4k_session`
WHERE `session_id` = :session_id LIMIT 1
652μs1.3KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `ajr4k_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
4.13ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ajr4k_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
15.1ms1.61KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `ajr4k_viewlevels`
2.08ms656B/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
3.79ms1.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`
11.08ms3.98KBParams/libraries/src/Plugin/PluginHelper.php:294CopyUPDATE ajr4k_extensions
SET enabled=1
WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'
3.91ms688B/plugins/system/jacontenttype/jacontenttype.php:76CopySELECT *
FROM `ajr4k_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
3.49ms1.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
2.14ms848B/libraries/src/Language/LanguageHelper.php:213CopySELECT * FROM ajr4k_hikashop_config
286μs40.63KB/administrator/components/com_hikashop/classes/config.php:16CopySET sql_mode=(SELECT REPLACE(REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''), 'STRICT_TRANS_TABLES', ''));
56μ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`
9.65ms52.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
8.52ms848B/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 = 429) LIMIT 1
539μ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')
10.55ms3.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 = '02484ff72e46d44c789a33af7660a231') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
3.98ms520B/administrator/components/com_hikashop/classes/cart.php:69CopySELECT * FROM ajr4k_hikashop_currency WHERE currency_id IN (2)
352μ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 = 54) ORDER BY product_category_id ASC LIMIT 1
903μs21.84KB/components/com_hikashop/views/product/view.html.php:1299CopyUPDATE ajr4k_hikashop_product SET product_hit = product_hit + 1, product_last_seen_date = 1743463674 WHERE product_id = 54
280μ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 = 54) AND (pr.product_related_type = 'options') AND (p.product_published = 1) AND ((p.product_sale_start = '' OR p.product_sale_start <= 1743463674)) AND ((p.product_sale_end = '' OR p.product_sale_end > 1743463674)) ORDER BY pr.product_related_ordering ASC, pr.product_related_id ASC
1.51ms5.41KB/components/com_hikashop/views/product/view.html.php:1341CopySELECT * FROM ajr4k_hikashop_product WHERE (product_parent_id IN (54)) AND (product_published = 1)
375μ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 (54,422,423,424,425,426,427,428,429,430,431,432,433) ORDER BY v.ordering ASC, c.characteristic_ordering ASC
880μs1.95KB/components/com_hikashop/views/product/view.html.php:1427CopySELECT * FROM ajr4k_hikashop_file WHERE file_ref_id IN (54,422,423,424,425,426,427,428,429,430,431,432,433) AND file_type IN ('product','file') ORDER BY file_ordering ASC, file_id ASC
290μs1.47KB/components/com_hikashop/views/product/view.html.php:1472CopySELECT currency_id FROM ajr4k_hikashop_currency WHERE currency_published=1 OR currency_id = 2
180μ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 < 1743463674) AND ((p.price_end_date < 1 OR p.price_end_date > 1743463674)) AND (p.price_product_id IN (54,422,423,424,425,426,427,428,429,430,431,432,433)) AND ((p.price_users = '' OR p.price_users LIKE '%,0,%')) ORDER BY p.price_site_id ASC, p.price_value DESC
482μ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 <= 1743463674 AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1743463674) ORDER BY b.taxation_id ASC
339μs2.38KB/administrator/components/com_hikashop/classes/currency.php:199CopySELECT * FROM ajr4k_hikashop_zone WHERE zone_id = 73
134μ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 < 1743463674) AND (discount_end > 1743463674 OR discount_end = 0) AND (discount_product_id IN ('','0','54','422','423','424','425','426','427','428','429','430','431','432','433') OR discount_product_id LIKE '%,54,%' OR discount_product_id LIKE '%,422,%' OR discount_product_id LIKE '%,423,%' OR discount_product_id LIKE '%,424,%' OR discount_product_id LIKE '%,425,%' OR discount_product_id LIKE '%,426,%' OR discount_product_id LIKE '%,427,%' OR discount_product_id LIKE '%,428,%' OR discount_product_id LIKE '%,429,%' OR discount_product_id LIKE '%,430,%' OR discount_product_id LIKE '%,431,%' OR discount_product_id LIKE '%,432,%' OR discount_product_id LIKE '%,433,%') 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,%'))
210μs3.08KB/administrator/components/com_hikashop/classes/currency.php:1709CopySELECT category_id FROM ajr4k_hikashop_product_category WHERE product_id IN (54) ORDER BY ordering ASC
131μ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 (13) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left
493μ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 '%,13,%'))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 '%,13,%'))) AND field_products="") OR (field_products LIKE '%,54,%')) ORDER BY a.`field_ordering` ASC
201μs5.23KB/administrator/components/com_hikashop/classes/field.php:167CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743463674 AND (a.badge_end >= 1743463674 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 >= 230132492) 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
194μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743463674 AND (a.badge_end >= 1743463674 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 >= 230132534) 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
202μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743463674 AND (a.badge_end >= 1743463674 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 >= 230132529) 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
203μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743463674 AND (a.badge_end >= 1743463674 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 >= 230132523) 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
199μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743463674 AND (a.badge_end >= 1743463674 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 >= 230132515) 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
190μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743463674 AND (a.badge_end >= 1743463674 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 >= 230132510) 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
188μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743463674 AND (a.badge_end >= 1743463674 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 >= 230132503) 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
186μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743463674 AND (a.badge_end >= 1743463674 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 >= 230132498) 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
184μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743463674 AND (a.badge_end >= 1743463674 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 >= 230132487) 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
185μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743463674 AND (a.badge_end >= 1743463674 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 >= 230132482) 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
178μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743463674 AND (a.badge_end >= 1743463674 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 >= 230132477) 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
196μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743463674 AND (a.badge_end >= 1743463674 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 >= 230132472) 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
188μ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 = 54 ORDER BY a.product_category_id ASC
239μ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')
4.62ms552B/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
203μ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 (422,423,424,425,426,427,428,429,430,431,432,433) 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'
245μs2.53KB/administrator/components/com_hikashop/classes/plugins.php:113CopySELECT product_average_score, product_total_vote FROM ajr4k_hikashop_product WHERE product_id = 54
139μ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 = 54) AND (vote_ip = '18.191.122.218') AND (vote_user_id = '')
168μ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 = 54 AND vote_comment != ''
172μ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 = 54 AND vote_comment != '' ORDER BY `vote_date` ASC LIMIT 0,5
276μs21.23KB/components/com_hikashop/views/vote/view.html.php:115CopySELECT product_id FROM ajr4k_hikashop_product WHERE product_parent_id = 54
160μs712B/components/com_hikashop/views/vote/view.html.php:120CopySELECT * FROM ajr4k_hikashop_product WHERE product_id = '54' LIMIT 1
302μs5.47KB/administrator/components/com_hikashop/helpers/helper.php:2492CopySELECT product_average_score, product_total_vote FROM ajr4k_hikashop_product WHERE product_id = 54
132μ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 = 54) AND (vote_ip = '18.191.122.218') AND (vote_user_id = '')
190μs1.45KB/administrator/components/com_hikashop/classes/vote.php:688CopySELECT * FROM ajr4k_extensions WHERE folder='system' AND element='hikashopsocial' AND type='plugin'
327μs2.53KB/administrator/components/com_hikashop/classes/plugins.php:113CopySELECT * FROM ajr4k_extensions WHERE folder='content' AND element='hikashopsocial' AND type='plugin'
213μ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)
13.18ms3.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 = '02484ff72e46d44c789a33af7660a231') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
472μ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
491μs4.59KB/administrator/components/com_hikashop/classes/category.php:35CopySELECT * FROM ajr4k_hikashop_category WHERE category_id = '2' LIMIT 1
220μ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
391μ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 3
1.17ms568B/components/com_hikashop/views/product/view.html.php:863CopySELECT b.* FROM ajr4k_hikashop_product AS b WHERE product_id IN ( 3,7,56 ) ORDER BY b.product_sales DESC
491μs21.5KB/components/com_hikashop/views/product/view.html.php:870CopySELECT * FROM ajr4k_hikashop_file WHERE file_ref_id IN (3,7,56) AND file_type IN ('product','file') ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
366μs1.58KB/administrator/components/com_hikashop/classes/product.php:2401CopySELECT variant_product_id FROM ajr4k_hikashop_variant WHERE variant_product_id IN (3,7,56)
141μs712B/administrator/components/com_hikashop/classes/product.php:2425CopySELECT product_id FROM ajr4k_hikashop_product_related WHERE product_related_type = 'options' AND product_id IN (3,7,56)
71μs520B/administrator/components/com_hikashop/classes/product.php:2441CopySELECT product_parent_id, product_id, product_tax_id FROM ajr4k_hikashop_product WHERE product_parent_id IN ('3','7','56') AND product_published = 1 AND product_type = 'variant' AND product_sale_start < 1743463674 AND (product_sale_end > 1743463674 OR product_sale_end = 0)
469μ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 < 1743463674 AND (discount_end > 1743463674 OR discount_end = 0) AND ( (discount_product_id IN ('','0','3','7','56')) OR (discount_product_id LIKE '%,3,%') OR (discount_product_id LIKE '%,7,%') OR (discount_product_id LIKE '%,56,%') OR (discount_product_id LIKE '%,182,%') OR (discount_product_id LIKE '%,183,%') OR (discount_product_id LIKE '%,184,%') OR (discount_product_id LIKE '%,185,%') OR (discount_product_id LIKE '%,186,%') OR (discount_product_id LIKE '%,187,%') OR (discount_product_id LIKE '%,188,%') OR (discount_product_id LIKE '%,189,%') OR (discount_product_id LIKE '%,190,%') OR (discount_product_id LIKE '%,191,%') OR (discount_product_id LIKE '%,192,%') OR (discount_product_id LIKE '%,193,%') OR (discount_product_id LIKE '%,254,%') OR (discount_product_id LIKE '%,255,%') OR (discount_product_id LIKE '%,256,%') OR (discount_product_id LIKE '%,257,%') OR (discount_product_id LIKE '%,258,%') OR (discount_product_id LIKE '%,259,%') OR (discount_product_id LIKE '%,260,%') OR (discount_product_id LIKE '%,261,%') OR (discount_product_id LIKE '%,262,%') OR (discount_product_id LIKE '%,263,%') OR (discount_product_id LIKE '%,264,%') OR (discount_product_id LIKE '%,265,%') OR (discount_product_id LIKE '%,434,%') OR (discount_product_id LIKE '%,435,%') OR (discount_product_id LIKE '%,436,%') OR (discount_product_id LIKE '%,437,%') OR (discount_product_id LIKE '%,438,%') OR (discount_product_id LIKE '%,439,%') OR (discount_product_id LIKE '%,440,%') OR (discount_product_id LIKE '%,441,%') OR (discount_product_id LIKE '%,442,%') OR (discount_product_id LIKE '%,443,%') OR (discount_product_id LIKE '%,444,%') OR (discount_product_id LIKE '%,445,%') ) AND (discount_flat_amount != 0 OR discount_percent_amount != 0) AND (discount_flat_amount = 0 OR discount_currency_id =2) AND (discount_user_id = '' OR discount_user_id LIKE '%,0,%')
253μs3.08KB/administrator/components/com_hikashop/classes/currency.php:558CopySELECT a.*, CASE WHEN price_site_id = 0 OR price_site_id = '[unselected]' THEN '' ELSE price_site_id END AS price_site_id FROM ajr4k_hikashop_price AS a WHERE a.price_product_id IN (3,7,56) AND a.price_currency_id IN (1,2) AND a.price_start_date < 1743463674 AND (a.price_end_date < 1 OR a.price_end_date > 1743463674) 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
320μs1.47KB/administrator/components/com_hikashop/classes/currency.php:589CopySELECT c.*, pc.* FROM ajr4k_hikashop_category AS c LEFT JOIN ajr4k_hikashop_product_category AS pc ON c.category_id = pc.category_id WHERE pc.product_id IN (3,7,56);
259μs3.03KB/administrator/components/com_hikashop/classes/product.php:2492CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743463674 AND (a.badge_end >= 1743463674 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 >= 231431013) 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
227μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT hk_parent.* FROM ajr4k_hikashop_category AS hk_cat LEFT JOIN ajr4k_hikashop_category AS hk_parent ON (hk_parent.category_left <= hk_cat.category_left AND hk_parent.category_right >= hk_cat.category_right) WHERE hk_cat.category_id IN (12) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left
693μs2.78KB/administrator/components/com_hikashop/classes/category.php:771CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743463674 AND (a.badge_end >= 1743463674 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 >= 231430273) 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
341μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743463674 AND (a.badge_end >= 1743463674 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 >= 230309931) 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
601μ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
710μ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;
382μ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')
470μs16.81KB/administrator/components/com_hikashop/helpers/helper.php:1075CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 3 ORDER BY pc.product_category_id ASC
150μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 3 ORDER BY pc.product_category_id ASC
188μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT * FROM ajr4k_hikashop_vote WHERE (vote_type = 'product') AND (vote_rating != 0) AND (vote_ref_id = 3) AND (vote_ip = '18.191.122.218') AND (vote_user_id = '')
157μs1.45KB/administrator/components/com_hikashop/classes/vote.php:688CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 7 ORDER BY pc.product_category_id ASC
124μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 7 ORDER BY pc.product_category_id ASC
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 = 7) AND (vote_ip = '18.191.122.218') AND (vote_user_id = '')
123μs1.45KB/administrator/components/com_hikashop/classes/vote.php:688CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 56 ORDER BY pc.product_category_id ASC
117μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 56 ORDER BY pc.product_category_id ASC
152μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT * FROM ajr4k_hikashop_vote WHERE (vote_type = 'product') AND (vote_rating != 0) AND (vote_ref_id = 56) AND (vote_ip = '18.191.122.218') AND (vote_user_id = '')
125μ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 = '02484ff72e46d44c789a33af7660a231') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
176μ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
238μs4.59KB/administrator/components/com_hikashop/classes/category.php:35CopySELECT * FROM ajr4k_hikashop_category WHERE category_id = '2' LIMIT 1
117μ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
159μs2.83KB/administrator/components/com_hikashop/classes/category.php:612CopySELECT DISTINCT b.product_id FROM ajr4k_hikashop_product_category AS a LEFT JOIN ajr4k_hikashop_product AS b ON a.product_id=b.product_id WHERE (b.product_published = 1) AND (b.product_type = 'main') AND (a.category_id IN (12,13,14,15,16,18,2)) ORDER BY b.product_created ASC LIMIT 3
446μs568B/components/com_hikashop/views/product/view.html.php:863CopySELECT b.* FROM ajr4k_hikashop_product AS b WHERE product_id IN ( 1,2,3 ) ORDER BY b.product_created ASC
230μs5.5KB/components/com_hikashop/views/product/view.html.php:870CopySELECT * FROM ajr4k_hikashop_file WHERE file_ref_id IN (1,2,3) AND file_type IN ('product','file') ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
230μs1.58KB/administrator/components/com_hikashop/classes/product.php:2401CopySELECT variant_product_id FROM ajr4k_hikashop_variant WHERE variant_product_id IN (1,2,3)
100μs712B/administrator/components/com_hikashop/classes/product.php:2425CopySELECT product_id FROM ajr4k_hikashop_product_related WHERE product_related_type = 'options' AND product_id IN (1,2,3)
54μs520B/administrator/components/com_hikashop/classes/product.php:2441CopySELECT product_parent_id, product_id, product_tax_id FROM ajr4k_hikashop_product WHERE product_parent_id IN ('1','2','3') AND product_published = 1 AND product_type = 'variant' AND product_sale_start < 1743463674 AND (product_sale_end > 1743463674 OR product_sale_end = 0)
263μ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 < 1743463674 AND (discount_end > 1743463674 OR discount_end = 0) AND ( (discount_product_id IN ('','0','1','2','3')) OR (discount_product_id LIKE '%,1,%') OR (discount_product_id LIKE '%,2,%') OR (discount_product_id LIKE '%,3,%') OR (discount_product_id LIKE '%,64,%') OR (discount_product_id LIKE '%,66,%') OR (discount_product_id LIKE '%,63,%') OR (discount_product_id LIKE '%,61,%') OR (discount_product_id LIKE '%,65,%') OR (discount_product_id LIKE '%,67,%') OR (discount_product_id LIKE '%,68,%') OR (discount_product_id LIKE '%,69,%') OR (discount_product_id LIKE '%,70,%') OR (discount_product_id LIKE '%,71,%') OR (discount_product_id LIKE '%,72,%') OR (discount_product_id LIKE '%,73,%') OR (discount_product_id LIKE '%,122,%') OR (discount_product_id LIKE '%,123,%') OR (discount_product_id LIKE '%,124,%') OR (discount_product_id LIKE '%,125,%') OR (discount_product_id LIKE '%,126,%') OR (discount_product_id LIKE '%,127,%') OR (discount_product_id LIKE '%,128,%') OR (discount_product_id LIKE '%,129,%') OR (discount_product_id LIKE '%,130,%') OR (discount_product_id LIKE '%,131,%') OR (discount_product_id LIKE '%,132,%') OR (discount_product_id LIKE '%,133,%') OR (discount_product_id LIKE '%,182,%') OR (discount_product_id LIKE '%,183,%') OR (discount_product_id LIKE '%,184,%') OR (discount_product_id LIKE '%,185,%') OR (discount_product_id LIKE '%,186,%') OR (discount_product_id LIKE '%,187,%') OR (discount_product_id LIKE '%,188,%') OR (discount_product_id LIKE '%,189,%') OR (discount_product_id LIKE '%,190,%') OR (discount_product_id LIKE '%,191,%') OR (discount_product_id LIKE '%,192,%') OR (discount_product_id LIKE '%,193,%') ) AND (discount_flat_amount != 0 OR discount_percent_amount != 0) AND (discount_flat_amount = 0 OR discount_currency_id =2) AND (discount_user_id = '' OR discount_user_id LIKE '%,0,%')
179μs3.08KB/administrator/components/com_hikashop/classes/currency.php:558CopySELECT a.*, CASE WHEN price_site_id = 0 OR price_site_id = '[unselected]' THEN '' ELSE price_site_id END AS price_site_id FROM ajr4k_hikashop_price AS a WHERE a.price_product_id IN (1,2,3) AND a.price_currency_id IN (1,2) AND a.price_start_date < 1743463674 AND (a.price_end_date < 1 OR a.price_end_date > 1743463674) 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
369μs1.45KB/administrator/components/com_hikashop/classes/currency.php:589CopySELECT * FROM ajr4k_hikashop_price WHERE price_product_id IN (64,66,63,61,65,67,68,69,70,71,72,73) AND price_currency_id IN (1,2) AND price_start_date < 1743463674 AND (price_end_date < 1 OR price_end_date > 1743463674) AND (price_access = 'all' OR price_access LIKE '%,9,%' OR ISNULL(price_access)) AND (price_users = '' OR price_users LIKE '%,0,%')
264μs1.33KB/administrator/components/com_hikashop/classes/currency.php:770CopySELECT c.*, pc.* FROM ajr4k_hikashop_category AS c LEFT JOIN ajr4k_hikashop_product_category AS pc ON c.category_id = pc.category_id WHERE pc.product_id IN (1,2,3);
445μs3.03KB/administrator/components/com_hikashop/classes/product.php:2492CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743463674 AND (a.badge_end >= 1743463674 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 >= 231431208) 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
300μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743463674 AND (a.badge_end >= 1743463674 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 >= 231431022) 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
424μ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
473μ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;
158μs1.27KB/components/com_hikashop/views/product/view.html.php:1151CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 1 ORDER BY pc.product_category_id ASC
194μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 1 ORDER BY pc.product_category_id ASC
167μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT * FROM ajr4k_hikashop_vote WHERE (vote_type = 'product') AND (vote_rating != 0) AND (vote_ref_id = 1) AND (vote_ip = '18.191.122.218') AND (vote_user_id = '')
205μs1.45KB/administrator/components/com_hikashop/classes/vote.php:688CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 2 ORDER BY pc.product_category_id ASC
176μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 2 ORDER BY pc.product_category_id ASC
264μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT * FROM ajr4k_hikashop_vote WHERE (vote_type = 'product') AND (vote_rating != 0) AND (vote_ref_id = 2) AND (vote_ip = '18.191.122.218') AND (vote_user_id = '')
258μs1.45KB/administrator/components/com_hikashop/classes/vote.php:688CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 3 ORDER BY pc.product_category_id ASC
145μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 3 ORDER BY pc.product_category_id ASC
113μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT * FROM ajr4k_hikashop_vote WHERE (vote_type = 'product') AND (vote_rating != 0) AND (vote_ref_id = 3) AND (vote_ip = '18.191.122.218') AND (vote_user_id = '')
141μ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 = '02484ff72e46d44c789a33af7660a231') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
262μ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
342μs4.59KB/administrator/components/com_hikashop/classes/category.php:35CopySELECT * FROM ajr4k_hikashop_category WHERE category_id = '2' LIMIT 1
122μ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
157μs2.83KB/administrator/components/com_hikashop/classes/category.php:612CopySELECT DISTINCT b.* FROM ajr4k_hikashop_product_category AS a LEFT JOIN ajr4k_hikashop_product AS b ON a.product_id=b.product_id WHERE (b.product_published = 1) AND (b.product_type = 'main') AND (a.category_id IN (12,13,14,15,16,18,2)) ORDER BY a.ordering ASC LIMIT 3
1.95ms5.5KB/components/com_hikashop/views/product/view.html.php:874CopySELECT * FROM ajr4k_hikashop_file WHERE file_ref_id IN (1,10,15) AND file_type IN ('product','file') ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
267μs1.55KB/administrator/components/com_hikashop/classes/product.php:2401CopySELECT variant_product_id FROM ajr4k_hikashop_variant WHERE variant_product_id IN (1,10,15)
115μs712B/administrator/components/com_hikashop/classes/product.php:2425CopySELECT product_id FROM ajr4k_hikashop_product_related WHERE product_related_type = 'options' AND product_id IN (1,10,15)
61μs520B/administrator/components/com_hikashop/classes/product.php:2441CopySELECT product_parent_id, product_id, product_tax_id FROM ajr4k_hikashop_product WHERE product_parent_id IN ('1','10','15') AND product_published = 1 AND product_type = 'variant' AND product_sale_start < 1743463674 AND (product_sale_end > 1743463674 OR product_sale_end = 0)
295μ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 < 1743463674 AND (discount_end > 1743463674 OR discount_end = 0) AND ( (discount_product_id IN ('','0','1','10','15')) OR (discount_product_id LIKE '%,1,%') OR (discount_product_id LIKE '%,10,%') OR (discount_product_id LIKE '%,15,%') OR (discount_product_id LIKE '%,64,%') OR (discount_product_id LIKE '%,66,%') OR (discount_product_id LIKE '%,63,%') OR (discount_product_id LIKE '%,61,%') OR (discount_product_id LIKE '%,65,%') OR (discount_product_id LIKE '%,67,%') OR (discount_product_id LIKE '%,68,%') OR (discount_product_id LIKE '%,69,%') OR (discount_product_id LIKE '%,70,%') OR (discount_product_id LIKE '%,71,%') OR (discount_product_id LIKE '%,72,%') OR (discount_product_id LIKE '%,73,%') OR (discount_product_id LIKE '%,74,%') OR (discount_product_id LIKE '%,75,%') OR (discount_product_id LIKE '%,76,%') OR (discount_product_id LIKE '%,77,%') OR (discount_product_id LIKE '%,78,%') OR (discount_product_id LIKE '%,79,%') OR (discount_product_id LIKE '%,80,%') OR (discount_product_id LIKE '%,81,%') OR (discount_product_id LIKE '%,82,%') OR (discount_product_id LIKE '%,83,%') OR (discount_product_id LIKE '%,84,%') OR (discount_product_id LIKE '%,85,%') OR (discount_product_id LIKE '%,86,%') OR (discount_product_id LIKE '%,87,%') OR (discount_product_id LIKE '%,88,%') OR (discount_product_id LIKE '%,89,%') OR (discount_product_id LIKE '%,90,%') OR (discount_product_id LIKE '%,91,%') OR (discount_product_id LIKE '%,92,%') OR (discount_product_id LIKE '%,93,%') OR (discount_product_id LIKE '%,94,%') OR (discount_product_id LIKE '%,95,%') OR (discount_product_id LIKE '%,96,%') OR (discount_product_id LIKE '%,97,%') ) AND (discount_flat_amount != 0 OR discount_percent_amount != 0) AND (discount_flat_amount = 0 OR discount_currency_id =2) AND (discount_user_id = '' OR discount_user_id LIKE '%,0,%')
223μs3.08KB/administrator/components/com_hikashop/classes/currency.php:558CopySELECT a.*, CASE WHEN price_site_id = 0 OR price_site_id = '[unselected]' THEN '' ELSE price_site_id END AS price_site_id FROM ajr4k_hikashop_price AS a WHERE a.price_product_id IN (1,10,15) AND a.price_currency_id IN (1,2) AND a.price_start_date < 1743463674 AND (a.price_end_date < 1 OR a.price_end_date > 1743463674) 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
210μs1.45KB/administrator/components/com_hikashop/classes/currency.php:589CopySELECT * FROM ajr4k_hikashop_price WHERE price_product_id IN (64,66,63,61,65,67,68,69,70,71,72,73) AND price_currency_id IN (1,2) AND price_start_date < 1743463674 AND (price_end_date < 1 OR price_end_date > 1743463674) AND (price_access = 'all' OR price_access LIKE '%,9,%' OR ISNULL(price_access)) AND (price_users = '' OR price_users LIKE '%,0,%')
163μs9.33KB/administrator/components/com_hikashop/classes/currency.php:770CopySELECT c.*, pc.* FROM ajr4k_hikashop_category AS c LEFT JOIN ajr4k_hikashop_product_category AS pc ON c.category_id = pc.category_id WHERE pc.product_id IN (1,10,15);
220μs3.03KB/administrator/components/com_hikashop/classes/product.php:2492CopySELECT hk_parent.* FROM ajr4k_hikashop_category AS hk_cat LEFT JOIN ajr4k_hikashop_category AS hk_parent ON (hk_parent.category_left <= hk_cat.category_left AND hk_parent.category_right >= hk_cat.category_right) WHERE hk_cat.category_id IN (18) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left
427μs2.78KB/administrator/components/com_hikashop/classes/category.php:771CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743463674 AND (a.badge_end >= 1743463674 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 >= 231429413) 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
208μ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
440μ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;
139μs1.27KB/components/com_hikashop/views/product/view.html.php:1151CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 1 ORDER BY pc.product_category_id ASC
224μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 1 ORDER BY pc.product_category_id ASC
165μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT * FROM ajr4k_hikashop_vote WHERE (vote_type = 'product') AND (vote_rating != 0) AND (vote_ref_id = 1) AND (vote_ip = '18.191.122.218') AND (vote_user_id = '')
532μs1.45KB/administrator/components/com_hikashop/classes/vote.php:688CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 10 ORDER BY pc.product_category_id ASC
181μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 10 ORDER BY pc.product_category_id ASC
3.15ms536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT * FROM ajr4k_hikashop_vote WHERE (vote_type = 'product') AND (vote_rating != 0) AND (vote_ref_id = 10) AND (vote_ip = '18.191.122.218') AND (vote_user_id = '')
156μs1.45KB/administrator/components/com_hikashop/classes/vote.php:688CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15 ORDER BY pc.product_category_id ASC
148μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 15 ORDER BY pc.product_category_id ASC
142μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT * FROM ajr4k_hikashop_vote WHERE (vote_type = 'product') AND (vote_rating != 0) AND (vote_ref_id = 15) AND (vote_ip = '18.191.122.218') AND (vote_user_id = '')
155μ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
236μ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
1.8ms1.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`
21.38ms18.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
132ms55.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`
1.53ms3.98KBParams/libraries/src/Categories/Categories.php:375CopySELECT *
FROM `ajr4k_banners`
WHERE
(`reset` <= :date AND `reset` IS NOT NULL) AND
(`checked_out` IS NULL OR `checked_out` = :userId)
1.22ms5.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
1.59ms2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
514μ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)
413μ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
617μs2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
212μ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`
1ms4.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
2.38ms55.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`
426μ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`
498μ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.54ms704B/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
405μ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
234μ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
248μ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
188μ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)
263μ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
343μs2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
131μ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
2.27ms39.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
977μs4.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
469μ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
271μ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
266μ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
171μ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)
396μ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
256μs2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
156μs856BParams/components/com_banners/src/Model/BannersModel.php:315CopySELECT `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
933μ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`
391μ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
225μ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
177μ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
162μ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
169μ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
158μ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
398μs704B/templates/ja_allure/helper.php:41CopySELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,`fp`.`ordering`
FROM `ajr4k_content` AS `a`
LEFT JOIN `ajr4k_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `ajr4k_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `ajr4k_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `ajr4k_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `ajr4k_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5) AND `a`.`created_by_alias` IN (:preparedArray6) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray7,:preparedArray8)
ORDER BY fp.ordering ASC LIMIT 3
1.24ms39.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
279μ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
215μ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
154μ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
190μ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
161μ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
248μ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
504μs39.11KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 11
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
209μs704B/templates/ja_allure/helper.php:41CopySELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
FROM ajr4k_fields_values fv
LEFT JOIN ajr4k_fields f ON fv.field_id = f.id
LEFT JOIN ajr4k_fields_groups fg ON fg.id = f.group_id
WHERE fv.item_id = 11
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
190μ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
211μ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
201μ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
159μ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
1.05ms704B/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)
226μ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
369μs2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
136μ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 = '02484ff72e46d44c789a33af7660a231') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
148μ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
284μ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.14ms5.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
236μs1.52KB/administrator/components/com_hikashop/classes/product.php:2401CopySELECT variant_product_id FROM ajr4k_hikashop_variant WHERE variant_product_id IN (13,12)
96μ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)
58μ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 < 1743463674 AND (product_sale_end > 1743463674 OR product_sale_end = 0)
550μ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 < 1743463674 AND (discount_end > 1743463674 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,%')
235μ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 < 1743463674 AND (a.price_end_date < 1 OR a.price_end_date > 1743463674) 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
628μ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);
457μs3.02KB/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
702μs2.78KB/administrator/components/com_hikashop/classes/category.php:771CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743463674 AND (a.badge_end >= 1743463674 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 >= 231429413) 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
274μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743463674 AND (a.badge_end >= 1743463674 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 >= 231429413) 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
177μ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
366μ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;
121μ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
137μ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
145μ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
206μ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
102μ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
560μs23.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
362μs704B/templates/ja_allure/helper.php:41CopySELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,`fp`.`ordering`
FROM `ajr4k_content` AS `a`
LEFT JOIN `ajr4k_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `ajr4k_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `ajr4k_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `ajr4k_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `ajr4k_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10) AND `a`.`created_by_alias` IN (:preparedArray11) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray12,:preparedArray13)
ORDER BY a.title ASC LIMIT 2
1.7ms23.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
248μ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
229μ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)
327μ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
388μs2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
213μs856BParams/components/com_banners/src/Model/BannersModel.php:315CopySELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count
FROM `ajr4k_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
1.14ms1.32KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466CopySELECT `session_id`
FROM `ajr4k_session`
WHERE `session_id` = ?
140μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyUPDATE `ajr4k_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
1.16ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy