Zoeken in onze boeken

Literaire non-fictie

  • Filters
  • Prijs in €
Categorie: Geschiedenis
Boekstatus: Licht beschadigd
Prijs: 36,99 23,90
Categorie: Literaire non-fictie
Boekstatus: Licht beschadigd
Prijs: 32,50 21,50
Categorie: Literaire non-fictie
Boekstatus: Ramsj
Prijs: 34,99 15,00
Categorie: Geschiedenis
Boekstatus: Licht beschadigd
Prijs: 12,50 8,50
Categorie: Literaire non-fictie
Boekstatus: Licht beschadigd
Prijs: 23,99 15,50
Categorie: Literaire non-fictie
Boekstatus: Ramsj
Prijs: 17,50 7,90
Categorie: Literaire non-fictie
Boekstatus: Ramsj
Prijs: 21,99 7,90
Categorie: Nederland
Boekstatus: Licht beschadigd
Prijs: 34,99 22,50
Categorie: Literaire non-fictie
Boekstatus: Licht beschadigd
Prijs: 26,99 17,50
Categorie: Literaire non-fictie
Boekstatus: Licht beschadigd
Prijs: 24,99 14,50
Categorie: Literaire non-fictie
Boekstatus: Licht beschadigd
Prijs: 23,50 15,50
Categorie: Literaire non-fictie
Prijs: 24,99 16,50
Categorie: (Geo)Politiek
Boekstatus: Licht beschadigd
Prijs: 32,50 21,50
Categorie: Literaire non-fictie
Boekstatus: Ramsj
Prijs: 49,99 19,90
Categorie: (Geo)Politiek
Boekstatus: Ramsj
Prijs: 21,99 7,90
Categorie: Geschiedenis
Boekstatus: Licht beschadigd
Prijs: 34,99 22,50
Categorie: Literaire non-fictie
Boekstatus: Licht beschadigd
Prijs: 29,99 19,90
Categorie: Literaire non-fictie
Boekstatus: Licht beschadigd
Prijs: 21,99 14,50
43.009MBMemory Usage1.54sRequest Duration
Joomla! Version4.4.13
PHP Version8.1.32
Identityguest
Response200
Templateflex
Database
Server
mysql
Version
10.6.22-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" => 1751728067 "last" => 1751728067...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (4.05MB) (32.65ms)
  • afterInitialise (12.33MB) (391ms)
  • afterRoute (1.48MB) (10.54ms)
  • beforeRenderComponent com_djcatalog2 (1.25MB) (13.46ms)
  • Before Access::preloadComponents (all components) (3.55MB) (103ms)
  • After Access::preloadComponents (all components) (131.36KB) (3.28ms)
  • Before Access::getAssetRules (id:166 name:com_djcatalog2) (3.65KB) (249μs)
  • After Access::getAssetRules (id:166 name:com_djcatalog2) (26.24KB) (976μs)
  • Before Access::getAssetRules (id:1 name:root.1) (291.66KB) (65.66ms)
  • After Access::getAssetRules (id:1 name:root.1) (2.22KB) (17μs)
  • beforeRenderRawModule mod_djc2filters (Filter prijscategorie) (4.01MB) (120ms)
  • afterRenderRawModule mod_djc2filters (Filter prijscategorie) (111.7KB) (4.33ms)
  • beforeRenderModule mod_djc2filters (Filter prijscategorie) (736B) (10μs)
  • afterRenderModule mod_djc2filters (Filter prijscategorie) (70.96KB) (1.41ms)
  • afterRenderComponent com_djcatalog2 (135.74KB) (177ms)
  • afterDispatch (3.99KB) (288μs)
  • beforeRenderRawModule mod_search (Search) (1005.57KB) (127ms)
  • afterRenderRawModule mod_search (Search) (20.83KB) (1.33ms)
  • beforeRenderModule mod_search (Search) (704B) (6μs)
  • afterRenderModule mod_search (Search) (3.78KB) (295μs)
  • beforeRenderRawModule mod_menu (Main Menu) (552B) (45μs)
  • afterRenderRawModule mod_menu (Main Menu) (47.38KB) (2.53ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (6μs)
  • afterRenderModule mod_menu (Main Menu) (2.65KB) (193μs)
  • beforeRenderRawModule mod_sppagebuilder (Contact Footer Ramsjgat) (2.02KB) (40μs)
  • afterRenderRawModule mod_sppagebuilder (Contact Footer Ramsjgat) (6.76MB) (268ms)
  • beforeRenderModule mod_sppagebuilder (Contact Footer Ramsjgat) (736B) (11μs)
  • afterRenderModule mod_sppagebuilder (Contact Footer Ramsjgat) (17.96KB) (209μs)
  • beforeRenderRawModule mod_djc2filters (Filtert) (3.47KB) (85μs)
  • afterRenderRawModule mod_djc2filters (Filtert) (13.48KB) (1.64ms)
  • beforeRenderModule mod_djc2filters (Filtert) (720B) (14μs)
  • afterRenderModule mod_djc2filters (Filtert) (1.3KB) (359μs)
  • beforeRenderRawModule mod_custom (Nieuwe Boeken 40%) (3.13KB) (67μs)
  • afterRenderRawModule mod_custom (Nieuwe Boeken 40%) (17.08KB) (1.88ms)
  • beforeRenderModule mod_custom (Nieuwe Boeken 40%) (720B) (8μs)
  • afterRenderModule mod_custom (Nieuwe Boeken 40%) (2.15KB) (313μs)
  • beforeRenderRawModule mod_djc2categories (Onze Rubrieken) (488B) (34μs)
  • afterRenderRawModule mod_djc2categories (Onze Rubrieken) (541.56KB) (36.16ms)
  • beforeRenderModule mod_djc2categories (Onze Rubrieken) (720B) (9μs)
  • afterRenderModule mod_djc2categories (Onze Rubrieken) (2.06KB) (154μs)
  • beforeRenderRawModule mod_djc2producers (Boekstatus) (14.44KB) (69μs)
  • afterRenderRawModule mod_djc2producers (Boekstatus) (40.49KB) (58.61ms)
  • beforeRenderModule mod_djc2producers (Boekstatus) (720B) (13μs)
  • afterRenderModule mod_djc2producers (Boekstatus) (3.16KB) (296μs)
  • beforeRenderRawModule mod_djc2filters (Filteren op:) (680B) (33μs)
  • afterRenderRawModule mod_djc2filters (Filteren op:) (185.95KB) (17.51ms)
  • beforeRenderModule mod_djc2filters (Filteren op:) (720B) (8μs)
  • afterRenderModule mod_djc2filters (Filteren op:) (5.91KB) (202μs)
  • afterRender (5.53MB) (98.39ms)
  • 1 x afterInitialise (12.33MB) (25.4%)
    391.05ms
    1 x afterRenderRawModule mod_sppagebuilder (Contact Footer Ramsjgat) (6.76MB) (17.4%)
    267.86ms
    1 x afterRenderComponent com_djcatalog2 (135.74KB) (11.5%)
    177.05ms
    1 x beforeRenderRawModule mod_search (Search) (1005.57KB) (8.24%)
    126.87ms
    1 x beforeRenderRawModule mod_djc2filters (Filter prijscategorie) (4.01MB) (7.79%)
    119.93ms
    1 x Before Access::preloadComponents (all components) (3.55MB) (6.68%)
    102.87ms
    1 x afterRender (5.53MB) (6.39%)
    98.39ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (291.66KB) (4.26%)
    65.66ms
    1 x afterRenderRawModule mod_djc2producers (Boekstatus) (40.49KB) (3.81%)
    58.61ms
    1 x afterRenderRawModule mod_djc2categories (Onze Rubrieken) (541.56KB) (2.35%)
    36.16ms
    1 x afterLoad (4.05MB) (2.12%)
    32.65ms
    1 x afterRenderRawModule mod_djc2filters (Filteren op:) (185.95KB) (1.14%)
    17.51ms
    1 x beforeRenderComponent com_djcatalog2 (1.25MB) (0.87%)
    13.46ms
    1 x afterRoute (1.48MB) (0.68%)
    10.54ms
    1 x afterRenderRawModule mod_djc2filters (Filter prijscategorie) (111.7KB) (0.28%)
    4.33ms
    1 x After Access::preloadComponents (all components) (131.36KB) (0.21%)
    3.28ms
    1 x afterRenderRawModule mod_menu (Main Menu) (47.38KB) (0.16%)
    2.53ms
    1 x afterRenderRawModule mod_custom (Nieuwe Boeken 40%) (17.08KB) (0.12%)
    1.88ms
    1 x afterRenderRawModule mod_djc2filters (Filtert) (13.48KB) (0.11%)
    1.64ms
    1 x afterRenderModule mod_djc2filters (Filter prijscategorie) (70.96KB) (0.09%)
    1.41ms
    1 x afterRenderRawModule mod_search (Search) (20.83KB) (0.09%)
    1.33ms
    1 x After Access::getAssetRules (id:166 name:com_djcatalog2) (26.24KB) (0.06%)
    976μs
    1 x afterRenderModule mod_djc2filters (Filtert) (1.3KB) (0.02%)
    359μs
    1 x afterRenderModule mod_custom (Nieuwe Boeken 40%) (2.15KB) (0.02%)
    313μs
    1 x afterRenderModule mod_djc2producers (Boekstatus) (3.16KB) (0.02%)
    296μs
    1 x afterRenderModule mod_search (Search) (3.78KB) (0.02%)
    295μs
    1 x afterDispatch (3.99KB) (0.02%)
    288μs
    1 x Before Access::getAssetRules (id:166 name:com_djcatalog2) (3.65KB) (0.02%)
    249μs
    1 x afterRenderModule mod_sppagebuilder (Contact Footer Ramsjgat) (17.96KB) (0.01%)
    209μs
    1 x afterRenderModule mod_djc2filters (Filteren op:) (5.91KB) (0.01%)
    202μs
    1 x afterRenderModule mod_menu (Main Menu) (2.65KB) (0.01%)
    193μs
    1 x afterRenderModule mod_djc2categories (Onze Rubrieken) (2.06KB) (0.01%)
    154μs
    1 x beforeRenderRawModule mod_djc2filters (Filtert) (3.47KB) (0.01%)
    85μs
    1 x beforeRenderRawModule mod_djc2producers (Boekstatus) (14.44KB) (0%)
    69μs
    1 x beforeRenderRawModule mod_custom (Nieuwe Boeken 40%) (3.13KB) (0%)
    67μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (552B) (0%)
    45μs
    1 x beforeRenderRawModule mod_sppagebuilder (Contact Footer Ramsjgat) (2.02KB) (0%)
    40μs
    1 x beforeRenderRawModule mod_djc2categories (Onze Rubrieken) (488B) (0%)
    34μs
    1 x beforeRenderRawModule mod_djc2filters (Filteren op:) (680B) (0%)
    33μs
    1 x After Access::getAssetRules (id:1 name:root.1) (2.22KB) (0%)
    17μs
    1 x beforeRenderModule mod_djc2filters (Filtert) (720B) (0%)
    14μs
    1 x beforeRenderModule mod_djc2producers (Boekstatus) (720B) (0%)
    13μs
    1 x beforeRenderModule mod_sppagebuilder (Contact Footer Ramsjgat) (736B) (0%)
    11μs
    1 x beforeRenderModule mod_djc2filters (Filter prijscategorie) (736B) (0%)
    10μs
    1 x beforeRenderModule mod_djc2categories (Onze Rubrieken) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_custom (Nieuwe Boeken 40%) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_djc2filters (Filteren op:) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_search (Search) (704B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    6μs
124 statements were executed, 16 of which were duplicates, 108 unique282ms4.07MB
  • SELECT `data` FROM `z2pdg_session` WHERE `session_id` = ?288μs17.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `z2pdg_session` WHERE `session_id` = :session_id LIMIT 1931μ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)2.62ms1.66KBParamsCopy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `z2pdg_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1502μs48.84KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `z2pdg_viewlevels`197μ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` = :guest210μ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`703μs19.82KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `template` FROM `z2pdg_template_styles` WHERE `client_id` = 0 AND `home` = 1491μs16.04KB/components/com_sppagebuilder/parser/addon-parser.php:1095Copy
  • SELECT `value` FROM z2pdg_acym_configuration WHERE `name` = 'level'65.83ms17.29KB/plugins/system/acymtriggers/acymtriggers.php:645Copy
  • SELECT `template` FROM `z2pdg_template_styles` WHERE `client_id` = 0 AND `home` = 1551μ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`772μs34.56KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • 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 ASC844μs354.12KB/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 = '*')441μs16.13KB/administrator/components/com_djcatalog2/lib/categories.php:368Copy
  • SELECT * FROM `z2pdg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC228μs16.45KB/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` = 1471μs96.28KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • select alias from z2pdg_djc2_items_extra_fields where type='checkbox' or type='radio' or type='select'5.75ms16.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)2.95ms29.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 1620μs16.02KB/components/com_djcatalog2/helpers/user.php:368Copy
  • select * from z2pdg_djc2_countries where is_default=15.18ms16.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 ASC622μs16.19KB/components/com_djcatalog2/helpers/user.php:503Copy
  • 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 asc606μs17.02KB/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 asc53.36ms20.05KB/components/com_djcatalog2/models/items.php:1120Copy
  • 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 ASC3.28ms354KB/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 = '*')506μs16.13KB/administrator/components/com_djcatalog2/lib/categories.php:368Copy
  • 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 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 (97)) 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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47') 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 asc LIMIT 205.03ms115.45KB/components/com_djcatalog2/models/items.php:286Copy
  • 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 IN (2543,2044,2111,2565,2320,1979,1991,1113,2321,2019,2028,2018,2537,785,2020,1112,2461,2322) AND fields.cart_variant = 2 AND fields.published = 1 ORDER BY fieldvalues.field_id asc, fields.ordering asc, fieldoptions.ordering asc3.44ms16.26KB/components/com_djcatalog2/models/items.php:1230Copy
  • 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 IN (2543,2044,2111,2565,2320,1979,1991,1113,2321,2019,2028,2018,2537,785,2020,1112,2461,2322) AND (fields.visibility = 2 OR fields.visibility = 3) AND fields.published = 1 ORDER BY fieldvalues.field_id asc, fields.ordering asc, fieldoptions.ordering asc1.7ms16.84KB/components/com_djcatalog2/models/items.php:1233Copy
  • 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 IN (2543,2044,2111,2565,2320,1979,1991,1113,2321,2019,2028,2018,2537,785,2020,1112,2461,2322) AND (fields.visibility = 2 OR fields.visibility = 3) AND fields.published = 1 ORDER BY fieldvalues.field_id asc, fields.ordering asc7.44ms17.06KB/components/com_djcatalog2/models/items.php:1236Copy
  • 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 IN (2543,2044,2111,2565,2320,1979,1991,1113,2321,2019,2028,2018,2537,785,2020,1112,2461,2322) AND (fields.visibility = 2 OR fields.visibility = 3) AND fields.published = 1 ORDER BY fieldvalues.field_id asc, fields.ordering asc5.63ms16.19KB/components/com_djcatalog2/models/items.php:1239Copy
  • 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 IN (2543,2044,2111,2565,2320,1979,1991,1113,2321,2019,2028,2018,2537,785,2020,1112,2461,2322) AND l.published = 1 ORDER BY l.ordering714μs16.25KB/components/com_djcatalog2/models/items.php:1242Copy
  • SELECT 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 (2543, 2044, 2111, 2565, 2320, 1979, 1991, 1113, 2321, 2019, 2028, 2018, 2537, 785, 2020, 1112, 2461, 2322) AND (p.available = 1 OR p.price > 0.0) ORDER BY cg.ordering352μs16.23KB/components/com_djcatalog2/models/items.php:1245Copy
  • 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_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 (2543,2044,2111,2565,2320,1979,1991,1113,2321,2019,2028,2018,2537,785,2020,1112,2461,2322)606μs16.44KB/components/com_djcatalog2/models/items.php:1353Copy
  • 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 ASC8.53ms365KB/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 = '*')767μs16.13KB/administrator/components/com_djcatalog2/lib/categories.php:368Copy
  • 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-07-05 15:07:47') AND (expire_date IS NULL OR expire_date = '0000-00-00 00:00:00' OR expire_date >= '2025-07-05 15:07:47') ORDER BY ordering280μs16.75KB/components/com_djcatalog2/helpers/price.php:703Copy
  • 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 c.access IN (1,5) AND ic.category_id IN (97)) 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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47') AND i.published = 1 AND i.access IN (1,5) AND i.parent_id=0 AND (i.language = 'nl-NL' OR i.language = '*') LIMIT 202.52ms16.04KB/components/com_djcatalog2/models/items.php:344Copy
  • SELECT 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 ASC7.91ms354KB/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 = '*')525μs16.13KB/administrator/components/com_djcatalog2/lib/categories.php:368Copy
  • SELECT 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 (97) AND a.published=1 AND (a.language = 'nl-NL' OR a.language = '*') GROUP BY a.id, a.name ORDER BY a.ordering asc559μs16.08KB/components/com_djcatalog2/models/items.php:1435Copy
  • SELECT 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 (97)) 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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47') 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)4.13ms17.45KB/components/com_djcatalog2/models/items.php:1639Copy
  • 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 asc822μs16.78KB/plugins/djcatalog2/customfield/customfield.php:41Copy
  • 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 = 2 or f.visibility = 3) and f.published = 1 ORDER BY IFNULL(g.ordering,0) asc, g.ordering asc, f.ordering asc588μs16.7KB/components/com_djcatalog2/models/items.php:1110Copy
  • SELECT 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 (97)) 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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47') 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 asc1.32ms16.53KB/components/com_djcatalog2/models/items.php:1693Copy
  • SELECT 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 (97)) 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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47') 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 asc1.44ms16.56KB/components/com_djcatalog2/models/items.php:1733Copy
  • 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 ASC660μ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)460μs16.13KB/administrator/components/com_djcatalog2/lib/categories.php:368Copy
  • SELECT * FROM z2pdg_djc2_images WHERE item_id=97 AND type='category' AND exclude=0 ORDER BY ordering ASC, name ASC300μs16.31KB/administrator/components/com_djcatalog2/helpers/image.php:80Copy
  • 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`987μs18.63KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • 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 (3)) and f.id in (26,27) GROUP BY f.id ORDER BY IFNULL(g.ordering,0) asc, g.ordering asc, f.ordering asc508μs16.63KB/modules/mod_djc2filters/helper.php:165Copy
  • select id, producer_id from z2pdg_djc2_items where published=12.32ms64.05KB/components/com_djcatalog2/helpers/route.php:73Copy
  • SELECT * FROM `z2pdg_sppagebuilder` WHERE `extension` = 'mod_sppagebuilder' AND `extension_view` = 'module' AND `view_id` = '164'1.19ms168.88KB/modules/mod_sppagebuilder/helper.php:49Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `z2pdg_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'337μs16.06KB/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:123Copy
  • SELECT `template` FROM `z2pdg_template_styles` WHERE `client_id` = 0 AND `home` = 12.91ms16.04KB/components/com_sppagebuilder/builder/classes/base.php:85Copy
  • 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 ASC5.12ms16.28KB/components/com_sppagebuilder/builder/classes/base.php:326Copy
  • SELECT a.enabled FROM `z2pdg_extensions` AS `a` WHERE `a`.`name` = 'com_k2'10.78ms16.02KB/components/com_sppagebuilder/builder/classes/base.php:872Copy
  • SELECT a.enabled FROM `z2pdg_extensions` AS `a` WHERE `a`.`name` = 'com_k2'7.93ms16.02KB/components/com_sppagebuilder/builder/classes/base.php:872Copy
  • SELECT a.enabled FROM `z2pdg_extensions` AS `a` WHERE `a`.`name` = 'com_k2'597μs16.02KB/components/com_sppagebuilder/builder/classes/base.php:872Copy
  • SELECT a.enabled FROM `z2pdg_extensions` AS `a` WHERE (`a`.`element` = 'com_acymailing' OR `a`.`element` = 'com_acym')315μs16.05KB/components/com_sppagebuilder/builder/classes/base.php:776Copy
  • SELECT `e`.`manifest_cache` FROM `z2pdg_extensions` AS `e` WHERE e.element = 'com_acymailing' OR e.element = 'com_acym'221μs16.05KB/components/com_sppagebuilder/builder/classes/base.php:849Copy
  • SELECT `listid`,`name` FROM `z2pdg_acymailing_list` WHERE `published` = '1' ORDER BY name DESC187μs16.09KB/components/com_sppagebuilder/builder/classes/base.php:798Copy
  • SELECT `template` FROM `z2pdg_template_styles` WHERE `client_id` = 0 AND `home` = 1360μs16.04KB/components/com_sppagebuilder/builder/classes/base.php:85Copy
  • 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 asc658μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')598μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')557μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')1.75ms24.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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')457μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')648μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')784μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')495μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')383μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')750μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')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 (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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')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 (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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')1.59ms16.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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')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 (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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')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 (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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')401μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')835μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')614μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')448μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')433μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')3.84ms16.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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')845μ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 (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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')428μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')484μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')704μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')480μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')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 (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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')494μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')446μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')325μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')496μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')391μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')320μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')647μ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 (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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')394μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')295μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')369μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')353μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')318μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')385μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')308μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')306μ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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47')299μ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 asc535μ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)355μ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 asc1.16ms16.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 asc581μ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 asc8.1ms16.09KB/modules/mod_djc2filters/helper.php:184Copy
  • 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 (97)) 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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47') 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.05ms16.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 (97)) 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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47') 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 asc851μs16.38KB/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 (97)) 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-07-05 15:07:47') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-05 15:07:47') 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 asc796μs16.14KB/modules/mod_djc2filters/helper.php:287Copy
  • SELECT * FROM z2pdg_acym_configuration412μs20.05KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
  • SELECT * FROM z2pdg_acym_list WHERE type = 'standard'286μs16.55KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
  • SELECT * FROM z2pdg_acym_field253μs16.42KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
  • SELECT * FROM z2pdg_acym_form WHERE active = 1 AND type != 'shortcode'223μs16.19KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
  • 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` = 1342μ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"484μs16.04KB/plugins/system/acymtriggers/acymtriggers.php:436Copy
  • SHOW TABLES1.02ms24.07KB/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php:513Copy
  • SELECT * FROM z2pdg_acym_plugin229μs16.38KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
  • SELECT * FROM z2pdg_acym_plugin201μ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`290μs16.34KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
  • SELECT `session_id` FROM `z2pdg_session` WHERE `session_id` = ?477μs16.92KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `z2pdg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?546μs1.84KBParamsCopy