Joomla! Version | 4.4.13 |
PHP Version | 7.4.33 |
Identity | guest |
Response | 200 |
Template | flex |
Database |
|
1 x afterInitialise (2.58MB) (26.99%) | 782.97ms |
1 x Before Access::getAssetRules (id:1 name:root.1) (2.51MB) (18.04%) | 523.23ms |
1 x afterRenderRawModule mod_sppagebuilder (Contact Footer Ramsjgat) (3.16MB) (11.09%) | 321.66ms |
1 x beforeRenderRawModule mod_search (Search) (216.84KB) (7.5%) | 217.63ms |
1 x Before Access::preloadComponents (all components) (1.08MB) (7.42%) | 215.22ms |
1 x afterRenderComponent com_djcatalog2 (179.59KB) (4.24%) | 123.06ms |
1 x beforeRenderRawModule mod_djc2filters (Filter prijscategorie) (3.48MB) (4.15%) | 120.43ms |
1 x afterRenderRawModule mod_djc2categories (Onze Rubrieken) (518.95KB) (4.06%) | 117.74ms |
1 x afterLoad (829.2KB) (3.48%) | 100.82ms |
1 x afterRoute (857.49KB) (2.97%) | 86.24ms |
1 x beforeRenderComponent com_djcatalog2 (612.89KB) (2.88%) | 83.64ms |
1 x afterRenderRawModule mod_menu (Main Menu) (21.11KB) (2.21%) | 64.08ms |
1 x afterRenderRawModule mod_djc2filters (Filteren op:) (196.7KB) (1.55%) | 45.05ms |
1 x afterRenderModule mod_djc2filters (Filter prijscategorie) (71.73KB) (1.27%) | 36.89ms |
1 x Before Access::getAssetRules (id:1 name:root.1) (161.09KB) (0.6%) | 17.51ms |
1 x afterRenderRawModule mod_djc2filters (Filter prijscategorie) (23.28KB) (0.33%) | 9.50ms |
1 x afterRenderRawModule mod_djc2producers (Boekstatus) (28.44KB) (0.27%) | 7.72ms |
1 x afterRender (7.37KB) (0.18%) | 5.23ms |
1 x afterRenderRawModule mod_custom (Nieuwe Boeken 40%) (9.55KB) (0.13%) | 3.69ms |
1 x After Access::preloadComponents (all components) (134.75KB) (0.11%) | 3.21ms |
1 x afterRenderRawModule mod_search (Search) (15.16KB) (0.11%) | 3.08ms |
1 x afterRenderRawModule mod_djc2filters (Filtert) (14.71KB) (0.09%) | 2.48ms |
1 x After Access::getAssetRules (id:166 name:com_djcatalog2) (8.28KB) (0.04%) | 1.26ms |
1 x afterRenderModule mod_search (Search) (3.39KB) (0.03%) | 839μs |
1 x afterRenderModule mod_djc2producers (Boekstatus) (3.18KB) (0.03%) | 767μs |
1 x afterRenderModule mod_djc2filters (Filteren op:) (5.91KB) (0.02%) | 473μs |
1 x afterRenderModule mod_djc2categories (Onze Rubrieken) (2.08KB) (0.02%) | 444μs |
1 x afterRenderModule mod_custom (Nieuwe Boeken 40%) (2.15KB) (0.01%) | 366μs |
1 x afterDispatch (3.96KB) (0.01%) | 360μs |
1 x afterRenderModule mod_menu (Main Menu) (2.65KB) (0.01%) | 320μs |
1 x afterRenderModule mod_sppagebuilder (Contact Footer Ramsjgat) (17.96KB) (0.01%) | 249μs |
1 x afterRenderModule mod_djc2filters (Filtert) (1.3KB) (0.01%) | 239μs |
1 x beforeRenderRawModule mod_djc2filters (Filteren op:) (680B) (0%) | 102μs |
1 x beforeRenderRawModule mod_djc2filters (Filtert) (3.47KB) (0%) | 99μs |
1 x beforeRenderRawModule mod_sppagebuilder (Contact Footer Ramsjgat) (2.02KB) (0%) | 92μs |
1 x beforeRenderRawModule mod_djc2producers (Boekstatus) (14.44KB) (0%) | 72μs |
1 x After Access::getAssetRules (id:1 name:root.1) (1.59KB) (0%) | 55μs |
1 x beforeRenderRawModule mod_djc2categories (Onze Rubrieken) (488B) (0%) | 52μs |
1 x beforeRenderModule mod_djc2filters (Filter prijscategorie) (736B) (0%) | 45μs |
1 x beforeRenderRawModule mod_menu (Main Menu) (552B) (0%) | 40μs |
1 x beforeRenderRawModule mod_custom (Nieuwe Boeken 40%) (3.13KB) (0%) | 40μs |
1 x Before Access::getAssetRules (id:166 name:com_djcatalog2) (3.65KB) (0%) | 38μs |
1 x beforeRenderModule mod_djc2producers (Boekstatus) (720B) (0%) | 26μs |
1 x beforeRenderModule mod_djc2filters (Filteren op:) (720B) (0%) | 18μs |
1 x After Access::getAssetRules (id:1 name:root.1) (2.22KB) (0%) | 17μs |
1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%) | 16μs |
1 x beforeRenderModule mod_sppagebuilder (Contact Footer Ramsjgat) (736B) (0%) | 16μs |
1 x beforeRenderModule mod_custom (Nieuwe Boeken 40%) (720B) (0%) | 16μs |
1 x beforeRenderModule mod_djc2categories (Onze Rubrieken) (720B) (0%) | 15μs |
1 x beforeRenderModule mod_search (Search) (704B) (0%) | 12μs |
1 x beforeRenderModule mod_djc2filters (Filtert) (720B) (0%) | 9μs |
SELECT `data`
FROM `z2pdg_session`
WHERE `session_id` = ?
596μs1.65KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `z2pdg_session`
WHERE `session_id` = :session_id LIMIT 1
461μs1016BParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `z2pdg_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
351μs1.63KBParamsCopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `z2pdg_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
47.47ms256B/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `z2pdg_viewlevels`
906μs768B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `z2pdg_usergroups` AS `a`
LEFT JOIN `z2pdg_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
1.08ms1.04KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `z2pdg_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`
3.27ms1.41KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT `template`
FROM `z2pdg_template_styles`
WHERE `client_id` = 0 AND `home` = 1
995μs72B/components/com_sppagebuilder/parser/addon-parser.php:1095CopySELECT `value` FROM z2pdg_acym_configuration WHERE `name` = 'level'
825μs1.31KB/plugins/system/acymtriggers/acymtriggers.php:645CopySELECT `template`
FROM `z2pdg_template_styles`
WHERE `client_id` = 0 AND `home` = 1
1.04ms72B/plugins/system/helix3/helix3.php:247CopySELECT `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 `z2pdg_menu` AS `m`
LEFT JOIN `z2pdg_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id`
WHERE
(
(`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2)
ORDER BY `m`.`lft`
1.63ms2.95KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT c.* FROM z2pdg_djc2_categories AS c WHERE c.published=1 AND c.access IN (1,5) AND (c.language = 'nl-NL' OR c.language = '*') ORDER BY c.parent_id ASC, c.ordering ASC
2.41ms1.31KB/administrator/components/com_djcatalog2/lib/categories.php:355CopySELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM z2pdg_djc2_categories as i
INNER JOIN z2pdg_djc2_images as img on img.id=(select id from z2pdg_djc2_images where type='category' and item_id=i.id order by ordering asc limit 1)
WHERE (i.language = 'nl-NL' OR i.language = '*')
1.22ms352B/administrator/components/com_djcatalog2/lib/categories.php:368CopySELECT *
FROM `z2pdg_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
711μs960B/libraries/src/Language/LanguageHelper.php:142CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `z2pdg_template_styles` AS `s`
LEFT JOIN `z2pdg_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id`
WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1
1.87ms400B/administrator/components/com_templates/src/Model/StyleModel.php:773Copyselect alias from z2pdg_djc2_items_extra_fields where type='checkbox' or type='radio' or type='select'
821μs64B/components/com_djcatalog2/controller.php:133CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `z2pdg_assets`
WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47)
2.75ms12.62KBParams/libraries/src/Access/Access.php:357CopySELECT id
FROM z2pdg_djc2_customer_groups
WHERE (user_group IN (1,9) OR is_default=1)
ORDER BY ordering DESC LIMIT 1
911μs64B/components/com_djcatalog2/helpers/user.php:368Copyselect * from z2pdg_djc2_countries where is_default=1
1.14ms488B/components/com_djcatalog2/helpers/user.php:429CopySELECT vrul.id as rule_id, vrul.name, vrat.*
FROM z2pdg_djc2_vat_rules AS vrul
INNER JOIN z2pdg_djc2_vat_rules_xref AS vx ON vx.rule_id = vrul.id
INNER JOIN z2pdg_djc2_vat_rates AS vrat ON vx.rate_id = vrat.id
WHERE vrat.country_id=0 AND vrat.state_id=0 AND (vrat.client_type='A' OR vrat.client_type='R')
ORDER BY vrat.client_type ASC, vrat.country_id ASC, vrat.state_id ASC
1.42ms536B/components/com_djcatalog2/helpers/user.php:503CopySELECT f.*, g.name as group_name, g.label as group_label, g.id as fgroup_id
FROM z2pdg_djc2_items_extra_fields as f
LEFT JOIN z2pdg_djc2_items_extra_fields_groups as g ON g.id=f.group_id
WHERE f.published = 1
ORDER BY IFNULL(g.ordering,0) asc, g.ordering asc, f.ordering asc
2.27ms1.65KB/components/com_djcatalog2/models/items.php:1110CopySELECT o.id, o.field_id
FROM z2pdg_djc2_items_extra_fields_options AS o
ORDER BY o.field_id asc, o.ordering asc
812μs136B/components/com_djcatalog2/models/items.php:1120CopySELECT c.* FROM z2pdg_djc2_categories AS c WHERE c.published=1 AND c.access IN (1,5) AND (c.language = 'nl-NL' OR c.language = '*') ORDER BY c.parent_id ASC, c.ordering ASC
2.1ms1.31KB/administrator/components/com_djcatalog2/lib/categories.php:355CopySELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM z2pdg_djc2_categories as i
INNER JOIN z2pdg_djc2_images as img on img.id=(select id from z2pdg_djc2_images where type='category' and item_id=i.id order by ordering asc limit 1)
WHERE (i.language = 'nl-NL' OR i.language = '*')
1.26ms352B/administrator/components/com_djcatalog2/lib/categories.php:368CopySELECT COUNT(distinct (i.id))
FROM z2pdg_djc2_items as i
INNER JOIN (SELECT ic.item_id FROM z2pdg_djc2_items_categories AS ic INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id WHERE c.published = 1 AND c.access IN (1,5) AND ic.category_id IN (86)) as category_filter ON i.id = category_filter.item_id
LEFT JOIN z2pdg_djc2_categories AS c ON c.id = i.cat_id
LEFT JOIN z2pdg_djc2_producers AS p ON p.id = i.producer_id
LEFT JOIN z2pdg_users AS ua ON ua.id = i.created_by
LEFT JOIN z2pdg_djc2_prices AS gc ON gc.item_id = i.id AND gc.group_id=0
LEFT JOIN z2pdg_djc2_countries AS countries ON countries.id = i.country
LEFT JOIN z2pdg_djc2_item_rating AS v ON i.id = v.item_id
LEFT JOIN z2pdg_djc2_countries_states AS states ON states.id = i.state
LEFT JOIN (SELECT item_id, COUNT(*) as combo_count FROM z2pdg_djc2_items_combinations GROUP BY item_id) AS combinations ON combinations.item_id = i.id
WHERE (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33') AND i.published = 1 AND i.access IN (1,5) AND i.parent_id=0 AND (i.language = 'nl-NL' OR i.language = '*')
3.23ms80B/components/com_djcatalog2/models/items.php:344CopySELECT distinct i.*, CASE WHEN (i.special_price > 0.0 AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email,gc.price as group_price, gc.available as group_available,countries.country_name, countries.id as item_country_id,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count,states.name as state_name,combinations.combo_count
FROM z2pdg_djc2_items as i
INNER JOIN (SELECT ic.item_id FROM z2pdg_djc2_items_categories AS ic INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id WHERE c.published = 1 AND c.access IN (1,5) AND ic.category_id IN (86)) as category_filter ON i.id = category_filter.item_id
LEFT JOIN z2pdg_djc2_categories AS c ON c.id = i.cat_id
LEFT JOIN z2pdg_djc2_producers AS p ON p.id = i.producer_id
LEFT JOIN z2pdg_users AS ua ON ua.id = i.created_by
LEFT JOIN z2pdg_djc2_prices AS gc ON gc.item_id = i.id AND gc.group_id=0
LEFT JOIN z2pdg_djc2_countries AS countries ON countries.id = i.country
LEFT JOIN z2pdg_djc2_item_rating AS v ON i.id = v.item_id
LEFT JOIN z2pdg_djc2_countries_states AS states ON states.id = i.state
LEFT JOIN (SELECT item_id, COUNT(*) as combo_count FROM z2pdg_djc2_items_combinations GROUP BY item_id) AS combinations ON combinations.item_id = i.id
WHERE (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33') AND i.published = 1 AND i.access IN (1,5) AND i.parent_id=0 AND (i.language = 'nl-NL' OR i.language = '*')
ORDER BY i.name desc LIMIT 20, 20
8.24ms6.4KB/components/com_djcatalog2/models/items.php:286CopySELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value, fieldoptions.params as option_params
FROM z2pdg_djc2_items_extra_fields_values_int as fieldvalues
INNER JOIN z2pdg_djc2_items as items on items.id=fieldvalues.item_id
INNER JOIN z2pdg_djc2_items_extra_fields as fields ON fields.id = fieldvalues.field_id
LEFT JOIN z2pdg_djc2_items_extra_fields_options as fieldoptions ON fieldoptions.id = fieldvalues.value AND fieldoptions.field_id = fields.id
WHERE fieldvalues.item_id IN (2060,2458,2081,2080,1687,1528,2120,2129,2073,2070,1547,1698,2072,2085,2083,1512,2128,2127,1485,1067) AND fields.cart_variant = 2 AND fields.published = 1
ORDER BY fieldvalues.field_id asc, fields.ordering asc, fieldoptions.ordering asc
1.32ms648B/components/com_djcatalog2/models/items.php:1230CopySELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value, fieldoptions.params as option_params
FROM z2pdg_djc2_items_extra_fields_values_int as fieldvalues
INNER JOIN z2pdg_djc2_items as items on items.id=fieldvalues.item_id
INNER JOIN z2pdg_djc2_items_extra_fields as fields ON fields.id = fieldvalues.field_id
LEFT JOIN z2pdg_djc2_items_extra_fields_options as fieldoptions ON fieldoptions.id = fieldvalues.value AND fieldoptions.field_id = fields.id
WHERE fieldvalues.item_id IN (2060,2458,2081,2080,1687,1528,2120,2129,2073,2070,1547,1698,2072,2085,2083,1512,2128,2127,1485,1067) AND (fields.visibility = 2 OR fields.visibility = 3) AND fields.published = 1
ORDER BY fieldvalues.field_id asc, fields.ordering asc, fieldoptions.ordering asc
1.22ms648B/components/com_djcatalog2/models/items.php:1233CopySELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
FROM z2pdg_djc2_items_extra_fields_values_text as fieldvalues
INNER JOIN z2pdg_djc2_items as items on items.id=fieldvalues.item_id
INNER JOIN z2pdg_djc2_items_extra_fields as fields ON fields.id = fieldvalues.field_id
WHERE fieldvalues.item_id IN (2060,2458,2081,2080,1687,1528,2120,2129,2073,2070,1547,1698,2072,2085,2083,1512,2128,2127,1485,1067) AND (fields.visibility = 2 OR fields.visibility = 3) AND fields.published = 1
ORDER BY fieldvalues.field_id asc, fields.ordering asc
1.35ms544B/components/com_djcatalog2/models/items.php:1236CopySELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
FROM z2pdg_djc2_items_extra_fields_values_date as fieldvalues
INNER JOIN z2pdg_djc2_items as items on items.id=fieldvalues.item_id
INNER JOIN z2pdg_djc2_items_extra_fields as fields ON fields.id = fieldvalues.field_id
WHERE fieldvalues.item_id IN (2060,2458,2081,2080,1687,1528,2120,2129,2073,2070,1547,1698,2072,2085,2083,1512,2128,2127,1485,1067) AND (fields.visibility = 2 OR fields.visibility = 3) AND fields.published = 1
ORDER BY fieldvalues.field_id asc, fields.ordering asc
432μs544B/components/com_djcatalog2/models/items.php:1239CopySELECT l.*, li.item_id
FROM z2pdg_djc2_labels as l
INNER JOIN z2pdg_djc2_labels_items AS li ON li.label_id=l.id
WHERE li.item_id IN (2060,2458,2081,2080,1687,1528,2120,2129,2073,2070,1547,1698,2072,2085,2083,1512,2128,2127,1485,1067) AND l.published = 1
ORDER BY l.ordering
654μs664B/components/com_djcatalog2/models/items.php:1242CopySELECT cg.*, p.item_id, p.available, p.price
FROM z2pdg_djc2_customer_groups AS cg
INNER JOIN z2pdg_djc2_prices AS p ON p.group_id=cg.id
WHERE p.item_id IN (2060, 2458, 2081, 2080, 1687, 1528, 2120, 2129, 2073, 2070, 1547, 1698, 2072, 2085, 2083, 1512, 2128, 2127, 1485, 1067) AND (p.available = 1 OR p.price > 0.0)
ORDER BY cg.ordering
416μs544B/components/com_djcatalog2/models/items.php:1245CopySELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM z2pdg_djc2_items as i
INNER JOIN z2pdg_djc2_images as img on img.id=(select id from z2pdg_djc2_images where type='item' and item_id=i.id order by ordering asc limit 1)
WHERE i.id IN (2060,2458,2081,2080,1687,1528,2120,2129,2073,2070,1547,1698,2072,2085,2083,1512,2128,2127,1485,1067)
699μs11.34KB/components/com_djcatalog2/models/items.php:1353CopySELECT c.* FROM z2pdg_djc2_categories AS c WHERE c.published=1 AND c.access IN (1,5) AND (c.language = 'nl-NL' OR c.language = '*') ORDER BY c.parent_id ASC, c.ordering ASC
875μs1.31KB/administrator/components/com_djcatalog2/lib/categories.php:355CopySELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM z2pdg_djc2_categories as i
INNER JOIN z2pdg_djc2_images as img on img.id=(select id from z2pdg_djc2_images where type='category' and item_id=i.id order by ordering asc limit 1)
WHERE (i.language = 'nl-NL' OR i.language = '*')
742μs352B/administrator/components/com_djcatalog2/lib/categories.php:368CopySELECT *
FROM z2pdg_djc2_price_rules
WHERE published=1 AND (start_date IS NULL OR start_date = '0000-00-00 00:00:00' OR start_date <= '2025-05-03 13:32:33') AND (expire_date IS NULL OR expire_date = '0000-00-00 00:00:00' OR expire_date >= '2025-05-03 13:32:33')
ORDER BY ordering
789μs2.14KB/components/com_djcatalog2/helpers/price.php:703CopySELECT c.* FROM z2pdg_djc2_categories AS c WHERE c.published=1 AND (c.language = 'nl-NL' OR c.language = '*') ORDER BY c.parent_id ASC, c.ordering ASC
4.77ms1.31KB/administrator/components/com_djcatalog2/lib/categories.php:355CopySELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM z2pdg_djc2_categories as i
INNER JOIN z2pdg_djc2_images as img on img.id=(select id from z2pdg_djc2_images where type='category' and item_id=i.id order by ordering asc limit 1)
WHERE (i.language = 'nl-NL' OR i.language = '*')
1.73ms352B/administrator/components/com_djcatalog2/lib/categories.php:368CopySELECT DISTINCT a.id, a.name as text FROM z2pdg_djc2_producers as a INNER JOIN z2pdg_djc2_items AS i ON a.id = i.producer_id AND i.published = 1 INNER JOIN z2pdg_djc2_items_categories AS c ON c.item_id = i.id WHERE c.category_id IN (86) AND a.published=1 AND (a.language = 'nl-NL' OR a.language = '*') GROUP BY a.id, a.name ORDER BY a.ordering asc
2.12ms128B/components/com_djcatalog2/models/items.php:1435CopySELECT count(table_a.id) as count_a, count(table_b.id) as count_b, count(table_c.id) as count_c, count(table_d.id) as count_d, count(table_e.id) as count_e, count(table_f.id) as count_f, count(table_g.id) as count_g, count(table_h.id) as count_h, count(table_i.id) as count_i, count(table_j.id) as count_j, count(table_k.id) as count_k, count(table_l.id) as count_l, count(table_m.id) as count_m, count(table_n.id) as count_n, count(table_o.id) as count_o, count(table_p.id) as count_p, count(table_q.id) as count_q, count(table_r.id) as count_r, count(table_s.id) as count_s, count(table_t.id) as count_t, count(table_u.id) as count_u, count(table_v.id) as count_v, count(table_w.id) as count_w, count(table_x.id) as count_x, count(table_y.id) as count_y, count(table_z.id) as count_z
FROM z2pdg_djc2_items as items
left join z2pdg_djc2_items as table_a on table_a.id = items.id and lower(table_a.name) like 'a%'
left join z2pdg_djc2_items as table_b on table_b.id = items.id and lower(table_b.name) like 'b%'
left join z2pdg_djc2_items as table_c on table_c.id = items.id and lower(table_c.name) like 'c%'
left join z2pdg_djc2_items as table_d on table_d.id = items.id and lower(table_d.name) like 'd%'
left join z2pdg_djc2_items as table_e on table_e.id = items.id and lower(table_e.name) like 'e%'
left join z2pdg_djc2_items as table_f on table_f.id = items.id and lower(table_f.name) like 'f%'
left join z2pdg_djc2_items as table_g on table_g.id = items.id and lower(table_g.name) like 'g%'
left join z2pdg_djc2_items as table_h on table_h.id = items.id and lower(table_h.name) like 'h%'
left join z2pdg_djc2_items as table_i on table_i.id = items.id and lower(table_i.name) like 'i%'
left join z2pdg_djc2_items as table_j on table_j.id = items.id and lower(table_j.name) like 'j%'
left join z2pdg_djc2_items as table_k on table_k.id = items.id and lower(table_k.name) like 'k%'
left join z2pdg_djc2_items as table_l on table_l.id = items.id and lower(table_l.name) like 'l%'
left join z2pdg_djc2_items as table_m on table_m.id = items.id and lower(table_m.name) like 'm%'
left join z2pdg_djc2_items as table_n on table_n.id = items.id and lower(table_n.name) like 'n%'
left join z2pdg_djc2_items as table_o on table_o.id = items.id and lower(table_o.name) like 'o%'
left join z2pdg_djc2_items as table_p on table_p.id = items.id and lower(table_p.name) like 'p%'
left join z2pdg_djc2_items as table_q on table_q.id = items.id and lower(table_q.name) like 'q%'
left join z2pdg_djc2_items as table_r on table_r.id = items.id and lower(table_r.name) like 'r%'
left join z2pdg_djc2_items as table_s on table_s.id = items.id and lower(table_s.name) like 's%'
left join z2pdg_djc2_items as table_t on table_t.id = items.id and lower(table_t.name) like 't%'
left join z2pdg_djc2_items as table_u on table_u.id = items.id and lower(table_u.name) like 'u%'
left join z2pdg_djc2_items as table_v on table_v.id = items.id and lower(table_v.name) like 'v%'
left join z2pdg_djc2_items as table_w on table_w.id = items.id and lower(table_w.name) like 'w%'
left join z2pdg_djc2_items as table_x on table_x.id = items.id and lower(table_x.name) like 'x%'
left join z2pdg_djc2_items as table_y on table_y.id = items.id and lower(table_y.name) like 'y%'
left join z2pdg_djc2_items as table_z on table_z.id = items.id and lower(table_z.name) like 'z%' where items.id in (
SELECT distinct i.id
FROM z2pdg_djc2_items as i
INNER JOIN (SELECT ic.item_id FROM z2pdg_djc2_items_categories AS ic INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id WHERE c.published = 1 AND c.access IN (1,5) AND ic.category_id IN (86)) as category_filter ON i.id = category_filter.item_id
LEFT JOIN z2pdg_djc2_categories AS c ON c.id = i.cat_id
LEFT JOIN z2pdg_djc2_producers AS p ON p.id = i.producer_id
LEFT JOIN z2pdg_users AS ua ON ua.id = i.created_by
LEFT JOIN z2pdg_djc2_prices AS gc ON gc.item_id = i.id AND gc.group_id=0
LEFT JOIN z2pdg_djc2_countries AS countries ON countries.id = i.country
LEFT JOIN z2pdg_djc2_item_rating AS v ON i.id = v.item_id
LEFT JOIN z2pdg_djc2_countries_states AS states ON states.id = i.state
WHERE (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33') AND i.published = 1 AND i.access IN (1,5) AND i.parent_id=0 AND (i.language = 'nl-NL' OR i.language = '*')
ORDER BY i.id asc)
14.58ms1.69KB/components/com_djcatalog2/models/items.php:1639CopySELECT f.*, group_concat(fo.id separator '|') as options
FROM z2pdg_djc2_items_extra_fields as f
LEFT JOIN z2pdg_djc2_items_extra_fields_options as fo ON fo.field_id=f.id
WHERE f.published = 1
GROUP BY f.id
ORDER BY f.group_id asc, f.ordering asc
2.03ms1.56KB/plugins/djcatalog2/customfield/customfield.php:41CopySELECT f.*, g.name as group_name, g.label as group_label, g.id as fgroup_id
FROM z2pdg_djc2_items_extra_fields as f
LEFT JOIN z2pdg_djc2_items_extra_fields_groups as g ON g.id=f.group_id
WHERE (f.visibility = 2 or f.visibility = 3) and f.published = 1
ORDER BY IFNULL(g.ordering,0) asc, g.ordering asc, f.ordering asc
1.25ms1.65KB/components/com_djcatalog2/models/items.php:1110CopySELECT f.*
FROM z2pdg_djc2_items_extra_fields as f
INNER JOIN z2pdg_djc2_items_groups as i on i.group_id = f.group_id
INNER JOIN (
SELECT distinct i.id
FROM z2pdg_djc2_items as i
INNER JOIN (SELECT ic.item_id FROM z2pdg_djc2_items_categories AS ic INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id WHERE c.published = 1 AND c.access IN (1,5) AND ic.category_id IN (86)) as category_filter ON i.id = category_filter.item_id
LEFT JOIN z2pdg_djc2_categories AS c ON c.id = i.cat_id
LEFT JOIN z2pdg_djc2_producers AS p ON p.id = i.producer_id
LEFT JOIN z2pdg_users AS ua ON ua.id = i.created_by
LEFT JOIN z2pdg_djc2_prices AS gc ON gc.item_id = i.id AND gc.group_id=0
LEFT JOIN z2pdg_djc2_countries AS countries ON countries.id = i.country
LEFT JOIN z2pdg_djc2_item_rating AS v ON i.id = v.item_id
LEFT JOIN z2pdg_djc2_countries_states AS states ON states.id = i.state
WHERE (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33') AND i.published = 1 AND i.access IN (1,5) AND i.parent_id=0 AND (i.language = 'nl-NL' OR i.language = '*')
ORDER BY i.id asc) as iq on iq.id = i.item_id
WHERE (f.visibility = 2 or f.visibility = 3) and f.published = 1 and f.separate_column = 1
GROUP BY f.name, f.alias, f.id, f.group_id
ORDER BY f.group_id asc, f.ordering asc
3.77ms1.53KB/components/com_djcatalog2/models/items.php:1693CopySELECT f.*
FROM z2pdg_djc2_items_extra_fields as f
INNER JOIN z2pdg_djc2_items_groups as i on i.group_id = f.group_id
INNER JOIN (
SELECT distinct i.id
FROM z2pdg_djc2_items as i
INNER JOIN (SELECT ic.item_id FROM z2pdg_djc2_items_categories AS ic INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id WHERE c.published = 1 AND c.access IN (1,5) AND ic.category_id IN (86)) as category_filter ON i.id = category_filter.item_id
LEFT JOIN z2pdg_djc2_categories AS c ON c.id = i.cat_id
LEFT JOIN z2pdg_djc2_producers AS p ON p.id = i.producer_id
LEFT JOIN z2pdg_users AS ua ON ua.id = i.created_by
LEFT JOIN z2pdg_djc2_prices AS gc ON gc.item_id = i.id AND gc.group_id=0
LEFT JOIN z2pdg_djc2_countries AS countries ON countries.id = i.country
LEFT JOIN z2pdg_djc2_item_rating AS v ON i.id = v.item_id
LEFT JOIN z2pdg_djc2_countries_states AS states ON states.id = i.state
WHERE (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33') AND i.published = 1 AND i.access IN (1,5) AND i.parent_id=0 AND (i.language = 'nl-NL' OR i.language = '*')
ORDER BY i.id asc) as iq on iq.id = i.item_id
WHERE f.published = 1 and f.sortable = 1 and (f.type = 'text' OR f.type = 'radio' OR f.type = 'select' OR f.type = 'calendar')
GROUP BY f.name, f.alias, f.id, f.group_id
ORDER BY f.group_id asc, f.ordering asc
3.89ms1.53KB/components/com_djcatalog2/models/items.php:1733CopySELECT c.* FROM z2pdg_djc2_categories AS c WHERE c.published=1 AND c.access IN (1,5) ORDER BY c.parent_id ASC, c.ordering ASC
1.82ms1.31KB/administrator/components/com_djcatalog2/lib/categories.php:355CopySELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM z2pdg_djc2_categories as i
INNER JOIN z2pdg_djc2_images as img on img.id=(select id from z2pdg_djc2_images where type='category' and item_id=i.id order by ordering asc limit 1)
1.05ms352B/administrator/components/com_djcatalog2/lib/categories.php:368CopySELECT * FROM z2pdg_djc2_images WHERE item_id=86 AND type='category' AND exclude=0 ORDER BY ordering ASC, name ASC
586μs760B/administrator/components/com_djcatalog2/helpers/image.php:80CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `z2pdg_modules` AS `m`
LEFT JOIN `z2pdg_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `z2pdg_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id`
WHERE
(
(
(`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND
(`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0)
ORDER BY `m`.`position`,`m`.`ordering`
2.56ms2.64KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT f.*, g.name as group_name, g.label as group_label
FROM z2pdg_djc2_items_extra_fields as f
LEFT JOIN z2pdg_djc2_items_extra_fields_groups as g ON g.id=f.group_id
WHERE f.published = 1 and f.filterable = 1 and (f.type = 'checkbox' or f.type = 'radio' or f.type = 'select' or f.type = 'text' or f.type = 'color' or f.type = 'multicolor' or f.type = 'multiselect') and (g.id in (3)) and f.id in (26,27)
GROUP BY f.id
ORDER BY IFNULL(g.ordering,0) asc, g.ordering asc, f.ordering asc
1.26ms1.61KB/modules/mod_djc2filters/helper.php:165Copyselect id, producer_id from z2pdg_djc2_items where published=1
7.09ms136B/components/com_djcatalog2/helpers/route.php:73CopySELECT *
FROM `z2pdg_sppagebuilder`
WHERE `extension` = 'mod_sppagebuilder' AND `extension_view` = 'module' AND `view_id` = '164'
2.75ms1.84KB/modules/mod_sppagebuilder/helper.php:49CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `z2pdg_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
892μs144B/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:123CopySELECT `template`
FROM `z2pdg_template_styles`
WHERE `client_id` = 0 AND `home` = 1
1.44ms72B/components/com_sppagebuilder/builder/classes/base.php:85CopySELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id
FROM (
SELECT id,title,level,published,parent_id,lft,rgt
FROM z2pdg_tags
WHERE `published` = '1') AS a
LEFT JOIN `z2pdg_tags` AS b ON a.lft > b.lft AND a.rgt < b.rgt
WHERE `a`.`level` != '0'
ORDER BY a.lft ASC
2.14ms400B/components/com_sppagebuilder/builder/classes/base.php:326CopySELECT a.enabled
FROM `z2pdg_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'
1.17ms64B/components/com_sppagebuilder/builder/classes/base.php:872CopySELECT a.enabled
FROM `z2pdg_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'
1.05ms64B/components/com_sppagebuilder/builder/classes/base.php:872CopySELECT a.enabled
FROM `z2pdg_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'
1.2ms64B/components/com_sppagebuilder/builder/classes/base.php:872CopySELECT a.enabled
FROM `z2pdg_extensions` AS `a`
WHERE (`a`.`element` = 'com_acymailing' OR `a`.`element` = 'com_acym')
1.19ms64B/components/com_sppagebuilder/builder/classes/base.php:776CopySELECT `e`.`manifest_cache`
FROM `z2pdg_extensions` AS `e`
WHERE e.element = 'com_acymailing' OR e.element = 'com_acym'
818μs72B/components/com_sppagebuilder/builder/classes/base.php:849CopySELECT `id`,`name`
FROM `z2pdg_acym_list`
WHERE `active` = '1'
ORDER BY name DESC
2.03ms128B/components/com_sppagebuilder/builder/classes/base.php:798CopySELECT `template`
FROM `z2pdg_template_styles`
WHERE `client_id` = 0 AND `home` = 1
897μs72B/components/com_sppagebuilder/builder/classes/base.php:85CopySELECT f.*, g.name as group_name, g.label as group_label
FROM z2pdg_djc2_items_extra_fields as f
LEFT JOIN z2pdg_djc2_items_extra_fields_groups as g ON g.id=f.group_id
WHERE f.published = 1 and f.filterable = 1 and (f.type = 'checkbox' or f.type = 'radio' or f.type = 'select' or f.type = 'text' or f.type = 'color' or f.type = 'multicolor' or f.type = 'multiselect') and (g.id in (4))
GROUP BY f.id
ORDER BY IFNULL(g.ordering,0) asc, g.ordering asc, f.ordering asc
1.62ms1.61KB/modules/mod_djc2filters/helper.php:165CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (36)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
1.49ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (105)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
810μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (12)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
1.74ms8.08KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (107)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
771μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (20,70,69)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
1.08ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (8)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
1.11ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (46)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
725μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (83)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
507μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (49,91)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
1.04ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (16)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
819μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (21,74)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
902μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (13,67,92,11)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
4.87ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (47)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
1.7ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (18)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
1.07ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (84)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
1.03ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (9,101,100,96)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
1.54ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (3,72,73,71,106)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
1.24ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (102)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
1.98ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (97)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
1.81ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (2,59,104,80,60,61,62,98,103,81,63,76,64,66,109,65,77)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
7.51ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (90,93)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
1.56ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (48)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
831μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (41)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
985μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (19,53,51,54,50,52)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
1.26ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (14)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
727μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (15)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
1.27ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (85)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
1.04ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (78)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
910μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (79)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
632μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (17,55,56,57,58)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
1.04ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (10)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
684μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (99)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
526μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (86)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
861μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (42)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
520μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (75)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
453μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (87)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
523μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (89)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
485μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (68)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
479μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (108)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
577μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (82)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
533μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (88)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
480μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (110)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33')
488μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT p.* FROM z2pdg_djc2_producers as p WHERE (p.language = 'nl-NL' OR p.language = '*') AND p.published=1 ORDER BY p.ordering asc
1.03ms1.05KB/modules/mod_djc2producers/helper.php:51CopySELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM z2pdg_djc2_producers as i
INNER JOIN z2pdg_djc2_images as img on img.id=(select id from z2pdg_djc2_images where type='producer' and item_id=i.id order by ordering asc limit 1)
1.18ms352B/modules/mod_djc2producers/helper.php:60CopySELECT f.*, g.name as group_name, g.label as group_label
FROM z2pdg_djc2_items_extra_fields as f
LEFT JOIN z2pdg_djc2_items_extra_fields_groups as g ON g.id=f.group_id
WHERE f.published = 1 and f.filterable = 1 and (f.type = 'checkbox' or f.type = 'radio' or f.type = 'select' or f.type = 'text' or f.type = 'color' or f.type = 'multicolor' or f.type = 'multiselect') and f.id in (7,11,32)
GROUP BY f.id
ORDER BY IFNULL(g.ordering,0) asc, g.ordering asc, f.ordering asc
1.82ms1.61KB/modules/mod_djc2filters/helper.php:165CopySELECT *
FROM z2pdg_djc2_items_extra_fields_options
WHERE field_id in (7,11,32)
ORDER BY field_id asc, ordering asc
1.69ms336B/modules/mod_djc2filters/helper.php:175CopySELECT distinct *
FROM z2pdg_djc2_items_extra_fields_values_text
WHERE field_id in (7,11,32)
ORDER BY field_id asc, value asc
10.95ms264B/modules/mod_djc2filters/helper.php:184CopySELECT ef.id as field_id, ef.name as field_name, opt.id as option_id, opt.value as option_value, count(fv.item_id) as item_count
FROM z2pdg_djc2_items_extra_fields_values_int as fv
INNER JOIN z2pdg_djc2_items_extra_fields as ef on ef.id=fv.field_id
INNER JOIN z2pdg_djc2_items_extra_fields_options as opt on opt.field_id=ef.id and opt.id=fv.value
INNER JOIN (
SELECT distinct i.id
FROM z2pdg_djc2_items as i
INNER JOIN (SELECT ic.item_id FROM z2pdg_djc2_items_categories AS ic INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id WHERE c.published = 1 AND c.access IN (1,5) AND ic.category_id IN (86)) as category_filter ON i.id = category_filter.item_id
LEFT JOIN z2pdg_djc2_categories AS c ON c.id = i.cat_id
LEFT JOIN z2pdg_djc2_producers AS p ON p.id = i.producer_id
LEFT JOIN z2pdg_users AS ua ON ua.id = i.created_by
LEFT JOIN z2pdg_djc2_prices AS gc ON gc.item_id = i.id AND gc.group_id=0
LEFT JOIN z2pdg_djc2_countries AS countries ON countries.id = i.country
LEFT JOIN z2pdg_djc2_item_rating AS v ON i.id = v.item_id
LEFT JOIN z2pdg_djc2_countries_states AS states ON states.id = i.state
WHERE (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33') AND i.published = 1 AND i.access IN (1,5) AND i.parent_id=0 AND (i.language = 'nl-NL' OR i.language = '*')
ORDER BY i.id desc) as item_ids on fv.item_id = item_ids.id
WHERE ef.id = 7
GROUP BY ef.id, opt.value
ORDER BY ef.name asc
5.42ms360B/modules/mod_djc2filters/helper.php:287CopySELECT ef.id as field_id, ef.name as field_name, opt.id as option_id, opt.value as option_value, count(fv.item_id) as item_count
FROM z2pdg_djc2_items_extra_fields_values_int as fv
INNER JOIN z2pdg_djc2_items_extra_fields as ef on ef.id=fv.field_id
INNER JOIN z2pdg_djc2_items_extra_fields_options as opt on opt.field_id=ef.id and opt.id=fv.value
INNER JOIN (
SELECT distinct i.id
FROM z2pdg_djc2_items as i
INNER JOIN (SELECT ic.item_id FROM z2pdg_djc2_items_categories AS ic INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id WHERE c.published = 1 AND c.access IN (1,5) AND ic.category_id IN (86)) as category_filter ON i.id = category_filter.item_id
LEFT JOIN z2pdg_djc2_categories AS c ON c.id = i.cat_id
LEFT JOIN z2pdg_djc2_producers AS p ON p.id = i.producer_id
LEFT JOIN z2pdg_users AS ua ON ua.id = i.created_by
LEFT JOIN z2pdg_djc2_prices AS gc ON gc.item_id = i.id AND gc.group_id=0
LEFT JOIN z2pdg_djc2_countries AS countries ON countries.id = i.country
LEFT JOIN z2pdg_djc2_item_rating AS v ON i.id = v.item_id
LEFT JOIN z2pdg_djc2_countries_states AS states ON states.id = i.state
WHERE (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33') AND i.published = 1 AND i.access IN (1,5) AND i.parent_id=0 AND (i.language = 'nl-NL' OR i.language = '*')
ORDER BY i.id desc) as item_ids on fv.item_id = item_ids.id
WHERE ef.id = 11
GROUP BY ef.id, opt.value
ORDER BY ef.name asc
1.97ms360B/modules/mod_djc2filters/helper.php:287CopySELECT ef.id as field_id, ef.name as field_name, opt.id as option_id, opt.value as option_value, count(fv.item_id) as item_count
FROM z2pdg_djc2_items_extra_fields_values_int as fv
INNER JOIN z2pdg_djc2_items_extra_fields as ef on ef.id=fv.field_id
INNER JOIN z2pdg_djc2_items_extra_fields_options as opt on opt.field_id=ef.id and opt.id=fv.value
INNER JOIN (
SELECT distinct i.id
FROM z2pdg_djc2_items as i
INNER JOIN (SELECT ic.item_id FROM z2pdg_djc2_items_categories AS ic INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id WHERE c.published = 1 AND c.access IN (1,5) AND ic.category_id IN (86)) as category_filter ON i.id = category_filter.item_id
LEFT JOIN z2pdg_djc2_categories AS c ON c.id = i.cat_id
LEFT JOIN z2pdg_djc2_producers AS p ON p.id = i.producer_id
LEFT JOIN z2pdg_users AS ua ON ua.id = i.created_by
LEFT JOIN z2pdg_djc2_prices AS gc ON gc.item_id = i.id AND gc.group_id=0
LEFT JOIN z2pdg_djc2_countries AS countries ON countries.id = i.country
LEFT JOIN z2pdg_djc2_item_rating AS v ON i.id = v.item_id
LEFT JOIN z2pdg_djc2_countries_states AS states ON states.id = i.state
WHERE (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-03 13:32:33') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-03 13:32:33') AND i.published = 1 AND i.access IN (1,5) AND i.parent_id=0 AND (i.language = 'nl-NL' OR i.language = '*')
ORDER BY i.id desc) as item_ids on fv.item_id = item_ids.id
WHERE ef.id = 32
GROUP BY ef.id, opt.value
ORDER BY ef.name asc
4.9ms360B/modules/mod_djc2filters/helper.php:287CopySELECT * FROM z2pdg_acym_configuration
1.59ms128B/administrator/components/com_acym/Core/joomla/database.php:36CopySELECT * FROM z2pdg_acym_list WHERE type = 'standard'
983μs1.34KB/administrator/components/com_acym/Core/joomla/database.php:36CopySELECT * FROM z2pdg_acym_field
827μs1.08KB/administrator/components/com_acym/Core/joomla/database.php:36CopySELECT * FROM z2pdg_acym_form WHERE active = 1 AND type != 'shortcode'
673μs544B/administrator/components/com_acym/Core/joomla/database.php:36CopySELECT 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 `z2pdg_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
918μs1.18KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517CopySELECT `value` FROM z2pdg_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"
2.02ms64B/plugins/system/acymtriggers/acymtriggers.php:436CopySHOW TABLES
3.33ms80B/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php:513CopySELECT * FROM z2pdg_acym_plugin
879μs816B/administrator/components/com_acym/Core/joomla/database.php:36CopySELECT * FROM z2pdg_acym_plugin
662μs816B/administrator/components/com_acym/Core/joomla/database.php:36CopySELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value`
FROM z2pdg_usergroups AS `groups`
996μs456B/administrator/components/com_acym/Core/joomla/database.php:36CopyLOCK TABLES `z2pdg_extensions` WRITE
534μs8BCopyUPDATE `z2pdg_extensions`
SET `params` = :params
WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'updatenotification'
924μs976BParamsCopyUNLOCK TABLES
488μs8BCopySELECT *
FROM `z2pdg_extensions`
WHERE `element` = :element AND `type` = :type LIMIT 1
681μs2.35KBParams/libraries/src/Extension/ExtensionHelper.php:493CopySELECT DISTINCT `a`.`update_site_id`,`a`.`type`,`a`.`location`,`a`.`last_check_timestamp`,`a`.`extra_query`
FROM `z2pdg_update_sites` AS `a`
INNER JOIN `z2pdg_update_sites_extensions` AS `b` ON `a`.`update_site_id` = `b`.`update_site_id`
WHERE `a`.`enabled` = 1 AND `b`.`extension_id` IN (:preparedArray1)
1.78ms1.46KBParams/libraries/src/Updater/Updater.php:228CopySELECT DISTINCT `update_site_id`
FROM `z2pdg_updates`
WHERE `update_site_id` IN (
SELECT `update_site_id`
FROM `z2pdg_update_sites`
WHERE `last_check_timestamp` IS NULL OR `last_check_timestamp` <= :timestamp)
647μs1.09KBParams/libraries/src/Updater/Updater.php:394CopyDELETE
FROM `z2pdg_updates`
WHERE `update_site_id` = :id
291μs16.86KBParamsCopySELECT `name`
FROM `z2pdg_update_sites`
WHERE `update_site_id` = :id
495μs952BParams/libraries/src/Updater/UpdateAdapter.php:196CopyUPDATE `z2pdg_update_sites`
SET `enabled` = :enabled
WHERE `update_site_id` = :id
742μs1.01KBParamsCopyUPDATE `z2pdg_update_sites`
SET `enabled` = :enabled
WHERE `update_site_id` = :id
573μs1.01KBParamsCopySHOW FULL COLUMNS FROM `z2pdg_updates`
989μs624B/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php:460CopySHOW FULL COLUMNS FROM `z2pdg_extensions`
1.16ms624B/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php:460CopySELECT `update_id`
FROM `z2pdg_updates`
WHERE element = 'joomla' AND type = 'file' AND client_id = '0' AND folder = ''
502μs72B/libraries/src/Table/Update.php:107CopySELECT `extension_id`
FROM `z2pdg_extensions`
WHERE element = 'joomla' AND type = 'file' AND client_id = '0' AND folder = ''
790μs72B/libraries/src/Table/Extension.php:115CopySELECT *
FROM `z2pdg_extensions`
WHERE `extension_id` = '700'
460μs1.34KB/libraries/src/Table/Table.php:755CopySELECT `update_id`
FROM `z2pdg_updates`
WHERE element = 'joomla' AND type = 'file' AND client_id = '0' AND folder = ''
475μs72B/libraries/src/Table/Update.php:107CopySELECT `extension_id`
FROM `z2pdg_extensions`
WHERE element = 'joomla' AND type = 'file' AND client_id = '0' AND folder = ''
612μs72B/libraries/src/Table/Extension.php:115CopySELECT *
FROM `z2pdg_extensions`
WHERE `extension_id` = '700'
352μs1.34KB/libraries/src/Table/Table.php:755CopySHOW FULL COLUMNS FROM `z2pdg_updates`
1.13ms624B/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php:460CopyINSERT INTO `z2pdg_updates`
(`update_site_id`,`extension_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`changelogurl`,`extra_query`) VALUES
('1','700','Joomla','','joomla','file','','0','5.3.0','','https://update.joomla.org/core/j4/next.xml','','','')
413μs8BCopyUPDATE `z2pdg_update_sites`
SET `last_check_timestamp` = :timestamp
WHERE `update_site_id` = :id
377μs1.02KBParamsCopySELECT u.*,`e`.`manifest_cache`
FROM `z2pdg_updates` AS `u`
LEFT JOIN `z2pdg_extensions` AS `e` ON `e`.`extension_id` = `u`.`extension_id`
WHERE `u`.`extension_id` != 0 AND `u`.`extension_id` = :extensionid
ORDER BY `u`.`name` asc
776μs2.12KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySHOW FULL COLUMNS FROM `z2pdg_assets`
1.04ms624B/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php:460CopySELECT id
FROM z2pdg_assets
WHERE parent_id = 0
870μs64B/libraries/src/Table/Nested.php:1158CopySELECT `user_id`
FROM `z2pdg_user_usergroup_map`
WHERE `group_id` IN (:preparedArray1)
665μs976BParams/plugins/system/updatenotification/src/Extension/UpdateNotification.php:314CopySELECT `id`,`username`,`email`
FROM `z2pdg_users`
WHERE `id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7) AND `block` = 0 AND `sendEmail` = 1
818μs1.95KBParams/plugins/system/updatenotification/src/Extension/UpdateNotification.php:338CopySELECT `session_id`
FROM `z2pdg_session`
WHERE `session_id` = ?
558μs960BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyUPDATE `z2pdg_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
389μs1.8KBParamsCopy