Boekstatus

Filter

« vorige
pitol

Zoeken in onze boeken

Sergio Pitol - Het defilé van de liefde

Categorie: Spaanse/Latijns-Amerikaanse literatuur
Boekstatus: Licht beschadigd

Delfina Uribe verzamelt een kring van kunstenaars en intellectuelen om zich heen. Haar woning wordt beschouwd als een broeinest van revolutionaire corruptie: zware juwelen, gemakkelijk verdiend geld, lichtzinnige spelen.

Als de Oostenrijkse vluchteling Erich Maria Pistauer op een avond in 1942 dood in haar huis wordt aangetroffen, beweert zij hem nooit te hebben gekend. Alleen de tienjarige Miguel slaat de moord in zijn geheugen op en keert na tientallen jaren in het buitenland naar Mexico terug om de waarheid, die intussen geschiedenis geworden is, te achterhalen. Daarmee betreedt hij een onoverzichtelijk labyrint. Is het een uit de hand gelopen ruzie geweest, een afrekening in het criminele milieu, een wilde actie in de kring van Mexicaanse nazi-collaborateurs? Of een passiemoord die koste wat kost verzwegen moest worden, omwille van het fatsoen?

Net als in Het geluk getrouwd te zijn, slaagt Sergio Pitol erin, zijn personages uit te rusten met een charmant talent voor liegen, wat het onderzoek naar de dode aanzienlijk bemoeilijkt, maar de lezer een groot genoegen bereidt.

Auteur Sergio Pitol
ISBN/ EAN 9789059360501
Bindwijze Hardback
Pagina's 287
Uitgever Cossee
Verschijningsdatum 2005
Taal Nederlands
Reserveer dit boek
« vorige
J! InfoRequestSessionProfileQueries163Log
45.135MBMemory Usage626msRequest Duration
Joomla! Version4.4.14
PHP Version8.1.33
Identityguest
Response200
Templateflex
Database
Server
mysql
Version
10.6.23-MariaDB-cll-lve
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:66 [ "PATH" => "/usr/local/bin:/usr/bin:/bin" "TEMP" => "/tmp" "TMP" => "/tmp" "TMPDIR...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1762454365 "last" => 1762454365...
registry
array:3 [ "data" => array:1 [ "com_djcatalog2" => array:1 [ "items" => array:1 [ ...
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (4.05MB) (57.45ms)
  • afterInitialise (14.23MB) (137ms)
  • afterRoute (845.57KB) (10.39ms)
  • beforeRenderComponent com_djcatalog2 (1.17MB) (14.26ms)
  • Before Access::preloadComponents (all components) (3.98MB) (33.38ms)
  • After Access::preloadComponents (all components) (130.99KB) (1.12ms)
  • Before Access::getAssetRules (id:166 name:com_djcatalog2) (3.65KB) (20μs)
  • After Access::getAssetRules (id:166 name:com_djcatalog2) (90.24KB) (344μs)
  • Before Access::getAssetRules (id:1 name:root.1) (2.95MB) (38.66ms)
  • After Access::getAssetRules (id:1 name:root.1) (2.22KB) (11μs)
  • afterRenderComponent com_djcatalog2 (1.05MB) (30.43ms)
  • afterDispatch (2.28KB) (138μs)
  • beforeRenderRawModule mod_search (Search) (1.04MB) (44.13ms)
  • afterRenderRawModule mod_search (Search) (50.74KB) (2.03ms)
  • beforeRenderModule mod_search (Search) (704B) (6μs)
  • afterRenderModule mod_search (Search) (3.78KB) (285μs)
  • beforeRenderRawModule mod_menu (Main Menu) (552B) (23μs)
  • afterRenderRawModule mod_menu (Main Menu) (48.57KB) (2.4ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (6μs)
  • afterRenderModule mod_menu (Main Menu) (2.65KB) (183μs)
  • beforeRenderRawModule mod_sppagebuilder (Contact Footer Ramsjgat) (2.02KB) (41μs)
  • afterRenderRawModule mod_sppagebuilder (Contact Footer Ramsjgat) (7.84MB) (121ms)
  • beforeRenderModule mod_sppagebuilder (Contact Footer Ramsjgat) (736B) (13μs)
  • afterRenderModule mod_sppagebuilder (Contact Footer Ramsjgat) (17.96KB) (247μs)
  • beforeRenderRawModule mod_djc2filters (Filtert) (3.47KB) (91μs)
  • afterRenderRawModule mod_djc2filters (Filtert) (86.48KB) (2.72ms)
  • beforeRenderModule mod_djc2filters (Filtert) (720B) (8μs)
  • afterRenderModule mod_djc2filters (Filtert) (1.3KB) (196μs)
  • beforeRenderRawModule mod_custom (Nieuwe Boeken 40%) (3.13KB) (30μs)
  • afterRenderRawModule mod_custom (Nieuwe Boeken 40%) (14.63KB) (1.28ms)
  • beforeRenderModule mod_custom (Nieuwe Boeken 40%) (720B) (7μs)
  • afterRenderModule mod_custom (Nieuwe Boeken 40%) (2.15KB) (241μs)
  • beforeRenderRawModule mod_djc2categories (Onze Rubrieken) (488B) (29μs)
  • afterRenderRawModule mod_djc2categories (Onze Rubrieken) (749.54KB) (49.84ms)
  • beforeRenderModule mod_djc2categories (Onze Rubrieken) (720B) (9μs)
  • afterRenderModule mod_djc2categories (Onze Rubrieken) (2.06KB) (175μs)
  • beforeRenderRawModule mod_djc2producers (Boekstatus) (14.44KB) (36μs)
  • afterRenderRawModule mod_djc2producers (Boekstatus) (117.57KB) (2.86ms)
  • beforeRenderModule mod_djc2producers (Boekstatus) (720B) (6μs)
  • afterRenderModule mod_djc2producers (Boekstatus) (3.16KB) (208μs)
  • beforeRenderRawModule mod_djc2filters (Filteren op:) (3.34KB) (28μs)
  • afterRenderRawModule mod_djc2filters (Filteren op:) (811.82KB) (18.46ms)
  • beforeRenderModule mod_djc2filters (Filteren op:) (720B) (7μs)
  • afterRenderModule mod_djc2filters (Filteren op:) (5.91KB) (185μs)
  • afterRender (5.35MB) (54.79ms)
  • 1 x afterInitialise (14.23MB) (21.82%)
    136.59ms
    1 x afterRenderRawModule mod_sppagebuilder (Contact Footer Ramsjgat) (7.84MB) (19.32%)
    120.89ms
    1 x afterLoad (4.05MB) (9.18%)
    57.45ms
    1 x afterRender (5.35MB) (8.75%)
    54.79ms
    1 x afterRenderRawModule mod_djc2categories (Onze Rubrieken) (749.54KB) (7.96%)
    49.84ms
    1 x beforeRenderRawModule mod_search (Search) (1.04MB) (7.05%)
    44.13ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (2.95MB) (6.18%)
    38.66ms
    1 x Before Access::preloadComponents (all components) (3.98MB) (5.33%)
    33.38ms
    1 x afterRenderComponent com_djcatalog2 (1.05MB) (4.86%)
    30.43ms
    1 x afterRenderRawModule mod_djc2filters (Filteren op:) (811.82KB) (2.95%)
    18.46ms
    1 x beforeRenderComponent com_djcatalog2 (1.17MB) (2.28%)
    14.26ms
    1 x afterRoute (845.57KB) (1.66%)
    10.39ms
    1 x afterRenderRawModule mod_djc2producers (Boekstatus) (117.57KB) (0.46%)
    2.86ms
    1 x afterRenderRawModule mod_djc2filters (Filtert) (86.48KB) (0.43%)
    2.72ms
    1 x afterRenderRawModule mod_menu (Main Menu) (48.57KB) (0.38%)
    2.40ms
    1 x afterRenderRawModule mod_search (Search) (50.74KB) (0.32%)
    2.03ms
    1 x afterRenderRawModule mod_custom (Nieuwe Boeken 40%) (14.63KB) (0.21%)
    1.28ms
    1 x After Access::preloadComponents (all components) (130.99KB) (0.18%)
    1.12ms
    1 x After Access::getAssetRules (id:166 name:com_djcatalog2) (90.24KB) (0.05%)
    344μs
    1 x afterRenderModule mod_search (Search) (3.78KB) (0.05%)
    285μs
    1 x afterRenderModule mod_sppagebuilder (Contact Footer Ramsjgat) (17.96KB) (0.04%)
    247μs
    1 x afterRenderModule mod_custom (Nieuwe Boeken 40%) (2.15KB) (0.04%)
    241μs
    1 x afterRenderModule mod_djc2producers (Boekstatus) (3.16KB) (0.03%)
    208μs
    1 x afterRenderModule mod_djc2filters (Filtert) (1.3KB) (0.03%)
    196μs
    1 x afterRenderModule mod_djc2filters (Filteren op:) (5.91KB) (0.03%)
    185μs
    1 x afterRenderModule mod_menu (Main Menu) (2.65KB) (0.03%)
    183μs
    1 x afterRenderModule mod_djc2categories (Onze Rubrieken) (2.06KB) (0.03%)
    175μs
    1 x afterDispatch (2.28KB) (0.02%)
    138μs
    1 x beforeRenderRawModule mod_djc2filters (Filtert) (3.47KB) (0.01%)
    91μs
    1 x beforeRenderRawModule mod_sppagebuilder (Contact Footer Ramsjgat) (2.02KB) (0.01%)
    41μs
    1 x beforeRenderRawModule mod_djc2producers (Boekstatus) (14.44KB) (0.01%)
    36μs
    1 x beforeRenderRawModule mod_custom (Nieuwe Boeken 40%) (3.13KB) (0%)
    30μs
    1 x beforeRenderRawModule mod_djc2categories (Onze Rubrieken) (488B) (0%)
    29μs
    1 x beforeRenderRawModule mod_djc2filters (Filteren op:) (3.34KB) (0%)
    28μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (552B) (0%)
    23μs
    1 x Before Access::getAssetRules (id:166 name:com_djcatalog2) (3.65KB) (0%)
    20μs
    1 x beforeRenderModule mod_sppagebuilder (Contact Footer Ramsjgat) (736B) (0%)
    13μs
    1 x After Access::getAssetRules (id:1 name:root.1) (2.22KB) (0%)
    11μs
    1 x beforeRenderModule mod_djc2categories (Onze Rubrieken) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_djc2filters (Filtert) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_custom (Nieuwe Boeken 40%) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_djc2filters (Filteren op:) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_search (Search) (704B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    6μs
    1 x beforeRenderModule mod_djc2producers (Boekstatus) (720B) (0%)
    6μs
163 statements were executed, 26 of which were duplicates, 137 unique103ms4.3MB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4Duplicates 5Duplicates 6Duplicates 7Duplicates 8Duplicates 9
  • SELECT `data` FROM `z2pdg_session` WHERE `session_id` = ?310μs17.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `z2pdg_session` WHERE `session_id` = :session_id LIMIT 1249μs16.98KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `z2pdg_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)304μs1.66KBParamsCopy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `z2pdg_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1505μs48.84KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `z2pdg_viewlevels`251μs16.75KB/libraries/src/Access/Access.php:955Copy
  • SELECT `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` = :guest315μs17.03KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `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`931μs19.82KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `template` FROM `z2pdg_template_styles` WHERE `client_id` = 0 AND `home` = 1480μs16.04KB/components/com_sppagebuilder/parser/addon-parser.php:1402Copy
  • SELECT `value` FROM z2pdg_acym_configuration WHERE `name` = 'level'437μs17.29KB/plugins/system/acymtriggers/acymtriggers.php:645Copy
  • SELECT `template` FROM `z2pdg_template_styles` WHERE `client_id` = 0 AND `home` = 1321μs16.04KB/plugins/system/helix3/helix3.php:247Copy
  • SELECT `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`825μs34.56KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `z2pdg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC358μs16.48KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `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` = 1588μs96.28KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT 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 ASC976μs354.04KB/administrator/components/com_djcatalog2/lib/categories.php:355Copy
  • SELECT 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 = '*')589μs16.13KB/administrator/components/com_djcatalog2/lib/categories.php:368Copy
  • select alias from z2pdg_djc2_items_extra_fields where type='checkbox' or type='radio' or type='select'303μs16.07KB/components/com_djcatalog2/controller.php:133Copy
  • SELECT `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)973μs29.08KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT id FROM z2pdg_djc2_customer_groups WHERE (user_group IN (1,9) OR is_default=1) ORDER BY ordering DESC LIMIT 1335μs16.02KB/components/com_djcatalog2/helpers/user.php:368Copy
  • select * from z2pdg_djc2_countries where is_default=1428μs16.19KB/components/com_djcatalog2/helpers/user.php:429Copy
  • SELECT 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 ASC493μs16.19KB/components/com_djcatalog2/helpers/user.php:503Copy
  • SELECT 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,states.name as state_name,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROM z2pdg_djc2_items as i 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_countries_states AS states ON states.id = i.state LEFT JOIN z2pdg_djc2_item_rating AS v ON i.id = v.item_id WHERE i.id =3242 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26') GROUP BY i.id882μs34.98KB/components/com_djcatalog2/models/item.php:200Copy
  • SELECT c.* FROM z2pdg_djc2_categories AS c WHERE (c.language = 'nl-NL' OR c.language = '*') ORDER BY c.parent_id ASC, c.ordering ASC1.08ms354KB/administrator/components/com_djcatalog2/lib/categories.php:355Copy
  • SELECT 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 = '*')823μs16.13KB/administrator/components/com_djcatalog2/lib/categories.php:368Copy
  • SELECT category_id FROM z2pdg_djc2_items_categories WHERE item_id=3242308μs16.04KB/components/com_djcatalog2/models/item.php:570Copy
  • SELECT * FROM z2pdg_djc2_item_reviews WHERE item_id=3242 LIMIT 100272μs16.22KB/components/com_djcatalog2/models/item.php:577Copy
  • SELECT 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=3242 AND fields.cart_variant=2 AND fields.published = 1 ORDER BY fields.ordering asc, fieldoptions.ordering asc855μs16.26KB/components/com_djcatalog2/models/item.php:624Copy
  • SELECT 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=3242 AND (fields.visibility = 1 OR fields.visibility = 3) AND fields.published = 1 ORDER BY fields.ordering asc, fieldoptions.ordering asc773μs16.27KB/components/com_djcatalog2/models/item.php:626Copy
  • SELECT 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=3242 AND (fields.visibility = 1 OR fields.visibility = 3) AND fields.published = 1457μs16.25KB/components/com_djcatalog2/models/item.php:628Copy
  • SELECT 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=3242 AND (fields.visibility = 1 OR fields.visibility = 3) AND fields.published = 1 ORDER BY fields.ordering asc364μs16.19KB/components/com_djcatalog2/models/item.php:630Copy
  • SELECT 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=3242 ORDER BY l.ordering441μs16.25KB/components/com_djcatalog2/models/item.php:633Copy
  • SELECT cg.*, p.price, p.available FROM z2pdg_djc2_customer_groups AS cg INNER JOIN z2pdg_djc2_prices AS p ON p.group_id=cg.id WHERE p.item_id = 3242 AND (p.available = 1 OR p.price > 0.0) ORDER BY cg.ordering334μs16.23KB/components/com_djcatalog2/models/item.php:647Copy
  • SELECT COUNT(*) FROM z2pdg_djc2_items_combinations WHERE item_id =3242216μs16.04KB/components/com_djcatalog2/models/item.php:654Copy
  • SELECT * 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-11-06 18:39:26') AND (expire_date IS NULL OR expire_date = '0000-00-00 00:00:00' OR expire_date >= '2025-11-06 18:39:26') ORDER BY ordering299μs27.75KB/components/com_djcatalog2/helpers/price.php:703Copy
  • SELECT * FROM z2pdg_djc2_items_price_tiers WHERE item_id=3242 ORDER BY quantity ASC262μs16.08KB/components/com_djcatalog2/models/item.php:1291Copy
  • SELECT sections FROM `z2pdg_djc2_categories` WHERE `id` = 66212μs16.04KB/components/com_djcatalog2/models/item.php:309Copy
  • SELECT sections FROM `z2pdg_djc2_categories` WHERE `id` = 66221μs16.04KB/components/com_djcatalog2/models/item.php:309Copy
  • SELECT 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 ASC743μs354KB/administrator/components/com_djcatalog2/lib/categories.php:355Copy
  • SELECT 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)457μs16.13KB/administrator/components/com_djcatalog2/lib/categories.php:368Copy
  • select id, producer_id from z2pdg_djc2_items where published=12.66ms64.05KB/components/com_djcatalog2/helpers/route.php:73Copy
  • SELECT 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 asc704μs17.02KB/plugins/djcatalog2/customfield/customfield.php:41Copy
  • SELECT related_item FROM z2pdg_djc2_items_related WHERE item_id=3242233μs16.02KB/components/com_djcatalog2/models/item.php:334Copy
  • SELECT 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 = 1 or f.visibility = 3) and f.published = 1 AND (f.cart_variant = 0 OR f.cart_variant = 2) ORDER BY IFNULL(g.ordering,0) asc , g.ordering asc, f.ordering asc574μs16.86KB/components/com_djcatalog2/models/item.php:400Copy
  • SELECT * FROM z2pdg_djc2_items_extra_fields_options WHERE field_id in (29,30,7,3,11,10,21,32,12) ORDER BY field_id asc, ordering asc550μs20.13KB/components/com_djcatalog2/models/item.php:410Copy
  • SELECT sections FROM `z2pdg_djc2_categories` WHERE `id` = 66195μs16.04KB/components/com_djcatalog2/models/item.php:309Copy
  • SELECT sections FROM `z2pdg_djc2_categories` WHERE `id` = 66187μs16.04KB/components/com_djcatalog2/models/item.php:309Copy
  • SELECT c.*, gc.price as group_price FROM z2pdg_djc2_items_combinations AS c LEFT JOIN z2pdg_djc2_combination_prices AS gc ON gc.combination_id = c.id AND gc.group_id=0 WHERE item_id = 3242254μs16.31KB/components/com_djcatalog2/models/item.php:956Copy
  • SELECT 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.cart_variant=1 OR f.cart_variant=2) and f.published = 1 ORDER BY IFNULL(g.ordering,0) asc , g.ordering asc, f.ordering asc539μs16.63KB/components/com_djcatalog2/models/item.php:458Copy
  • SELECT sections FROM `z2pdg_djc2_categories` WHERE `id` = 66196μs16.04KB/components/com_djcatalog2/models/item.php:309Copy
  • SELECT c.*, gc.price as group_price FROM z2pdg_djc2_items_combinations AS c LEFT JOIN z2pdg_djc2_combination_prices AS gc ON gc.combination_id = c.id AND gc.group_id=0 WHERE item_id = 3242243μs16.31KB/components/com_djcatalog2/models/item.php:956Copy
  • SELECT ic.*, c.name, c.input_params, c.type, c.tax_rule_id, c.price_modifier FROM z2pdg_djc2_items_customisations AS ic INNER JOIN z2pdg_djc2_customisations AS c ON c.id=ic.customisation_id WHERE item_id = 3242 AND c.type='i' ORDER BY c.ordering473μs16.31KB/components/com_djcatalog2/models/item.php:1124Copy
  • SELECT c.*, id as customisation_id, 0 as item_id FROM z2pdg_djc2_customisations AS c WHERE (c.type='c' OR c.type='a') ORDER BY c.ordering227μs16.38KB/components/com_djcatalog2/models/item.php:1124Copy
  • SELECT subq.position FROM (SELECT k.*, @num := @num + 1 AS position FROM (SELECT @num := 0) AS n, (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, CASE WHEN (i.special_price > 0.0 AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price FROM z2pdg_djc2_items AS i 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 WHERE i.parent_id = 0 AND i.published = 1 AND i.access IN (1,5) AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26') AND c.published = 1 AND i.cat_id=66 ORDER BY i.name asc , i.ordering, c.ordering ) as k) as subq WHERE subq.id = 3242 ORDER BY subq.position DESC LIMIT 11.11ms16.04KB/components/com_djcatalog2/models/item.php:857Copy
  • SELECT subq.* FROM (SELECT k.*, @num := @num + 1 AS position FROM (SELECT @num := 0) AS n, (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, CASE WHEN (i.special_price > 0.0 AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price FROM z2pdg_djc2_items AS i 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 WHERE i.parent_id = 0 AND i.published = 1 AND i.access IN (1,5) AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26') AND c.published = 1 AND i.cat_id=66 ORDER BY i.name asc , i.ordering, c.ordering ) as k) as subq WHERE subq.position < 24 ORDER BY subq.position DESC LIMIT 11.02ms16.2KB/components/com_djcatalog2/models/item.php:869Copy
  • SELECT subq.* FROM (SELECT k.*, @num := @num + 1 AS position FROM (SELECT @num := 0) AS n, (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, CASE WHEN (i.special_price > 0.0 AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price FROM z2pdg_djc2_items AS i 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 WHERE i.parent_id = 0 AND i.published = 1 AND i.access IN (1,5) AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26') AND c.published = 1 AND i.cat_id=66 ORDER BY i.name asc , i.ordering, c.ordering ) as k) as subq WHERE subq.position > 24 ORDER BY subq.position ASC LIMIT 11.04ms16.19KB/components/com_djcatalog2/models/item.php:877Copy
  • SELECT 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 asc673μs16.78KB/components/com_djcatalog2/models/items.php:1110Copy
  • SELECT o.id, o.field_id FROM z2pdg_djc2_items_extra_fields_options AS o ORDER BY o.field_id asc, o.ordering asc377μs20.05KB/components/com_djcatalog2/models/items.php:1120Copy
  • SELECT 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 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 c.access IN (1,5) AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26') AND i.published = 1 AND i.access IN (1,5) AND i.parent_id=3242 AND (i.language = 'nl-NL' OR i.language = '*') ORDER BY c.parent_id asc, c.ordering asc, i.ordering asc1.57ms34.5KB/components/com_djcatalog2/models/items.php:286Copy
  • SELECT * FROM z2pdg_djc2_images WHERE item_id=3242 AND type='item' AND exclude=0 ORDER BY ordering ASC, name ASC408μs16.33KB/administrator/components/com_djcatalog2/helpers/image.php:80Copy
  • UPDATE z2pdg_djc2_items SET hits = hits + 1 WHERE id = 3242901μs56BCopy
  • SELECT `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`1.13ms18.58KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT * FROM z2pdg_djc2_videos WHERE item_id=3242 AND type='item' ORDER BY ordering ASC289μs16.31KB/administrator/components/com_djcatalog2/helpers/video.php:70Copy
  • SELECT 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 z2pdg_fields AS a LEFT JOIN `z2pdg_languages` AS l ON l.lang_code = a.language LEFT JOIN z2pdg_users AS uc ON uc.id=a.checked_out LEFT JOIN z2pdg_viewlevels AS ag ON ag.id = a.access LEFT JOIN z2pdg_users AS ua ON ua.id = a.created_user_id LEFT JOIN z2pdg_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 ASC931μs19.97KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT 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 z2pdg_fields AS a LEFT JOIN `z2pdg_languages` AS l ON l.lang_code = a.language LEFT JOIN z2pdg_users AS uc ON uc.id=a.checked_out LEFT JOIN z2pdg_viewlevels AS ag ON ag.id = a.access LEFT JOIN z2pdg_users AS ua ON ua.id = a.created_user_id LEFT JOIN z2pdg_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 ASC740μs19.61KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT 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 z2pdg_fields AS a LEFT JOIN `z2pdg_languages` AS l ON l.lang_code = a.language LEFT JOIN z2pdg_users AS uc ON uc.id=a.checked_out LEFT JOIN z2pdg_viewlevels AS ag ON ag.id = a.access LEFT JOIN z2pdg_users AS ua ON ua.id = a.created_user_id LEFT JOIN z2pdg_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 ASC713μs19.61KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM z2pdg_djc2_files WHERE item_id=3242 AND type='item' AND access IN (1,5) ORDER BY ordering ASC, name ASC315μs24.38KB/administrator/components/com_djcatalog2/helpers/file.php:76Copy
  • SELECT * FROM `z2pdg_sppagebuilder` WHERE `extension` = 'mod_sppagebuilder' AND `extension_view` = 'module' AND `view_id` = '164'1.31ms168.88KB/modules/mod_sppagebuilder/helper.php:49Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `z2pdg_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'361μs16.06KB/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:79Copy
  • SELECT enabled FROM `z2pdg_extensions` WHERE `name` = 'com_easystore'374μs16.02KB/administrator/components/com_sppagebuilder/editor/helpers/ApplicationHelper.php:138Copy
  • SELECT `template` FROM `z2pdg_template_styles` WHERE `client_id` = 0 AND `home` = 1272μs16.04KB/components/com_sppagebuilder/builder/classes/base.php:88Copy
  • SELECT 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 ASC413μs16.28KB/components/com_sppagebuilder/builder/classes/base.php:374Copy
  • SELECT a.enabled FROM `z2pdg_extensions` AS `a` WHERE `a`.`name` = 'com_k2'351μs16.02KB/components/com_sppagebuilder/builder/classes/base.php:973Copy
  • SELECT a.enabled FROM `z2pdg_extensions` AS `a` WHERE `a`.`name` = 'com_k2'315μs16.02KB/components/com_sppagebuilder/builder/classes/base.php:973Copy
  • SELECT 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 ASC357μs16.28KB/components/com_sppagebuilder/builder/classes/base.php:374Copy
  • SELECT a.enabled FROM `z2pdg_extensions` AS `a` WHERE `a`.`name` = 'com_k2'321μs16.02KB/components/com_sppagebuilder/builder/classes/base.php:973Copy
  • SELECT a.enabled FROM `z2pdg_extensions` AS `a` WHERE (`a`.`element` = 'com_acymailing' OR `a`.`element` = 'com_acym')443μs16.05KB/components/com_sppagebuilder/builder/classes/base.php:866Copy
  • SELECT `e`.`manifest_cache` FROM `z2pdg_extensions` AS `e` WHERE e.element = 'com_acymailing' OR e.element = 'com_acym'334μs16.05KB/components/com_sppagebuilder/builder/classes/base.php:945Copy
  • SELECT `id`,`name` FROM `z2pdg_acym_list` WHERE `active` = '1' ORDER BY name DESC291μs16.08KB/components/com_sppagebuilder/builder/classes/base.php:889Copy
  • SELECT `template` FROM `z2pdg_template_styles` WHERE `client_id` = 0 AND `home` = 1449μs16.04KB/components/com_sppagebuilder/builder/classes/base.php:88Copy
  • SELECT 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 asc691μs16.63KB/modules/mod_djc2filters/helper.php:165Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')610μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')477μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')1.19ms16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')523μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')666μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')813μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')532μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')432μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')831μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')594μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')528μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')1.66ms16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')568μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')422μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')430μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')680μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')628μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')471μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')527μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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,111)) 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')4.13ms16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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 (59)) 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')831μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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 (104)) 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')425μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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 (80)) 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')435μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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 (60)) 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')580μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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 (61)) 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')635μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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 (62)) 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')581μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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 (98)) 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')418μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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 (103)) 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')559μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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 (81)) 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')510μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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 (63)) 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')2.02ms16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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 (76)) 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')466μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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 (64)) 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')523μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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 (66)) 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')465μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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 (109)) 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')491μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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 (65)) 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')789μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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 (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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')438μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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 (111)) 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')417μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')1.18ms16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')540μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')530μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')733μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')493μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')445μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')869μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')600μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')423μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')702μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')491μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')409μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')837μs32.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')451μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')389μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')422μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')399μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')386μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')501μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')405μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')416μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26')383μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172Copy
  • SELECT p.* FROM z2pdg_djc2_producers as p WHERE (p.language = 'nl-NL' OR p.language = '*') AND p.published=1 ORDER BY p.ordering asc443μs16.53KB/modules/mod_djc2producers/helper.php:51Copy
  • SELECT 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)370μs16.13KB/modules/mod_djc2producers/helper.php:60Copy
  • SELECT 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 asc794μs16.67KB/modules/mod_djc2filters/helper.php:165Copy
  • SELECT * FROM z2pdg_djc2_items_extra_fields_options WHERE field_id in (7,11,32) ORDER BY field_id asc, ordering asc576μs20.13KB/modules/mod_djc2filters/helper.php:175Copy
  • SELECT distinct * FROM z2pdg_djc2_items_extra_fields_values_text WHERE field_id in (7,11,32) ORDER BY field_id asc, value asc7.69ms16.09KB/modules/mod_djc2filters/helper.php:184Copy
  • SELECT 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 ASC765μs354KB/administrator/components/com_djcatalog2/lib/categories.php:355Copy
  • SELECT 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 = '*')511μs16.13KB/administrator/components/com_djcatalog2/lib/categories.php:368Copy
  • SELECT 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 (66)) 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26') 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 item_ids on fv.item_id = item_ids.id WHERE ef.id = 7 GROUP BY ef.id, opt.value ORDER BY ef.name asc1.1ms16.2KB/modules/mod_djc2filters/helper.php:287Copy
  • SELECT 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 (66)) 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26') 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 item_ids on fv.item_id = item_ids.id WHERE ef.id = 11 GROUP BY ef.id, opt.value ORDER BY ef.name asc937μs16.34KB/modules/mod_djc2filters/helper.php:287Copy
  • SELECT 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 (66)) 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-11-06 18:39:26') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-06 18:39:26') 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 item_ids on fv.item_id = item_ids.id WHERE ef.id = 32 GROUP BY ef.id, opt.value ORDER BY ef.name asc868μs16.14KB/modules/mod_djc2filters/helper.php:287Copy
  • SELECT * FROM z2pdg_acym_configuration521μs20.05KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
  • SELECT * FROM z2pdg_acym_list WHERE type = 'standard'406μs16.55KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
  • SELECT * FROM z2pdg_acym_field305μs16.42KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
  • SELECT * FROM z2pdg_acym_form WHERE active = 1 AND type != 'shortcode'294μs16.19KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
  • SELECT params FROM `z2pdg_template_styles` WHERE `client_id` = 0 AND `home` = 1317μs16.04KB/plugins/system/sppagebuilder/sppagebuilder.php:2010Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `z2pdg_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'349μs16.06KB/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:79Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `z2pdg_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'421μs16.06KB/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:79Copy
  • SELECT 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` = 1377μs17.1KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `value` FROM z2pdg_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"388μs16.04KB/plugins/system/acymtriggers/acymtriggers.php:436Copy
  • SHOW TABLES974μs24.07KB/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php:513Copy
  • SELECT * FROM z2pdg_acym_plugin233μs16.38KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
  • SELECT * FROM z2pdg_acym_plugin203μs16.38KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
  • SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value` FROM z2pdg_usergroups AS `groups`267μs16.34KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
  • SELECT `session_id` FROM `z2pdg_session` WHERE `session_id` = ?431μs16.92KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `z2pdg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?382μs1.97KBParamsCopy