Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem.
Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis...
Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis...
Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis...
Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis...
Joomla! Version | 4.4.9 |
PHP Version | 8.2.24 |
Identity | guest |
Response | 200 |
Template | ja_allure |
Database |
|
1 x beforeRenderModule mod_hikashop (Best sellers) (1.65MB) (22.41%) | 66.31ms |
1 x afterInitialise (946.87KB) (10.54%) | 31.19ms |
1 x afterRenderRawModule mod_hikashop (Best sellers) (627.05KB) (8.54%) | 25.28ms |
1 x afterRenderRawModule mod_hikashop (Latest products) (468.75KB) (5.87%) | 17.37ms |
1 x afterRenderRawModule mod_hikashop (Related products) (444.72KB) (5.82%) | 17.22ms |
1 x afterRenderRawModule mod_articles_latest (Latest Footer ) (60.02KB) (5.09%) | 15.05ms |
1 x afterRoute (1.44MB) (5.06%) | 14.99ms |
1 x afterRenderRawModule mod_articles_category (Most Popular) (193.33KB) (4.91%) | 14.53ms |
1 x afterRender (648.97KB) (4.76%) | 14.08ms |
1 x afterRenderRawModule mod_hikashop (Product Banner) (240.18KB) (3.6%) | 10.66ms |
1 x afterRenderRawModule mod_articles_category (Editor's Picks) (114.06KB) (2.58%) | 7.63ms |
1 x afterRenderRawModule mod_articles_category (Celebrity) (112.73KB) (1.96%) | 5.80ms |
1 x afterRenderRawModule mod_banners (Banner 4) (17.91KB) (1.87%) | 5.52ms |
1 x afterRenderRawModule mod_articles_category (Beauty) (74.8KB) (1.79%) | 5.30ms |
1 x beforeRenderModule mod_footer (Footer) (124.91KB) (1.65%) | 4.89ms |
1 x afterRenderRawModule mod_articles_category (Featured Article) (40.89KB) (1.63%) | 4.83ms |
1 x afterRenderRawModule mod_articles_category (Fashion) (81.3KB) (1.51%) | 4.48ms |
1 x afterLoad (457.09KB) (1.37%) | 4.04ms |
1 x afterDispatch (54.09KB) (1.16%) | 3.44ms |
1 x afterRenderRawModule mod_menu (Bonus pages) (186.63KB) (0.92%) | 2.72ms |
1 x afterRenderRawModule mod_articles_category (Lead Article) (28.79KB) (0.77%) | 2.29ms |
1 x afterRenderRawModule mod_banners (Banner Top) (17.57KB) (0.61%) | 1.81ms |
1 x afterRenderRawModule mod_banners (Banner) (17.57KB) (0.61%) | 1.81ms |
1 x afterRenderRawModule mod_banners (Banner 2) (17.57KB) (0.58%) | 1.73ms |
1 x afterRenderRawModule mod_banners (Banner 3) (17.57KB) (0.55%) | 1.63ms |
1 x afterRenderRawModule mod_banners (Banner right) (32.63KB) (0.53%) | 1.56ms |
1 x afterRenderRawModule mod_menu (Menu Footer) (59.3KB) (0.46%) | 1.35ms |
1 x afterRenderRawModule mod_footer (Footer) (4.93KB) (0.23%) | 667μs |
1 x beforeRenderComponent com_hikashop (19.32KB) (0.2%) | 605μs |
1 x afterRenderRawModule mod_menu (Top Bar) (15.33KB) (0.17%) | 504μs |
1 x afterRenderRawModule mod_custom (Social) (3.81KB) (0.12%) | 354μs |
1 x afterRenderComponent com_hikashop (83.94KB) (0.09%) | 271μs |
1 x afterRenderModule mod_hikashop (Best sellers) (3.26KB) (0.06%) | 175μs |
1 x afterRenderModule mod_articles_category (Celebrity) (1.69KB) (0.06%) | 166μs |
1 x afterRenderModule mod_menu (Bonus pages) (1.64KB) (0.05%) | 148μs |
1 x afterRenderModule mod_hikashop (Product Banner) (1.92KB) (0.05%) | 146μs |
1 x afterRenderModule mod_articles_category (Featured Article) (1.7KB) (0.05%) | 145μs |
1 x afterRenderModule mod_custom (Social) (1.8KB) (0.05%) | 140μs |
1 x afterRenderModule mod_articles_category (Most Popular) (5.89KB) (0.05%) | 139μs |
1 x afterRenderModule mod_articles_category (Fashion) (1.69KB) (0.04%) | 129μs |
1 x beforeRenderModule mod_hikashop (Latest products) (15.48KB) (0.04%) | 126μs |
1 x afterRenderModule mod_articles_category (Beauty) (4.19KB) (0.04%) | 126μs |
1 x afterRenderModule mod_articles_category (Lead Article) (2.3KB) (0.04%) | 125μs |
1 x afterRenderModule mod_articles_latest (Latest Footer ) (1.61KB) (0.04%) | 123μs |
1 x afterRenderModule mod_banners (Banner 4) (3.27KB) (0.04%) | 123μs |
1 x afterRenderModule mod_articles_category (Editor's Picks) (1.7KB) (0.04%) | 118μs |
1 x afterRenderModule mod_banners (Banner right) (1.81KB) (0.04%) | 104μs |
1 x afterRenderModule mod_hikashop (Latest products) (2.25KB) (0.03%) | 103μs |
1 x afterRenderModule mod_menu (Top Bar) (1.95KB) (0.03%) | 102μs |
1 x afterRenderModule mod_banners (Banner Top) (2.02KB) (0.03%) | 100μs |
1 x beforeRenderModule mod_articles_category (Editor's Picks) (7.4KB) (0.03%) | 94μs |
1 x afterRenderModule mod_footer (Footer) (1.98KB) (0.03%) | 91μs |
1 x beforeRenderModule mod_hikashop (Product Banner) (9.73KB) (0.03%) | 88μs |
1 x beforeRenderModule mod_banners (Banner Top) (7.16KB) (0.03%) | 88μs |
1 x beforeRenderModule mod_banners (Banner) (7.18KB) (0.03%) | 87μs |
1 x beforeRenderModule mod_articles_category (Lead Article) (2.07KB) (0.03%) | 87μs |
1 x beforeRenderModule mod_articles_category (Beauty) (776B) (0.03%) | 80μs |
1 x afterRenderModule mod_menu (Menu Footer) (2.31KB) (0.03%) | 79μs |
1 x beforeRenderModule mod_menu (Bonus pages) (8B) (0.03%) | 79μs |
1 x beforeRenderModule mod_menu (Top Bar) (1.24KB) (0.03%) | 79μs |
1 x afterRenderModule mod_banners (Banner 2) (2.02KB) (0.03%) | 77μs |
1 x afterRenderModule mod_hikashop (Related products) (2.25KB) (0.03%) | 76μs |
1 x beforeRenderModule mod_articles_category (Fashion) (264B) (0.03%) | 74μs |
1 x afterRenderModule mod_banners (Banner 3) (2.02KB) (0.02%) | 74μs |
1 x afterRenderModule mod_banners (Banner) (2KB) (0.02%) | 74μs |
1 x beforeRenderModule mod_articles_category (Celebrity) (7.54KB) (0.02%) | 73μs |
1 x beforeRenderModule mod_articles_category (Featured Article) (296B) (0.02%) | 73μs |
1 x beforeRenderModule mod_banners (Banner 4) (1.37KB) (0.02%) | 70μs |
1 x beforeRenderModule mod_banners (Banner 3) (3.34KB) (0.02%) | 69μs |
1 x beforeRenderModule mod_custom (Social) (2.26KB) (0.02%) | 66μs |
1 x beforeRenderModule mod_banners (Banner 2) (7.16KB) (0.02%) | 65μs |
1 x beforeRenderModule mod_menu (Menu Footer) (2.63KB) (0.02%) | 55μs |
1 x beforeRenderModule mod_articles_latest (Latest Footer ) (840B) (0.02%) | 52μs |
1 x beforeRenderModule mod_hikashop (Related products) (536B) (0.02%) | 46μs |
1 x beforeRenderModule mod_articles_category (Most Popular) (8.75KB) (0.01%) | 38μs |
1 x beforeRenderModule mod_banners (Banner right) (2KB) (0.01%) | 26μs |
1 x beforeRenderModule mod_articles_category (Celebrity) (704B) (0.01%) | 15μs |
1 x beforeRenderModule mod_articles_category (Featured Article) (720B) (0.01%) | 15μs |
1 x beforeRenderModule mod_menu (Bonus pages) (720B) (0.01%) | 15μs |
1 x beforeRenderModule mod_articles_category (Most Popular) (704B) (0%) | 14μs |
1 x beforeRenderModule mod_hikashop (Best sellers) (720B) (0%) | 13μs |
1 x beforeRenderModule mod_banners (Banner Top) (720B) (0%) | 12μs |
1 x beforeRenderModule mod_articles_latest (Latest Footer ) (704B) (0%) | 11μs |
1 x beforeRenderModule mod_banners (Banner 4) (720B) (0%) | 11μs |
1 x beforeRenderModule mod_articles_category (Beauty) (704B) (0%) | 11μs |
1 x beforeRenderModule mod_articles_category (Fashion) (704B) (0%) | 11μs |
1 x beforeRenderModule mod_hikashop (Product Banner) (720B) (0%) | 11μs |
1 x beforeRenderModule mod_menu (Menu Footer) (720B) (0%) | 10μs |
1 x beforeRenderModule mod_articles_category (Editor's Picks) (720B) (0%) | 10μs |
1 x beforeRenderModule mod_banners (Banner) (704B) (0%) | 10μs |
1 x beforeRenderModule mod_banners (Banner 2) (720B) (0%) | 10μs |
1 x beforeRenderModule mod_footer (Footer) (704B) (0%) | 9μs |
1 x beforeRenderModule mod_banners (Banner 3) (720B) (0%) | 9μs |
1 x beforeRenderModule mod_menu (Top Bar) (704B) (0%) | 9μs |
1 x beforeRenderModule mod_hikashop (Latest products) (720B) (0%) | 9μs |
1 x beforeRenderModule mod_articles_category (Lead Article) (704B) (0%) | 9μs |
1 x beforeRenderModule mod_custom (Social) (704B) (0%) | 8μs |
1 x beforeRenderModule mod_hikashop (Related products) (720B) (0%) | 8μs |
1 x beforeRenderModule mod_banners (Banner right) (720B) (0%) | 7μs |
SELECT @@SESSION.sql_mode;
272μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `ajr4k_session`
WHERE `session_id` = ?
1.02ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `ajr4k_session`
WHERE `session_id` = :session_id LIMIT 1
104μ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)
1.18ms944BParams/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
3.04ms1.61KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `ajr4k_viewlevels`
1.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
1.11ms1.33KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `ajr4k_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`
2.29ms3.98KBParams/libraries/src/Plugin/PluginHelper.php:294CopyUPDATE ajr4k_extensions
SET enabled=1
WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'
755μs688B/plugins/system/jacontenttype/jacontenttype.php:76CopySELECT *
FROM `ajr4k_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
816μs1.58KB/libraries/src/Language/LanguageHelper.php:142CopySELECT `element`,`name`,`client_id`,`extension_id`
FROM `ajr4k_extensions`
WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1
480μs848B/libraries/src/Language/LanguageHelper.php:213CopySELECT * FROM ajr4k_hikashop_config
432μs40.63KB/administrator/components/com_hikashop/classes/config.php:16CopySET sql_mode=(SELECT REPLACE(REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''), 'STRICT_TRANS_TABLES', ''));
60μ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`
2.86ms52.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
2.05ms848B/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 = 248) LIMIT 1
388μ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')
5.77ms3.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 = 'cb488fb2c1cdcd6da8187cd1476f5dbb') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
568μs520B/administrator/components/com_hikashop/classes/cart.php:69CopySELECT * FROM ajr4k_hikashop_currency WHERE currency_id IN (2)
238μ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 = 4) ORDER BY product_category_id ASC LIMIT 1
534μs21.84KB/components/com_hikashop/views/product/view.html.php:1299CopyUPDATE ajr4k_hikashop_product SET product_hit = product_hit + 1, product_last_seen_date = 1743460912 WHERE product_id = 4
207μ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 = 4) AND (pr.product_related_type = 'options') AND (p.product_published = 1) AND ((p.product_sale_start = '' OR p.product_sale_start <= 1743460912)) AND ((p.product_sale_end = '' OR p.product_sale_end > 1743460912)) ORDER BY pr.product_related_ordering ASC, pr.product_related_id ASC
328μs5.41KB/components/com_hikashop/views/product/view.html.php:1341CopySELECT * FROM ajr4k_hikashop_product WHERE (product_parent_id IN (4)) AND (product_published = 1)
297μ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 (4,242,243,244,245,246,247,248,249,250,251,252,253) ORDER BY v.ordering ASC, c.characteristic_ordering ASC
1.01ms1.95KB/components/com_hikashop/views/product/view.html.php:1427CopySELECT * FROM ajr4k_hikashop_file WHERE file_ref_id IN (4,242,243,244,245,246,247,248,249,250,251,252,253) AND file_type IN ('product','file') ORDER BY file_ordering ASC, file_id ASC
302μ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
130μ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 < 1743460912) AND ((p.price_end_date < 1 OR p.price_end_date > 1743460912)) AND (p.price_product_id IN (4,242,243,244,245,246,247,248,249,250,251,252,253)) AND ((p.price_users = '' OR p.price_users LIKE '%,0,%')) ORDER BY p.price_site_id ASC, p.price_value DESC
256μ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 <= 1743460912 AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1743460912) ORDER BY b.taxation_id ASC
225μs2.38KB/administrator/components/com_hikashop/classes/currency.php:199CopySELECT * FROM ajr4k_hikashop_zone WHERE zone_id = 73
144μ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 < 1743460912) AND (discount_end > 1743460912 OR discount_end = 0) AND (discount_product_id IN ('','0','4','242','243','244','245','246','247','248','249','250','251','252','253') OR discount_product_id LIKE '%,4,%' OR discount_product_id LIKE '%,242,%' OR discount_product_id LIKE '%,243,%' OR discount_product_id LIKE '%,244,%' OR discount_product_id LIKE '%,245,%' OR discount_product_id LIKE '%,246,%' OR discount_product_id LIKE '%,247,%' OR discount_product_id LIKE '%,248,%' OR discount_product_id LIKE '%,249,%' OR discount_product_id LIKE '%,250,%' OR discount_product_id LIKE '%,251,%' OR discount_product_id LIKE '%,252,%' OR discount_product_id LIKE '%,253,%') 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,%'))
268μs3.08KB/administrator/components/com_hikashop/classes/currency.php:1709CopySELECT category_id FROM ajr4k_hikashop_product_category WHERE product_id IN (4) ORDER BY ordering ASC
142μ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
533μ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 '%,4,%')) ORDER BY a.`field_ordering` ASC
197μs5.23KB/administrator/components/com_hikashop/classes/field.php:167CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743460912 AND (a.badge_end >= 1743460912 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 >= 230131278) 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
286μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743460912 AND (a.badge_end >= 1743460912 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 >= 230131315) 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
325μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743460912 AND (a.badge_end >= 1743460912 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 >= 230131307) 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 <= 1743460912 AND (a.badge_end >= 1743460912 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 >= 230131301) 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
217μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743460912 AND (a.badge_end >= 1743460912 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 >= 230131296) 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
124μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743460912 AND (a.badge_end >= 1743460912 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 >= 230131291) 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
121μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743460912 AND (a.badge_end >= 1743460912 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 >= 230131283) 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
149μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743460912 AND (a.badge_end >= 1743460912 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 >= 230131268) 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
133μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743460912 AND (a.badge_end >= 1743460912 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 >= 230131259) 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
128μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743460912 AND (a.badge_end >= 1743460912 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 >= 230131249) 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
137μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743460912 AND (a.badge_end >= 1743460912 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 >= 230131244) 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
112μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743460912 AND (a.badge_end >= 1743460912 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 >= 230131239) 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
125μ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 = 4 ORDER BY a.product_category_id ASC
186μ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')
2.1ms552B/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
227μ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 (242,243,244,245,246,247,248,249,250,251,252,253) AND b.shipping_price_ref_type = 'product')) ORDER BY b.shipping_price_min_quantity
269μs912B/plugins/hikashop/shippingmanual_prices/shippingmanual_prices.php:58CopySELECT * FROM ajr4k_extensions WHERE folder='hikashop' AND element='shippingmanual_prices' AND type='plugin'
486μs2.53KB/administrator/components/com_hikashop/classes/plugins.php:113CopySELECT product_average_score, product_total_vote FROM ajr4k_hikashop_product WHERE product_id = 4
142μ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 = 4) AND (vote_ip = '18.224.64.19') AND (vote_user_id = '')
198μ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 = 4 AND vote_comment != ''
259μ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 = 4 AND vote_comment != '' ORDER BY `vote_date` ASC LIMIT 0,5
284μs21.23KB/components/com_hikashop/views/vote/view.html.php:115CopySELECT product_id FROM ajr4k_hikashop_product WHERE product_parent_id = 4
127μs712B/components/com_hikashop/views/vote/view.html.php:120CopySELECT * FROM ajr4k_hikashop_product WHERE product_id = '4' LIMIT 1
318μs5.47KB/administrator/components/com_hikashop/helpers/helper.php:2492CopySELECT product_average_score, product_total_vote FROM ajr4k_hikashop_product WHERE product_id = 4
328μ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 = 4) AND (vote_ip = '18.224.64.19') AND (vote_user_id = '')
169μs1.45KB/administrator/components/com_hikashop/classes/vote.php:688CopySELECT * FROM ajr4k_extensions WHERE folder='system' AND element='hikashopsocial' AND type='plugin'
278μs2.53KB/administrator/components/com_hikashop/classes/plugins.php:113CopySELECT * FROM ajr4k_extensions WHERE folder='content' AND element='hikashopsocial' AND type='plugin'
179μ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)
1.52ms3.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 = 'cb488fb2c1cdcd6da8187cd1476f5dbb') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
268μ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
364μs4.59KB/administrator/components/com_hikashop/classes/category.php:35CopySELECT * FROM ajr4k_hikashop_category WHERE category_id = '2' LIMIT 1
173μ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
236μ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 33, 3
567μs568B/components/com_hikashop/views/product/view.html.php:863CopySELECT b.* FROM ajr4k_hikashop_product AS b WHERE product_id IN ( 11,28,54 ) ORDER BY b.product_sales DESC
341μs5.5KB/components/com_hikashop/views/product/view.html.php:870CopySELECT * FROM ajr4k_hikashop_file WHERE file_ref_id IN (11,28,54) AND file_type IN ('product','file') ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
276μs1.55KB/administrator/components/com_hikashop/classes/product.php:2401CopySELECT variant_product_id FROM ajr4k_hikashop_variant WHERE variant_product_id IN (11,28,54)
176μ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 (11,28,54)
60μ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 ('11','28','54') AND product_published = 1 AND product_type = 'variant' AND product_sale_start < 1743460912 AND (product_sale_end > 1743460912 OR product_sale_end = 0)
312μ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 < 1743460912 AND (discount_end > 1743460912 OR discount_end = 0) AND ( (discount_product_id IN ('','0','11','28','54')) OR (discount_product_id LIKE '%,11,%') OR (discount_product_id LIKE '%,28,%') OR (discount_product_id LIKE '%,54,%') OR (discount_product_id LIKE '%,194,%') OR (discount_product_id LIKE '%,195,%') OR (discount_product_id LIKE '%,196,%') OR (discount_product_id LIKE '%,197,%') OR (discount_product_id LIKE '%,198,%') OR (discount_product_id LIKE '%,199,%') OR (discount_product_id LIKE '%,200,%') OR (discount_product_id LIKE '%,201,%') OR (discount_product_id LIKE '%,202,%') OR (discount_product_id LIKE '%,203,%') OR (discount_product_id LIKE '%,204,%') OR (discount_product_id LIKE '%,205,%') OR (discount_product_id LIKE '%,218,%') OR (discount_product_id LIKE '%,219,%') OR (discount_product_id LIKE '%,220,%') OR (discount_product_id LIKE '%,221,%') OR (discount_product_id LIKE '%,222,%') OR (discount_product_id LIKE '%,223,%') OR (discount_product_id LIKE '%,224,%') OR (discount_product_id LIKE '%,225,%') OR (discount_product_id LIKE '%,226,%') OR (discount_product_id LIKE '%,227,%') OR (discount_product_id LIKE '%,228,%') OR (discount_product_id LIKE '%,229,%') 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,%')
201μ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 (11,28,54) AND a.price_currency_id IN (1,2) AND a.price_start_date < 1743460912 AND (a.price_end_date < 1 OR a.price_end_date > 1743460912) 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
260μ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 (11,28,54);
194μ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
501μs2.78KB/administrator/components/com_hikashop/classes/category.php:771CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743460912 AND (a.badge_end >= 1743460912 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 >= 231426651) 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
143μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT hk_parent.* FROM ajr4k_hikashop_category AS hk_cat LEFT JOIN ajr4k_hikashop_category AS hk_parent ON (hk_parent.category_left <= hk_cat.category_left AND hk_parent.category_right >= hk_cat.category_right) WHERE hk_cat.category_id IN (16) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left
452μs2.78KB/administrator/components/com_hikashop/classes/category.php:771CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743460912 AND (a.badge_end >= 1743460912 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 >= 230931680) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '16' OR badge_category_id LIKE '%,16,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '16' OR badge_category_id LIKE '%,16,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
152μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743460912 AND (a.badge_end >= 1743460912 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 >= 230307975) 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
146μ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
542μ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;
130μ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')
593μ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 = 11 ORDER BY pc.product_category_id ASC
242μ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 = 11 ORDER BY pc.product_category_id ASC
173μ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 = 11) AND (vote_ip = '18.224.64.19') AND (vote_user_id = '')
331μ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 = 28 ORDER BY pc.product_category_id ASC
177μ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 = 28 ORDER BY pc.product_category_id ASC
155μ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 = 28) AND (vote_ip = '18.224.64.19') AND (vote_user_id = '')
129μ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 = 54 ORDER BY pc.product_category_id ASC
166μ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 = 54 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 = 54) AND (vote_ip = '18.224.64.19') AND (vote_user_id = '')
160μ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 = 'cb488fb2c1cdcd6da8187cd1476f5dbb') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
263μ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
266μs4.59KB/administrator/components/com_hikashop/classes/category.php:35CopySELECT * FROM ajr4k_hikashop_category WHERE category_id = '2' LIMIT 1
130μ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
152μ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 33, 3
568μs568B/components/com_hikashop/views/product/view.html.php:863CopySELECT b.* FROM ajr4k_hikashop_product AS b WHERE product_id IN ( 48,49,50 ) ORDER BY b.product_created ASC
263μs5.5KB/components/com_hikashop/views/product/view.html.php:870CopySELECT * FROM ajr4k_hikashop_file WHERE file_ref_id IN (48,49,50) AND file_type IN ('product','file') ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
240μs1.55KB/administrator/components/com_hikashop/classes/product.php:2401CopySELECT variant_product_id FROM ajr4k_hikashop_variant WHERE variant_product_id IN (48,49,50)
105μ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 (48,49,50)
52μs520B/administrator/components/com_hikashop/classes/product.php:2441CopySELECT product_parent_id, product_id, product_tax_id FROM ajr4k_hikashop_product WHERE product_parent_id IN ('48','49','50') AND product_published = 1 AND product_type = 'variant' AND product_sale_start < 1743460912 AND (product_sale_end > 1743460912 OR product_sale_end = 0)
312μ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 < 1743460912 AND (discount_end > 1743460912 OR discount_end = 0) AND ( (discount_product_id IN ('','0','48','49','50')) OR (discount_product_id LIKE '%,48,%') OR (discount_product_id LIKE '%,49,%') OR (discount_product_id LIKE '%,50,%') OR (discount_product_id LIKE '%,302,%') OR (discount_product_id LIKE '%,303,%') OR (discount_product_id LIKE '%,304,%') OR (discount_product_id LIKE '%,305,%') OR (discount_product_id LIKE '%,306,%') OR (discount_product_id LIKE '%,307,%') OR (discount_product_id LIKE '%,308,%') OR (discount_product_id LIKE '%,309,%') OR (discount_product_id LIKE '%,310,%') OR (discount_product_id LIKE '%,311,%') OR (discount_product_id LIKE '%,312,%') OR (discount_product_id LIKE '%,313,%') OR (discount_product_id LIKE '%,410,%') OR (discount_product_id LIKE '%,411,%') OR (discount_product_id LIKE '%,412,%') OR (discount_product_id LIKE '%,413,%') OR (discount_product_id LIKE '%,414,%') OR (discount_product_id LIKE '%,415,%') OR (discount_product_id LIKE '%,416,%') OR (discount_product_id LIKE '%,417,%') OR (discount_product_id LIKE '%,418,%') OR (discount_product_id LIKE '%,419,%') OR (discount_product_id LIKE '%,420,%') OR (discount_product_id LIKE '%,421,%') OR (discount_product_id LIKE '%,482,%') OR (discount_product_id LIKE '%,483,%') OR (discount_product_id LIKE '%,484,%') OR (discount_product_id LIKE '%,485,%') OR (discount_product_id LIKE '%,486,%') OR (discount_product_id LIKE '%,487,%') OR (discount_product_id LIKE '%,488,%') OR (discount_product_id LIKE '%,489,%') OR (discount_product_id LIKE '%,490,%') OR (discount_product_id LIKE '%,491,%') OR (discount_product_id LIKE '%,492,%') OR (discount_product_id LIKE '%,493,%') ) 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,%')
221μ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 (48,49,50) AND a.price_currency_id IN (1,2) AND a.price_start_date < 1743460912 AND (a.price_end_date < 1 OR a.price_end_date > 1743460912) 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
207μ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 (48,49,50);
198μs3.03KB/administrator/components/com_hikashop/classes/product.php:2492CopySELECT hk_parent.* FROM ajr4k_hikashop_category AS hk_cat LEFT JOIN ajr4k_hikashop_category AS hk_parent ON (hk_parent.category_left <= hk_cat.category_left AND hk_parent.category_right >= hk_cat.category_right) WHERE hk_cat.category_id IN (14) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left
475μs2.78KB/administrator/components/com_hikashop/classes/category.php:771CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743460912 AND (a.badge_end >= 1743460912 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 >= 230311970) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
154μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743460912 AND (a.badge_end >= 1743460912 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 >= 230309976) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
127μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743460912 AND (a.badge_end >= 1743460912 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 >= 230309475) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
129μ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
408μ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;
97μ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 = 48 ORDER BY pc.product_category_id ASC
151μ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 = 48 ORDER BY pc.product_category_id ASC
110μ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 = 48) AND (vote_ip = '18.224.64.19') AND (vote_user_id = '')
124μ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 = 49 ORDER BY pc.product_category_id ASC
122μ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 = 49 ORDER BY pc.product_category_id ASC
122μ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 = 49) AND (vote_ip = '18.224.64.19') AND (vote_user_id = '')
145μ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 = 50 ORDER BY pc.product_category_id ASC
105μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 50 ORDER BY pc.product_category_id ASC
108μ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 = 50) AND (vote_ip = '18.224.64.19') AND (vote_user_id = '')
135μ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 = 'cb488fb2c1cdcd6da8187cd1476f5dbb') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
246μ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
277μs4.59KB/administrator/components/com_hikashop/classes/category.php:35CopySELECT * FROM ajr4k_hikashop_category WHERE category_id = '2' LIMIT 1
121μ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
164μ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 33, 3
2.58ms5.5KB/components/com_hikashop/views/product/view.html.php:874CopySELECT * FROM ajr4k_hikashop_file WHERE file_ref_id IN (22,29,50) AND file_type IN ('product','file') ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
360μs1.58KB/administrator/components/com_hikashop/classes/product.php:2401CopySELECT variant_product_id FROM ajr4k_hikashop_variant WHERE variant_product_id IN (22,29,50)
150μ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 (22,29,50)
63μ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 ('22','29','50') AND product_published = 1 AND product_type = 'variant' AND product_sale_start < 1743460912 AND (product_sale_end > 1743460912 OR product_sale_end = 0)
455μ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 < 1743460912 AND (discount_end > 1743460912 OR discount_end = 0) AND ( (discount_product_id IN ('','0','22','29','50')) OR (discount_product_id LIKE '%,22,%') OR (discount_product_id LIKE '%,29,%') OR (discount_product_id LIKE '%,50,%') OR (discount_product_id LIKE '%,458,%') OR (discount_product_id LIKE '%,459,%') OR (discount_product_id LIKE '%,460,%') OR (discount_product_id LIKE '%,461,%') OR (discount_product_id LIKE '%,462,%') OR (discount_product_id LIKE '%,463,%') OR (discount_product_id LIKE '%,464,%') OR (discount_product_id LIKE '%,465,%') OR (discount_product_id LIKE '%,466,%') OR (discount_product_id LIKE '%,467,%') OR (discount_product_id LIKE '%,468,%') OR (discount_product_id LIKE '%,469,%') OR (discount_product_id LIKE '%,470,%') OR (discount_product_id LIKE '%,471,%') OR (discount_product_id LIKE '%,472,%') OR (discount_product_id LIKE '%,473,%') OR (discount_product_id LIKE '%,474,%') OR (discount_product_id LIKE '%,475,%') OR (discount_product_id LIKE '%,476,%') OR (discount_product_id LIKE '%,477,%') OR (discount_product_id LIKE '%,478,%') OR (discount_product_id LIKE '%,479,%') OR (discount_product_id LIKE '%,480,%') OR (discount_product_id LIKE '%,481,%') OR (discount_product_id LIKE '%,482,%') OR (discount_product_id LIKE '%,483,%') OR (discount_product_id LIKE '%,484,%') OR (discount_product_id LIKE '%,485,%') OR (discount_product_id LIKE '%,486,%') OR (discount_product_id LIKE '%,487,%') OR (discount_product_id LIKE '%,488,%') OR (discount_product_id LIKE '%,489,%') OR (discount_product_id LIKE '%,490,%') OR (discount_product_id LIKE '%,491,%') OR (discount_product_id LIKE '%,492,%') OR (discount_product_id LIKE '%,493,%') ) 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,%')
290μs11.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 (22,29,50) AND a.price_currency_id IN (1,2) AND a.price_start_date < 1743460912 AND (a.price_end_date < 1 OR a.price_end_date > 1743460912) 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
231μ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 (22,29,50);
192μs3.03KB/administrator/components/com_hikashop/classes/product.php:2492CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743460912 AND (a.badge_end >= 1743460912 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 >= 230998927) 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
155μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743460912 AND (a.badge_end >= 1743460912 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 >= 230931624) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '16' OR badge_category_id LIKE '%,16,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '16' OR badge_category_id LIKE '%,16,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
115μ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
489μ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;
93μ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 = 22 ORDER BY pc.product_category_id ASC
164μ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 = 22 ORDER BY pc.product_category_id ASC
129μ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 = 22) AND (vote_ip = '18.224.64.19') AND (vote_user_id = '')
119μs1.45KB/administrator/components/com_hikashop/classes/vote.php:688CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 29 ORDER BY pc.product_category_id ASC
122μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 29 ORDER BY pc.product_category_id ASC
95μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT * FROM ajr4k_hikashop_vote WHERE (vote_type = 'product') AND (vote_rating != 0) AND (vote_ref_id = 29) AND (vote_ip = '18.224.64.19') AND (vote_user_id = '')
107μ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 = 50 ORDER BY pc.product_category_id ASC
94μ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 = 50 ORDER BY pc.product_category_id ASC
96μ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 = 50) AND (vote_ip = '18.224.64.19') AND (vote_user_id = '')
106μ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
273μ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
678μs1.38KBParams/libraries/src/Language/Associations.php:145CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `ajr4k_modules` AS `m`
LEFT JOIN `ajr4k_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `ajr4k_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id`
WHERE
(
(
(`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND
(`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) AND `m`.`language` IN (:preparedArray3,:preparedArray4)
ORDER BY `m`.`position`,`m`.`ordering`
2.48ms18.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
10.11ms55.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.32ms3.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.13ms5.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.85ms2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
161μ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)
226μ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
245μs2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
148μ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`
682μs4.08KBParams/libraries/src/Categories/Categories.php:375CopySELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,`fp`.`ordering`
FROM `ajr4k_content` AS `a`
LEFT JOIN `ajr4k_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `ajr4k_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `ajr4k_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `ajr4k_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `ajr4k_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10) AND `a`.`created_by_alias` IN (:preparedArray11) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray12,:preparedArray13)
ORDER BY a.title ASC LIMIT 5
1.9ms55.2KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug`
FROM `ajr4k_categories` AS `s`
INNER JOIN `ajr4k_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
392μ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`
288μ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
3.2ms704B/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
269μ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
224μ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
293μ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
249μ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)
252μ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
279μs2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
137μ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
1.78ms39.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
938μ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
249μ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
176μ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
187μ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
149μ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)
234μ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
331μs2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
147μ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
748μ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`
398μ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
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 = 10
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
175μ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
164μ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
141μ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
130μ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
237μ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.46ms39.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
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 = 9
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
168μ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
138μ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
151μ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
137μ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
162μ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
612μ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
198μ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
182μ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
150μ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
149μ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
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 = 11
AND f.context = "com_content.categories"
AND f.language IN ("*", "en-GB")
AND f.access = 1
158μ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)
220μ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
346μs2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
148μ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 = 'cb488fb2c1cdcd6da8187cd1476f5dbb') ORDER BY cart.cart_current DESC, cart.cart_modified DESC
174μ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
221μ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
920μs5.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
262μs1.52KB/administrator/components/com_hikashop/classes/product.php:2401CopySELECT variant_product_id FROM ajr4k_hikashop_variant WHERE variant_product_id IN (13,12)
85μ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)
48μ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 < 1743460912 AND (product_sale_end > 1743460912 OR product_sale_end = 0)
316μ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 < 1743460912 AND (discount_end > 1743460912 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,%')
162μ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 < 1743460912 AND (a.price_end_date < 1 OR a.price_end_date > 1743460912) 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
158μ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);
177μ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
361μs2.78KB/administrator/components/com_hikashop/classes/category.php:771CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743460912 AND (a.badge_end >= 1743460912 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 >= 231426651) 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
147μs2.55KB/administrator/components/com_hikashop/classes/badge.php:151CopySELECT a.* FROM ajr4k_hikashop_badge AS a WHERE a.badge_start <= 1743460912 AND (a.badge_end >= 1743460912 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 >= 231426651) 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
122μ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
221μ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;
80μ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
147μ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
133μ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
265μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT c.category_id FROM ajr4k_hikashop_product_category AS pc INNER JOIN ajr4k_hikashop_category AS c ON c.category_id = pc.category_id AND c.category_published = 1 WHERE pc.product_id = 12 ORDER BY pc.product_category_id ASC
110μs536B/administrator/components/com_hikashop/helpers/helper.php:1086CopySELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,`fp`.`ordering`
FROM `ajr4k_content` AS `a`
LEFT JOIN `ajr4k_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `ajr4k_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `ajr4k_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `ajr4k_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `ajr4k_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5) AND `a`.`created_by_alias` IN (:preparedArray6) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray7,:preparedArray8)
ORDER BY a.title ASC LIMIT 1
603μ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
250μ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
2.1ms23.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
322μ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
259μ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)
271μ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
273μs2.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `ajr4k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)
194μ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
972μs1.32KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466CopySELECT `session_id`
FROM `ajr4k_session`
WHERE `session_id` = ?
310μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyUPDATE `ajr4k_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
277μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy