In het begin van de jaren vijftig van de vorige eeuw stapt een elfjarige jongen in Sri Lanka aan boord van een schip naar Engeland. Tijdens de maaltijden zit hij niet aan de kapiteinstafel, maar aan de ‘kattentafel’, samen met een groepje volwassenen en twee andere jongens van zijn leeftijd. De drie jongens raken al snel bevriend, en wat eerst een saaie, eindeloze reis leek te worden, wordt een groot avontuur en een rite de passage.
Op het schip is genoeg afleiding: zo vertelt een man het drietal over jazz en vrouwen, en een ander vertelt hun over literatuur. Weer een ander neemt ze mee naar de tuin in het ruim vol geheimzinnige tropische planten, die hij meeneemt naar Engeland. Er zijn jongleurs aan boord, er is een baron die een dief blijkt te zijn, een rijke Ceylonees krijgt een zeemansgraf, maar het ware avontuur begint ’s nachts, als de jongens ontdekken dat het schip een mysterieuze gevangene herbergt, die door zijn bewakers in de stille nachtelijke uren wordt gelucht. De daden van de gevangene en zijn onzekere toekomst blijven voor de jongens een raadsel, maar wel een raadsel dat hen voor altijd zal blijven achtervolgen.
De kattentafel is een subtiele en spannende roman van een van ’s werelds grootste schrijvers, over een levenslange reis die begon als een spectaculaire tocht over zee.
Michael Ondaatje is een van de grootste schrijvers van dit moment. Hij is geboren in Sri Lanka en woont nu in Canada. Ondaatje is het bekendst van zijn roman De Engelse patiënt, waarmee hij in 1992 de Booker Prize in de wacht sleepte. Zijn laatste roman, Divisadero, won de Governor General's Award voor literaire fictie. De kattentafel is een nieuw hoogtepunt in zijn imposante oeuvre.
'Zijn beste roman sinds De Engelse patient'
publishers weekly *
'Een welsprekend, weemoedig eerbetoon aan het spel van de jeugd en dat wat er op zou moeten volgen.'
the independent on sunday
'Niemand die een roman of gedicht van Ondaatje heeft gelezen, kan zijn grote verbeeldingskracht vergeten. Ook zijn nieuwe roman kenmerkt zich hierdoor. Ondaatje heeft zelf aangegeven dat, hoewel De kattentafel pure fictie is, het is getekend door de kleuren en passages van memoir en autobiografie. Dit kan de reden zijn dat zijn sublieme proza nog levendiger overkomt dan ooit tevoren.'
the financial times
'De kattentafel verdient het om te worden herkend aan de schoonheid en de poëzie van zijn taal: pagina’s die je laten wiegen op hun zorgvuldig opgebouwde ritme zeilen je moeiteloos van hoofdstuk naar hoofdstuk, om je aan het einde van de roman ontredderd achter te laten.'
the telegraph
Auteur | Michael Ondaatje |
ISBN/ EAN | 9789044617962 |
Bindwijze | Paperback |
Pagina's | 253 |
Uitgever | Prometheus |
Verschijningsdatum | oktober 2011 |
Taal | Nederlands |
Joomla! Version | 4.4.13 |
PHP Version | 8.1.32 |
Identity | guest |
Response | 200 |
Template | flex |
Database |
|
1 x afterInitialise (12.33MB) (20.02%) | 180.61ms |
1 x afterRenderRawModule mod_sppagebuilder (Contact Footer Ramsjgat) (6.76MB) (14.73%) | 132.89ms |
1 x afterRenderRawModule mod_djc2categories (Onze Rubrieken) (749.59KB) (11.56%) | 104.23ms |
1 x beforeRenderRawModule mod_search (Search) (1019.68KB) (10.84%) | 97.77ms |
1 x Before Access::preloadComponents (all components) (4.05MB) (9.03%) | 81.44ms |
1 x afterRender (5.54MB) (6.48%) | 58.41ms |
1 x afterRoute (905.16KB) (6.45%) | 58.18ms |
1 x afterRenderComponent com_djcatalog2 (953.89KB) (5.95%) | 53.63ms |
1 x Before Access::getAssetRules (id:1 name:root.1) (2.98MB) (5.07%) | 45.76ms |
1 x afterLoad (4.05MB) (3.53%) | 31.83ms |
1 x afterRenderRawModule mod_djc2filters (Filteren op:) (825.35KB) (2.95%) | 26.62ms |
1 x beforeRenderComponent com_djcatalog2 (1.24MB) (1.59%) | 14.30ms |
1 x afterRenderRawModule mod_djc2producers (Boekstatus) (117.57KB) (0.35%) | 3.18ms |
1 x afterRenderRawModule mod_menu (Main Menu) (48.6KB) (0.28%) | 2.56ms |
1 x afterRenderRawModule mod_djc2filters (Filtert) (86.48KB) (0.26%) | 2.38ms |
1 x afterRenderRawModule mod_search (Search) (50.34KB) (0.25%) | 2.23ms |
1 x After Access::preloadComponents (all components) (130.99KB) (0.12%) | 1.08ms |
1 x afterRenderRawModule mod_custom (Nieuwe Boeken 40%) (14.55KB) (0.11%) | 1.00ms |
1 x After Access::getAssetRules (id:166 name:com_djcatalog2) (26.24KB) (0.05%) | 441μs |
1 x afterRenderModule mod_djc2filters (Filteren op:) (9.91KB) (0.03%) | 314μs |
1 x afterRenderModule mod_search (Search) (3.78KB) (0.03%) | 305μs |
1 x afterRenderModule mod_djc2producers (Boekstatus) (3.16KB) (0.03%) | 241μs |
1 x afterRenderModule mod_sppagebuilder (Contact Footer Ramsjgat) (17.96KB) (0.02%) | 205μs |
1 x afterDispatch (2.74KB) (0.02%) | 201μs |
1 x afterRenderModule mod_djc2categories (Onze Rubrieken) (2.06KB) (0.02%) | 201μs |
1 x afterRenderModule mod_menu (Main Menu) (2.65KB) (0.02%) | 174μs |
1 x afterRenderModule mod_custom (Nieuwe Boeken 40%) (2.15KB) (0.02%) | 168μs |
1 x afterRenderModule mod_djc2filters (Filtert) (1.3KB) (0.02%) | 162μs |
1 x beforeRenderRawModule mod_djc2filters (Filtert) (3.47KB) (0.01%) | 71μs |
1 x beforeRenderRawModule mod_djc2producers (Boekstatus) (14.44KB) (0.01%) | 60μs |
1 x beforeRenderRawModule mod_sppagebuilder (Contact Footer Ramsjgat) (2.02KB) (0%) | 40μs |
1 x beforeRenderRawModule mod_djc2filters (Filteren op:) (3.34KB) (0%) | 35μs |
1 x Before Access::getAssetRules (id:166 name:com_djcatalog2) (3.65KB) (0%) | 25μs |
1 x beforeRenderRawModule mod_menu (Main Menu) (552B) (0%) | 24μs |
1 x beforeRenderRawModule mod_custom (Nieuwe Boeken 40%) (3.13KB) (0%) | 23μs |
1 x beforeRenderRawModule mod_djc2categories (Onze Rubrieken) (488B) (0%) | 21μs |
1 x After Access::getAssetRules (id:1 name:root.1) (2.22KB) (0%) | 16μs |
1 x beforeRenderModule mod_djc2categories (Onze Rubrieken) (720B) (0%) | 12μs |
1 x beforeRenderModule mod_sppagebuilder (Contact Footer Ramsjgat) (736B) (0%) | 10μs |
1 x beforeRenderModule mod_djc2filters (Filteren op:) (720B) (0%) | 8μs |
1 x beforeRenderModule mod_djc2producers (Boekstatus) (720B) (0%) | 8μs |
1 x beforeRenderModule mod_djc2filters (Filtert) (720B) (0%) | 6μ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_custom (Nieuwe Boeken 40%) (720B) (0%) | 6μs |
SELECT `data`
FROM `z2pdg_session`
WHERE `session_id` = ?
287μs17.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `z2pdg_session`
WHERE `session_id` = :session_id LIMIT 1
216μs16.98KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `z2pdg_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
229μs1.66KBParamsCopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `z2pdg_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
374μs48.84KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `z2pdg_viewlevels`
182μs16.75KB/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `z2pdg_usergroups` AS `a`
LEFT JOIN `z2pdg_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
212μs17.03KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `z2pdg_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`
675μs19.82KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT `template`
FROM `z2pdg_template_styles`
WHERE `client_id` = 0 AND `home` = 1
531μs16.04KB/components/com_sppagebuilder/parser/addon-parser.php:1095CopySELECT `value` FROM z2pdg_acym_configuration WHERE `name` = 'level'
241μs17.29KB/plugins/system/acymtriggers/acymtriggers.php:645CopySELECT `template`
FROM `z2pdg_template_styles`
WHERE `client_id` = 0 AND `home` = 1
227μs16.04KB/plugins/system/helix3/helix3.php:247CopySELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component`
FROM `z2pdg_menu` AS `m`
LEFT JOIN `z2pdg_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id`
WHERE
(
(`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2)
ORDER BY `m`.`lft`
987μs34.56KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT *
FROM `z2pdg_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
428μs16.48KB/libraries/src/Language/LanguageHelper.php:142CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `z2pdg_template_styles` AS `s`
LEFT JOIN `z2pdg_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id`
WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1
515μs96.28KB/administrator/components/com_templates/src/Model/StyleModel.php:773CopySELECT c.* FROM z2pdg_djc2_categories AS c WHERE c.published=1 AND c.access IN (1,5) AND (c.language = 'nl-NL' OR c.language = '*') ORDER BY c.parent_id ASC, c.ordering ASC
909μs354.04KB/administrator/components/com_djcatalog2/lib/categories.php:355CopySELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM z2pdg_djc2_categories as i
INNER JOIN z2pdg_djc2_images as img on img.id=(select id from z2pdg_djc2_images where type='category' and item_id=i.id order by ordering asc limit 1)
WHERE (i.language = 'nl-NL' OR i.language = '*')
689μs16.13KB/administrator/components/com_djcatalog2/lib/categories.php:368Copyselect alias from z2pdg_djc2_items_extra_fields where type='checkbox' or type='radio' or type='select'
292μs16.07KB/components/com_djcatalog2/controller.php:133CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `z2pdg_assets`
WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47)
870μs29.08KBParams/libraries/src/Access/Access.php:357CopySELECT id
FROM z2pdg_djc2_customer_groups
WHERE (user_group IN (1,9) OR is_default=1)
ORDER BY ordering DESC LIMIT 1
340μs16.02KB/components/com_djcatalog2/helpers/user.php:368Copyselect * from z2pdg_djc2_countries where is_default=1
280μs16.19KB/components/com_djcatalog2/helpers/user.php:429CopySELECT vrul.id as rule_id, vrul.name, vrat.*
FROM z2pdg_djc2_vat_rules AS vrul
INNER JOIN z2pdg_djc2_vat_rules_xref AS vx ON vx.rule_id = vrul.id
INNER JOIN z2pdg_djc2_vat_rates AS vrat ON vx.rate_id = vrat.id
WHERE vrat.country_id=0 AND vrat.state_id=0 AND (vrat.client_type='A' OR vrat.client_type='R')
ORDER BY vrat.client_type ASC, vrat.country_id ASC, vrat.state_id ASC
328μs16.19KB/components/com_djcatalog2/helpers/user.php:503CopySELECT 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 =2778 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
GROUP BY i.id
649μs34.98KB/components/com_djcatalog2/models/item.php:200CopySELECT c.* FROM z2pdg_djc2_categories AS c WHERE (c.language = 'nl-NL' OR c.language = '*') ORDER BY c.parent_id ASC, c.ordering ASC
768μs354KB/administrator/components/com_djcatalog2/lib/categories.php:355CopySELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM z2pdg_djc2_categories as i
INNER JOIN z2pdg_djc2_images as img on img.id=(select id from z2pdg_djc2_images where type='category' and item_id=i.id order by ordering asc limit 1)
WHERE (i.language = 'nl-NL' OR i.language = '*')
526μs16.13KB/administrator/components/com_djcatalog2/lib/categories.php:368CopySELECT category_id
FROM z2pdg_djc2_items_categories
WHERE item_id=2778
197μs16.04KB/components/com_djcatalog2/models/item.php:570CopySELECT *
FROM z2pdg_djc2_item_reviews
WHERE item_id=2778 LIMIT 100
177μs16.22KB/components/com_djcatalog2/models/item.php:577CopySELECT 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=2778 AND fields.cart_variant=2 AND fields.published = 1
ORDER BY fields.ordering asc, fieldoptions.ordering asc
660μs16.26KB/components/com_djcatalog2/models/item.php:624CopySELECT 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=2778 AND (fields.visibility = 1 OR fields.visibility = 3) AND fields.published = 1
ORDER BY fields.ordering asc, fieldoptions.ordering asc
611μs16.27KB/components/com_djcatalog2/models/item.php:626CopySELECT 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=2778 AND (fields.visibility = 1 OR fields.visibility = 3) AND fields.published = 1
338μs16.25KB/components/com_djcatalog2/models/item.php:628CopySELECT 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=2778 AND (fields.visibility = 1 OR fields.visibility = 3) AND fields.published = 1
ORDER BY fields.ordering asc
321μs16.19KB/components/com_djcatalog2/models/item.php:630CopySELECT 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=2778
ORDER BY l.ordering
459μs16.25KB/components/com_djcatalog2/models/item.php:633CopySELECT 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 = 2778 AND (p.available = 1 OR p.price > 0.0)
ORDER BY cg.ordering
281μs16.23KB/components/com_djcatalog2/models/item.php:647CopySELECT COUNT(*)
FROM z2pdg_djc2_items_combinations
WHERE item_id =2778
214μs16.04KB/components/com_djcatalog2/models/item.php:654CopySELECT *
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-14 09:57:21') AND (expire_date IS NULL OR expire_date = '0000-00-00 00:00:00' OR expire_date >= '2025-07-14 09:57:21')
ORDER BY ordering
309μs27.75KB/components/com_djcatalog2/helpers/price.php:703CopySELECT *
FROM z2pdg_djc2_items_price_tiers
WHERE item_id=2778
ORDER BY quantity ASC
207μs16.08KB/components/com_djcatalog2/models/item.php:1291CopySELECT sections
FROM `z2pdg_djc2_categories`
WHERE `id` = 65
648μs16.04KB/components/com_djcatalog2/models/item.php:309CopySELECT sections
FROM `z2pdg_djc2_categories`
WHERE `id` = 65
215μs16.04KB/components/com_djcatalog2/models/item.php:309CopySELECT c.* FROM z2pdg_djc2_categories AS c WHERE c.published=1 AND c.access IN (1,5) ORDER BY c.parent_id ASC, c.ordering ASC
717μs354KB/administrator/components/com_djcatalog2/lib/categories.php:355CopySELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM z2pdg_djc2_categories as i
INNER JOIN z2pdg_djc2_images as img on img.id=(select id from z2pdg_djc2_images where type='category' and item_id=i.id order by ordering asc limit 1)
468μs16.13KB/administrator/components/com_djcatalog2/lib/categories.php:368Copyselect id, producer_id from z2pdg_djc2_items where published=1
1.78ms64.05KB/components/com_djcatalog2/helpers/route.php:73CopySELECT f.*, group_concat(fo.id separator '|') as options
FROM z2pdg_djc2_items_extra_fields as f
LEFT JOIN z2pdg_djc2_items_extra_fields_options as fo ON fo.field_id=f.id
WHERE f.published = 1
GROUP BY f.id
ORDER BY f.group_id asc, f.ordering asc
899μs17.02KB/plugins/djcatalog2/customfield/customfield.php:41CopySELECT related_item
FROM z2pdg_djc2_items_related
WHERE item_id=2778
234μs16.02KB/components/com_djcatalog2/models/item.php:334CopySELECT 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 asc
800μs16.86KB/components/com_djcatalog2/models/item.php:400CopySELECT *
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 asc
631μs20.13KB/components/com_djcatalog2/models/item.php:410CopySELECT sections
FROM `z2pdg_djc2_categories`
WHERE `id` = 65
192μs16.04KB/components/com_djcatalog2/models/item.php:309CopySELECT sections
FROM `z2pdg_djc2_categories`
WHERE `id` = 65
156μs16.04KB/components/com_djcatalog2/models/item.php:309CopySELECT 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 = 2778
228μs16.31KB/components/com_djcatalog2/models/item.php:956CopySELECT 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 asc
444μs16.63KB/components/com_djcatalog2/models/item.php:458CopySELECT sections
FROM `z2pdg_djc2_categories`
WHERE `id` = 65
153μs16.04KB/components/com_djcatalog2/models/item.php:309CopySELECT 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 = 2778
197μs16.31KB/components/com_djcatalog2/models/item.php:956CopySELECT 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 = 2778 AND c.type='i'
ORDER BY c.ordering
437μs16.31KB/components/com_djcatalog2/models/item.php:1124CopySELECT 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.ordering
230μs16.38KB/components/com_djcatalog2/models/item.php:1124CopySELECT 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-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21') AND c.published = 1 AND i.cat_id=65 ORDER BY i.name asc , i.ordering, c.ordering ) as k) as subq WHERE subq.id = 2778 ORDER BY subq.position DESC LIMIT 1
4.51ms16.04KB/components/com_djcatalog2/models/item.php:857CopySELECT 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-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21') AND c.published = 1 AND i.cat_id=65 ORDER BY i.name asc , i.ordering, c.ordering ) as k) as subq WHERE subq.position < 64 ORDER BY subq.position DESC LIMIT 1
1.34ms16.2KB/components/com_djcatalog2/models/item.php:869CopySELECT 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-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21') AND c.published = 1 AND i.cat_id=65 ORDER BY i.name asc , i.ordering, c.ordering ) as k) as subq WHERE subq.position > 64 ORDER BY subq.position ASC LIMIT 1
1.21ms16.2KB/components/com_djcatalog2/models/item.php:877CopySELECT f.*, g.name as group_name, g.label as group_label, g.id as fgroup_id
FROM z2pdg_djc2_items_extra_fields as f
LEFT JOIN z2pdg_djc2_items_extra_fields_groups as g ON g.id=f.group_id
WHERE f.published = 1
ORDER BY IFNULL(g.ordering,0) asc, g.ordering asc, f.ordering asc
769μs16.78KB/components/com_djcatalog2/models/items.php:1110CopySELECT o.id, o.field_id
FROM z2pdg_djc2_items_extra_fields_options AS o
ORDER BY o.field_id asc, o.ordering asc
358μs20.05KB/components/com_djcatalog2/models/items.php:1120CopySELECT 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-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21') AND i.published = 1 AND i.access IN (1,5) AND i.parent_id=2778 AND (i.language = 'nl-NL' OR i.language = '*')
ORDER BY c.parent_id asc, c.ordering asc, i.ordering asc
1.4ms34.5KB/components/com_djcatalog2/models/items.php:286CopySELECT * FROM z2pdg_djc2_images WHERE item_id=2778 AND type='item' AND exclude=0 ORDER BY ordering ASC, name ASC
290μs16.33KB/administrator/components/com_djcatalog2/helpers/image.php:80CopyUPDATE z2pdg_djc2_items SET hits = hits + 1 WHERE id = 2778
693μs56BCopySELECT `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`
896μs18.58KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT * FROM z2pdg_djc2_videos WHERE item_id=2778 AND type='item' ORDER BY ordering ASC
514μs16.31KB/administrator/components/com_djcatalog2/helpers/video.php:70CopySELECT 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 ASC
983μs20.01KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM 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 ASC
826μs19.61KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM 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 ASC
779μs19.61KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT * FROM z2pdg_djc2_files WHERE item_id=2778 AND type='item' AND access IN (1,5) ORDER BY ordering ASC, name ASC
287μs24.38KB/administrator/components/com_djcatalog2/helpers/file.php:76CopySELECT *
FROM `z2pdg_sppagebuilder`
WHERE `extension` = 'mod_sppagebuilder' AND `extension_view` = 'module' AND `view_id` = '164'
1.07ms168.88KB/modules/mod_sppagebuilder/helper.php:49CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `z2pdg_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
324μs16.06KB/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:123CopySELECT `template`
FROM `z2pdg_template_styles`
WHERE `client_id` = 0 AND `home` = 1
291μs16.04KB/components/com_sppagebuilder/builder/classes/base.php:85CopySELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id
FROM (
SELECT id,title,level,published,parent_id,lft,rgt
FROM z2pdg_tags
WHERE `published` = '1') AS a
LEFT JOIN `z2pdg_tags` AS b ON a.lft > b.lft AND a.rgt < b.rgt
WHERE `a`.`level` != '0'
ORDER BY a.lft ASC
403μs16.28KB/components/com_sppagebuilder/builder/classes/base.php:326CopySELECT a.enabled
FROM `z2pdg_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'
338μs16.02KB/components/com_sppagebuilder/builder/classes/base.php:872CopySELECT a.enabled
FROM `z2pdg_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'
304μs16.02KB/components/com_sppagebuilder/builder/classes/base.php:872CopySELECT a.enabled
FROM `z2pdg_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'
298μs16.02KB/components/com_sppagebuilder/builder/classes/base.php:872CopySELECT a.enabled
FROM `z2pdg_extensions` AS `a`
WHERE (`a`.`element` = 'com_acymailing' OR `a`.`element` = 'com_acym')
337μs16.05KB/components/com_sppagebuilder/builder/classes/base.php:776CopySELECT `e`.`manifest_cache`
FROM `z2pdg_extensions` AS `e`
WHERE e.element = 'com_acymailing' OR e.element = 'com_acym'
298μs16.05KB/components/com_sppagebuilder/builder/classes/base.php:849CopySELECT `listid`,`name`
FROM `z2pdg_acymailing_list`
WHERE `published` = '1'
ORDER BY name DESC
202μs16.09KB/components/com_sppagebuilder/builder/classes/base.php:798CopySELECT `template`
FROM `z2pdg_template_styles`
WHERE `client_id` = 0 AND `home` = 1
467μs16.04KB/components/com_sppagebuilder/builder/classes/base.php:85CopySELECT f.*, g.name as group_name, g.label as group_label
FROM z2pdg_djc2_items_extra_fields as f
LEFT JOIN z2pdg_djc2_items_extra_fields_groups as g ON g.id=f.group_id
WHERE f.published = 1 and f.filterable = 1 and (f.type = 'checkbox' or f.type = 'radio' or f.type = 'select' or f.type = 'text' or f.type = 'color' or f.type = 'multicolor' or f.type = 'multiselect') and (g.id in (4))
GROUP BY f.id
ORDER BY IFNULL(g.ordering,0) asc, g.ordering asc, f.ordering asc
658μs16.63KB/modules/mod_djc2filters/helper.php:165CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (36)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
563μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (105)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
372μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (12)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
1.34ms16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (107)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
448μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (20,70,69)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
616μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (8)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
902μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (46)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
637μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (83)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
431μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (49,91)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
733μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (16)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
488μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (21,74)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
45.38ms16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (13,67,92,11)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
2.18ms16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (47)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
592μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (18)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
498μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (84)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
812μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (9,101,100,96)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
1.14ms16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (3,72,73,71,106)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
751μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (102)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
557μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (97)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
682μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (2,59,104,80,60,61,62,98,103,81,63,76,64,66,109,65,77,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-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
4.63ms16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
796μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
409μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
396μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
757μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
645μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
539μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
416μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
556μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
421μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
1.66ms16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
408μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
477μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
451μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
450μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
797μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
446μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
395μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (90,93)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
940μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (48)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
383μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (41)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
509μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (19,53,51,54,50,52)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
769μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (14)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
604μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (15)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
445μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (85)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
568μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (78)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
569μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (79)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
480μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (17,55,56,57,58)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
767μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (10)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
649μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (99)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
536μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (86)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
1.1ms16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (42)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
500μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (75)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
513μs32.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (87)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
469μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (89)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
1.08ms16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (68)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
467μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (108)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
620μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (82)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
631μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (88)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
509μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (110)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-07-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21')
646μs16.04KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT p.* FROM z2pdg_djc2_producers as p WHERE (p.language = 'nl-NL' OR p.language = '*') AND p.published=1 ORDER BY p.ordering asc
382μs16.53KB/modules/mod_djc2producers/helper.php:51CopySELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM z2pdg_djc2_producers as i
INNER JOIN z2pdg_djc2_images as img on img.id=(select id from z2pdg_djc2_images where type='producer' and item_id=i.id order by ordering asc limit 1)
366μs16.13KB/modules/mod_djc2producers/helper.php:60CopySELECT f.*, g.name as group_name, g.label as group_label
FROM z2pdg_djc2_items_extra_fields as f
LEFT JOIN z2pdg_djc2_items_extra_fields_groups as g ON g.id=f.group_id
WHERE f.published = 1 and f.filterable = 1 and (f.type = 'checkbox' or f.type = 'radio' or f.type = 'select' or f.type = 'text' or f.type = 'color' or f.type = 'multicolor' or f.type = 'multiselect') and f.id in (7,11,32)
GROUP BY f.id
ORDER BY IFNULL(g.ordering,0) asc, g.ordering asc, f.ordering asc
957μs16.67KB/modules/mod_djc2filters/helper.php:165CopySELECT *
FROM z2pdg_djc2_items_extra_fields_options
WHERE field_id in (7,11,32)
ORDER BY field_id asc, ordering asc
597μs20.13KB/modules/mod_djc2filters/helper.php:175CopySELECT distinct *
FROM z2pdg_djc2_items_extra_fields_values_text
WHERE field_id in (7,11,32)
ORDER BY field_id asc, value asc
7.53ms16.09KB/modules/mod_djc2filters/helper.php:184CopySELECT c.* FROM z2pdg_djc2_categories AS c WHERE c.published=1 AND c.access IN (1,5) AND (c.language = 'nl-NL' OR c.language = '*') ORDER BY c.parent_id ASC, c.ordering ASC
837μs354KB/administrator/components/com_djcatalog2/lib/categories.php:355CopySELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM z2pdg_djc2_categories as i
INNER JOIN z2pdg_djc2_images as img on img.id=(select id from z2pdg_djc2_images where type='category' and item_id=i.id order by ordering asc limit 1)
WHERE (i.language = 'nl-NL' OR i.language = '*')
531μs16.13KB/administrator/components/com_djcatalog2/lib/categories.php:368CopySELECT 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 (65)) 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-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21') 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 asc
4.31ms16.2KB/modules/mod_djc2filters/helper.php:287CopySELECT ef.id as field_id, ef.name as field_name, opt.id as option_id, opt.value as option_value, count(fv.item_id) as item_count
FROM z2pdg_djc2_items_extra_fields_values_int as fv
INNER JOIN z2pdg_djc2_items_extra_fields as ef on ef.id=fv.field_id
INNER JOIN z2pdg_djc2_items_extra_fields_options as opt on opt.field_id=ef.id and opt.id=fv.value
INNER JOIN (
SELECT distinct i.id
FROM z2pdg_djc2_items as i
INNER JOIN (SELECT ic.item_id FROM z2pdg_djc2_items_categories AS ic INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id WHERE c.published = 1 AND c.access IN (1,5) AND ic.category_id IN (65)) 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-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21') 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 asc
1.36ms16.63KB/modules/mod_djc2filters/helper.php:287CopySELECT ef.id as field_id, ef.name as field_name, opt.id as option_id, opt.value as option_value, count(fv.item_id) as item_count
FROM z2pdg_djc2_items_extra_fields_values_int as fv
INNER JOIN z2pdg_djc2_items_extra_fields as ef on ef.id=fv.field_id
INNER JOIN z2pdg_djc2_items_extra_fields_options as opt on opt.field_id=ef.id and opt.id=fv.value
INNER JOIN (
SELECT distinct i.id
FROM z2pdg_djc2_items as i
INNER JOIN (SELECT ic.item_id FROM z2pdg_djc2_items_categories AS ic INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id WHERE c.published = 1 AND c.access IN (1,5) AND ic.category_id IN (65)) 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-14 09:57:21') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-07-14 09:57:21') 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 asc
5.04ms16.14KB/modules/mod_djc2filters/helper.php:287CopySELECT * FROM z2pdg_acym_configuration
603μs20.05KB/administrator/components/com_acym/Core/joomla/database.php:36CopySELECT * FROM z2pdg_acym_list WHERE type = 'standard'
281μs16.55KB/administrator/components/com_acym/Core/joomla/database.php:36CopySELECT * FROM z2pdg_acym_field
189μs16.42KB/administrator/components/com_acym/Core/joomla/database.php:36CopySELECT * FROM z2pdg_acym_form WHERE active = 1 AND type != 'shortcode'
222μs16.19KB/administrator/components/com_acym/Core/joomla/database.php:36CopySELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count
FROM `z2pdg_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
269μs17.1KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517CopySELECT `value` FROM z2pdg_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"
429μs16.04KB/plugins/system/acymtriggers/acymtriggers.php:436CopySHOW TABLES
856μs24.07KB/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php:513CopySELECT * FROM z2pdg_acym_plugin
168μs16.38KB/administrator/components/com_acym/Core/joomla/database.php:36CopySELECT * FROM z2pdg_acym_plugin
140μs16.38KB/administrator/components/com_acym/Core/joomla/database.php:36CopySELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value`
FROM z2pdg_usergroups AS `groups`
227μs16.34KB/administrator/components/com_acym/Core/joomla/database.php:36CopySELECT `session_id`
FROM `z2pdg_session`
WHERE `session_id` = ?
335μs16.92KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyUPDATE `z2pdg_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
302μs1.97KBParamsCopy