Winnaar Libris Geschiedenis Prijs & de Nederlandse Biografieprijs 2022.
Omstreeks 1560 was Willem van Oranje de rijkste en meest veelbelovende edelman van de Nederlanden. Nog geen tien jaar later was hij zo goed als alles kwijt: zijn bezit, zijn macht en ook zijn goede reputatie. Wat was er gebeurd?
Oranje had zich gekeerd tegen het bewind van de Spaanse koning Filips II, dat in zijn ogen despotisch en geldbelust was. Hij vond medestanders onder andere edelen, en ook onder gewone burgers. Vanaf 1566, met de Beeldenstorm, kwamen de Nederlanden in opstand. Filips II stuurde er de gevreesde hertog van Alva met een grote troepenmacht op af. Die confisqueerde alle bezit van Oranje. Dit was voor Oranje het moment om zelf de wapens op te pakken: het begin van een uitputtingsslag die de Nederlanden in een diepe crisis stortte. Er vielen tienduizenden doden – denk aan de gruwelijke slachtpartijen in Mechelen, Zutphen, Naarden, Haarlem en Maastricht. Het maakte de opstandelingen onder aanvoering van Oranje alleen maar vastberadener. Het bewind van Filips II begon te wankelen. Wat dreef Oranje? Hij was geen heilige en riep in zijn tijd meer weerzin op dan wel wordt aangenomen. Protestantse bolwerken als Gent en Antwerpen, die ooit zijn trouwste bondgenoten waren, keerden zich uiteindelijk van hem af.
In De zwijger ontrafelt René van Stipriaan de duizelingwekkende loopbaan van een van de meest onverzettelijke figuren uit de wereldgeschiedenis: zijn ambities, successen, manipulaties, nederlagen. En ook de spanningen in zijn familie, zijn bizarre huwelijksleven – en zijn neiging om, als het erop aankwam, in het verborgene te opereren. René van Stipriaan vertelt hier over De zwijger.
‘Een prachtige biografie vol persoonlijke details én heldere beschrijvingen van de wereld waarin Willem van Oranje leefde en handelde.’ Rob Hartmans, NRC Handelsblad •••••
‘Het is niet zonder risico om je aan het leven van Willem van Oranje te wagen: het is een titanenklus. De nieuwe biografie van René van Stipriaan is dik, vlot geschreven en zeer lezenswaardig.’ Martin Sommer, de Volkskrant ****
‘ De zwijger wemelt van de nieuwe details en inzichten. Alles wijst erop dat dit voor de komende decennia het standaardwerk zal worden over Willem van Oranje.’ Geert Mak
‘Deze nieuwe biografie zit aangenaam dicht op de huid van de Vader des Vaderlands.’ Paul van der Steen, Trouw
‘Een meesterwerk. Verrassende nieuwe inzichten vanuit een hedendaags perspectief. Leesbaar als een roman.’ Henk van Nierop
‘Een harmonieuze stijl en een knappe compositie.’ Willem Bouwman, Nederlands Dagblad
Auteur | René Stipriaan |
ISBN/ EAN | 9789021402758 |
Bindwijze | Hardback |
Pagina's | 936 |
Uitgever | Querido |
Verschijningsdatum | november 2021 |
Taal | Nederlands |
Joomla! Version | 4.3.4 |
PHP Version | 7.4.33 |
Identity | guest |
Response | 200 |
Template | flex |
Database |
|
1 x afterRenderRawModule mod_sppagebuilder (Contact Footer Ramsjgat) (3.35MB) (18.73%) | 123.23ms |
1 x afterRenderRawModule mod_djc2categories (Onze Rubrieken) (521.58KB) (17.3%) | 113.85ms |
1 x beforeRenderRawModule mod_search (Search) (139.56KB) (13.81%) | 90.90ms |
1 x Before Access::getAssetRules (id:1 name:root.1) (2.02MB) (9.48%) | 62.39ms |
1 x afterInitialise (1.67MB) (7.41%) | 48.76ms |
1 x afterRenderRawModule mod_djc2filters (Filteren op:) (863.66KB) (7.39%) | 48.60ms |
1 x afterRoute (1.82MB) (6.17%) | 40.62ms |
1 x afterRender (490.5KB) (5.7%) | 37.50ms |
1 x afterRenderComponent com_djcatalog2 (380.66KB) (5.56%) | 36.56ms |
1 x Before Access::preloadComponents (all components) (1.4MB) (2.83%) | 18.62ms |
1 x beforeRenderComponent com_djcatalog2 (346.52KB) (0.92%) | 6.06ms |
1 x afterLoad (539.05KB) (0.5%) | 3.32ms |
1 x afterRenderRawModule mod_djc2filters (Filtert) (23.96KB) (0.49%) | 3.20ms |
1 x afterRenderRawModule mod_djc2producers (Boekstatus) (28.75KB) (0.45%) | 2.94ms |
1 x afterRenderRawModule mod_menu (Main Menu) (21.42KB) (0.39%) | 2.59ms |
1 x After Access::preloadComponents (all components) (130.01KB) (0.37%) | 2.42ms |
1 x afterRenderRawModule mod_search (Search) (17.03KB) (0.32%) | 2.14ms |
1 x afterRenderRawModule mod_custom (Nieuwe Boeken 40%) (3.82KB) (0.2%) | 1.30ms |
1 x afterRenderModule mod_search (Search) (3.14KB) (0.06%) | 422μs |
1 x afterRenderModule mod_djc2categories (Onze Rubrieken) (2.08KB) (0.05%) | 349μs |
1 x afterDispatch (6.71KB) (0.05%) | 348μs |
1 x afterRenderModule mod_djc2filters (Filteren op:) (9.91KB) (0.05%) | 322μs |
1 x afterRenderModule mod_djc2producers (Boekstatus) (3.18KB) (0.03%) | 174μs |
1 x afterRenderModule mod_custom (Nieuwe Boeken 40%) (2.15KB) (0.02%) | 161μs |
1 x afterRenderModule mod_menu (Main Menu) (2.65KB) (0.02%) | 148μs |
1 x afterRenderModule mod_sppagebuilder (Contact Footer Ramsjgat) (17.96KB) (0.02%) | 130μs |
1 x afterRenderModule mod_djc2filters (Filtert) (1.3KB) (0.02%) | 125μs |
1 x After Access::getAssetRules (id:166 name:com_djcatalog2) (7.84KB) (0.02%) | 124μs |
1 x beforeRenderRawModule mod_djc2filters (Filtert) (3.47KB) (0.01%) | 79μs |
1 x beforeRenderRawModule mod_sppagebuilder (Contact Footer Ramsjgat) (2.02KB) (0.01%) | 52μs |
1 x beforeRenderRawModule mod_djc2producers (Boekstatus) (14.44KB) (0.01%) | 43μs |
1 x Before Access::getAssetRules (id:166 name:com_djcatalog2) (3.65KB) (0.01%) | 38μs |
1 x beforeRenderRawModule mod_djc2filters (Filteren op:) (680B) (0.01%) | 38μs |
1 x beforeRenderRawModule mod_menu (Main Menu) (552B) (0%) | 30μs |
1 x beforeRenderRawModule mod_custom (Nieuwe Boeken 40%) (3.13KB) (0%) | 29μs |
1 x beforeRenderRawModule mod_djc2categories (Onze Rubrieken) (488B) (0%) | 24μs |
1 x After Access::getAssetRules (id:1 name:root.1) (2.22KB) (0%) | 22μs |
1 x beforeRenderModule mod_djc2filters (Filteren op:) (720B) (0%) | 16μs |
1 x beforeRenderModule mod_sppagebuilder (Contact Footer Ramsjgat) (736B) (0%) | 13μs |
1 x beforeRenderModule mod_djc2categories (Onze Rubrieken) (720B) (0%) | 11μs |
1 x beforeRenderModule mod_djc2filters (Filtert) (720B) (0%) | 9μs |
1 x beforeRenderModule mod_djc2producers (Boekstatus) (720B) (0%) | 9μs |
1 x beforeRenderModule mod_custom (Nieuwe Boeken 40%) (720B) (0%) | 8μs |
1 x beforeRenderModule mod_search (Search) (704B) (0%) | 8μs |
1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%) | 7μs |
SELECT `data`
FROM `z2pdg_session`
WHERE `session_id` = ?
423μs1.65KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `z2pdg_session`
WHERE `session_id` = :session_id LIMIT 1
318μs1016BParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `z2pdg_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
308μs1.63KBParamsCopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `z2pdg_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
857μs256B/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `z2pdg_viewlevels`
308μs768B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `z2pdg_usergroups` AS `a`
LEFT JOIN `z2pdg_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
392μs1.04KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `z2pdg_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`
1.78ms1.41KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT `template`
FROM `z2pdg_template_styles`
WHERE `client_id` = 0 AND `home` = 1
660μs72B/components/com_sppagebuilder/parser/addon-parser.php:1095CopySELECT `template`
FROM `z2pdg_template_styles`
WHERE `client_id` = 0 AND `home` = 1
704μs1.32KB/plugins/system/helix3/helix3.php:247CopySELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component`
FROM `z2pdg_menu` AS `m`
LEFT JOIN `z2pdg_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id`
WHERE
(
(`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2)
ORDER BY `m`.`lft`
1.77ms2.95KBParams/libraries/src/Menu/SiteMenu.php:166CopySHOW TABLES
3.17ms80B/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php:505CopySELECT * FROM z2pdg_acym_configuration
1.01ms128B/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM z2pdg_acym_plugin
532μs920B/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'acychecker' LIMIT 1
457μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'acymailer' LIMIT 1
487μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'amazon' LIMIT 1
251μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'article' LIMIT 1
267μs3.4KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'birthday' LIMIT 1
217μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'createuser' LIMIT 1
268μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value`
FROM z2pdg_usergroups AS `groups`
214μs456B/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'elasticemail' LIMIT 1
233μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'forward' LIMIT 1
217μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'mailgun' LIMIT 1
196μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'module' LIMIT 1
244μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'online' LIMIT 1
201μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'override' LIMIT 1
226μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'phpmail' LIMIT 1
194μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'postmark' LIMIT 1
239μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'qmail' LIMIT 1
193μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'segment' LIMIT 1
197μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'sendgrid' LIMIT 1
189μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'sendinblue' LIMIT 1
203μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'luecredentials' LIMIT 1
269μs11.9KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'lueintegration' LIMIT 1
272μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'luetransactional' LIMIT 1
299μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'luelist' LIMIT 1
258μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'lueusers' LIMIT 1
337μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'luesender' LIMIT 1
294μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'luecampaign' LIMIT 1
274μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'luewebhooks' LIMIT 1
227μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'sendmail' LIMIT 1
236μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'smtp' LIMIT 1
196μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'statistics' LIMIT 1
209μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'subscriber' LIMIT 1
182μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'subscription' LIMIT 1
182μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'time' LIMIT 1
184μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'user' LIMIT 1
180μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'managetext' LIMIT 1
174μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT *
FROM `z2pdg_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
373μs960B/libraries/src/Language/LanguageHelper.php:142CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `z2pdg_template_styles` AS `s`
LEFT JOIN `z2pdg_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id`
WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1
549μs400B/administrator/components/com_templates/src/Model/StyleModel.php:771CopySELECT 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
1.36ms1.31KB/administrator/components/com_djcatalog2/lib/categories.php:355CopySELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM z2pdg_djc2_categories as i
INNER JOIN z2pdg_djc2_images as img on img.id=(select id from z2pdg_djc2_images where type='category' and item_id=i.id order by ordering asc limit 1)
WHERE (i.language = 'nl-NL' OR i.language = '*')
792μs352B/administrator/components/com_djcatalog2/lib/categories.php:368Copyselect alias from z2pdg_djc2_items_extra_fields where type='checkbox' or type='radio' or type='select'
756μs64B/components/com_djcatalog2/controller.php:133CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `z2pdg_assets`
WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47)
1.85ms10.12KBParams/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
1.18ms64B/components/com_djcatalog2/helpers/user.php:368Copyselect * from z2pdg_djc2_countries where is_default=1
1.06ms488B/components/com_djcatalog2/helpers/user.php:429CopySELECT vrul.id as rule_id, vrul.name, vrat.*
FROM z2pdg_djc2_vat_rules AS vrul
INNER JOIN z2pdg_djc2_vat_rules_xref AS vx ON vx.rule_id = vrul.id
INNER JOIN z2pdg_djc2_vat_rates AS vrat ON vx.rate_id = vrat.id
WHERE vrat.country_id=0 AND vrat.state_id=0 AND (vrat.client_type='A' OR vrat.client_type='R')
ORDER BY vrat.client_type ASC, vrat.country_id ASC, vrat.state_id ASC
1.14ms536B/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 =1502 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
GROUP BY i.id
3.72ms6.36KB/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
2.02ms1.31KB/administrator/components/com_djcatalog2/lib/categories.php:355CopySELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM z2pdg_djc2_categories as i
INNER JOIN z2pdg_djc2_images as img on img.id=(select id from z2pdg_djc2_images where type='category' and item_id=i.id order by ordering asc limit 1)
WHERE (i.language = 'nl-NL' OR i.language = '*')
2ms352B/administrator/components/com_djcatalog2/lib/categories.php:368CopySELECT category_id
FROM z2pdg_djc2_items_categories
WHERE item_id=1502
788μs72B/components/com_djcatalog2/models/item.php:570CopySELECT *
FROM z2pdg_djc2_item_reviews
WHERE item_id=1502 LIMIT 100
836μs616B/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=1502 AND fields.cart_variant=2 AND fields.published = 1
ORDER BY fields.ordering asc, fieldoptions.ordering asc
2.63ms648B/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=1502 AND (fields.visibility = 1 OR fields.visibility = 3) AND fields.published = 1
ORDER BY fields.ordering asc, fieldoptions.ordering asc
2.5ms648B/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=1502 AND (fields.visibility = 1 OR fields.visibility = 3) AND fields.published = 1
1.12ms8.53KB/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=1502 AND (fields.visibility = 1 OR fields.visibility = 3) AND fields.published = 1
ORDER BY fields.ordering asc
981μs544B/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=1502
ORDER BY l.ordering
1.53ms664B/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 = 1502 AND (p.available = 1 OR p.price > 0.0)
ORDER BY cg.ordering
493μs480B/components/com_djcatalog2/models/item.php:647CopySELECT COUNT(*)
FROM z2pdg_djc2_items_combinations
WHERE item_id =1502
254μs72B/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-02-25 20:57:07') AND (expire_date IS NULL OR expire_date = '0000-00-00 00:00:00' OR expire_date >= '2025-02-25 20:57:07')
ORDER BY ordering
489μs2.14KB/components/com_djcatalog2/helpers/price.php:703CopySELECT *
FROM z2pdg_djc2_items_price_tiers
WHERE item_id=1502
ORDER BY quantity ASC
524μs200B/components/com_djcatalog2/models/item.php:1291CopySELECT sections
FROM `z2pdg_djc2_categories`
WHERE `id` = 12
256μs72B/components/com_djcatalog2/models/item.php:309CopySELECT sections
FROM `z2pdg_djc2_categories`
WHERE `id` = 12
244μs72B/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
1.19ms1.31KB/administrator/components/com_djcatalog2/lib/categories.php:355CopySELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM z2pdg_djc2_categories as i
INNER JOIN z2pdg_djc2_images as img on img.id=(select id from z2pdg_djc2_images where type='category' and item_id=i.id order by ordering asc limit 1)
713μs352B/administrator/components/com_djcatalog2/lib/categories.php:368Copyselect id, producer_id from z2pdg_djc2_items where published=1
2.57ms136B/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
1.3ms1.56KB/plugins/djcatalog2/customfield/customfield.php:41CopySELECT related_item
FROM z2pdg_djc2_items_related
WHERE item_id=1502
372μs72B/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
926μs1.65KB/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
755μs336B/components/com_djcatalog2/models/item.php:410CopySELECT sections
FROM `z2pdg_djc2_categories`
WHERE `id` = 12
263μs72B/components/com_djcatalog2/models/item.php:309CopySELECT sections
FROM `z2pdg_djc2_categories`
WHERE `id` = 12
202μs72B/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 = 1502
372μs888B/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
659μs1.65KB/components/com_djcatalog2/models/item.php:458CopySELECT sections
FROM `z2pdg_djc2_categories`
WHERE `id` = 12
216μs72B/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 = 1502
280μs888B/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 = 1502 AND c.type='i'
ORDER BY c.ordering
649μs832B/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
381μs968B/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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07') AND c.published = 1 AND i.cat_id=12 ORDER BY i.name asc , i.ordering, c.ordering ) as k) as subq WHERE subq.id = 1502 ORDER BY subq.position DESC LIMIT 1
2.53ms72B/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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07') AND c.published = 1 AND i.cat_id=12 ORDER BY i.name asc , i.ordering, c.ordering ) as k) as subq WHERE subq.position < 74 ORDER BY subq.position DESC LIMIT 1
1.84ms472B/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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07') AND c.published = 1 AND i.cat_id=12 ORDER BY i.name asc , i.ordering, c.ordering ) as k) as subq WHERE subq.position > 74 ORDER BY subq.position ASC LIMIT 1
1.74ms472B/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
906μs1.65KB/components/com_djcatalog2/models/items.php:1110CopySELECT o.id, o.field_id
FROM z2pdg_djc2_items_extra_fields_options AS o
ORDER BY o.field_id asc, o.ordering asc
406μs136B/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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07') AND i.published = 1 AND i.access IN (1,5) AND i.parent_id=1502 AND (i.language = 'nl-NL' OR i.language = '*')
ORDER BY c.parent_id asc, c.ordering asc, i.ordering asc
2.1ms6.4KB/components/com_djcatalog2/models/items.php:286CopySELECT * FROM z2pdg_djc2_images WHERE item_id=1502 AND type='item' AND exclude=0 ORDER BY ordering ASC, name ASC
548μs760B/administrator/components/com_djcatalog2/helpers/image.php:80CopyUPDATE z2pdg_djc2_items SET hits = hits + 1 WHERE id = 1502
1.26ms8BCopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `z2pdg_modules` AS `m`
LEFT JOIN `z2pdg_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `z2pdg_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id`
WHERE
(
(
(`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND
(`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0)
ORDER BY `m`.`position`,`m`.`ordering`
1.67ms2.64KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT * FROM z2pdg_djc2_videos WHERE item_id=1502 AND type='item' ORDER BY ordering ASC
572μs808B/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
1.62ms5KBParams/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
1ms5KBParams/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
1.11ms5KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT * FROM z2pdg_djc2_files WHERE item_id=1502 AND type='item' AND access IN (1,5) ORDER BY ordering ASC, name ASC
512μs928B/administrator/components/com_djcatalog2/helpers/file.php:76CopySELECT *
FROM `z2pdg_sppagebuilder`
WHERE `extension` = 'mod_sppagebuilder' AND `extension_view` = 'module' AND `view_id` = '164'
2.93ms1.84KB/modules/mod_sppagebuilder/helper.php:49CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `z2pdg_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
845μs144B/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:123CopySELECT `template`
FROM `z2pdg_template_styles`
WHERE `client_id` = 0 AND `home` = 1
732μs72B/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
1.93ms400B/components/com_sppagebuilder/builder/classes/base.php:326CopySELECT a.enabled
FROM `z2pdg_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'
1.01ms64B/components/com_sppagebuilder/builder/classes/base.php:872CopySELECT a.enabled
FROM `z2pdg_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'
788μs64B/components/com_sppagebuilder/builder/classes/base.php:872CopySELECT a.enabled
FROM `z2pdg_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'
863μs64B/components/com_sppagebuilder/builder/classes/base.php:872CopySELECT a.enabled
FROM `z2pdg_extensions` AS `a`
WHERE (`a`.`element` = 'com_acymailing' OR `a`.`element` = 'com_acym')
1.21ms64B/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'
832μs72B/components/com_sppagebuilder/builder/classes/base.php:849CopySELECT `id`,`name`
FROM `z2pdg_acym_list`
WHERE `active` = '1'
ORDER BY name DESC
627μs128B/components/com_sppagebuilder/builder/classes/base.php:798CopySELECT `template`
FROM `z2pdg_template_styles`
WHERE `client_id` = 0 AND `home` = 1
1.03ms72B/components/com_sppagebuilder/builder/classes/base.php:85CopySELECT f.*, g.name as group_name, g.label as group_label
FROM z2pdg_djc2_items_extra_fields as f
LEFT JOIN z2pdg_djc2_items_extra_fields_groups as g ON g.id=f.group_id
WHERE f.published = 1 and f.filterable = 1 and (f.type = 'checkbox' or f.type = 'radio' or f.type = 'select' or f.type = 'text' or f.type = 'color' or f.type = 'multicolor' or f.type = 'multiselect') and (g.id in (4))
GROUP BY f.id
ORDER BY IFNULL(g.ordering,0) asc, g.ordering asc, f.ordering asc
1.53ms1.61KB/modules/mod_djc2filters/helper.php:165CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (36)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
1.56ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
1.22ms80B/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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
3.67ms80B/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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
2.08ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
1.75ms80B/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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
2.24ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
1.39ms80B/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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
1.22ms80B/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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
1.54ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
830μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (21,74)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
1.02ms80B/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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
4.9ms80B/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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
1.73ms80B/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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
797μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
772μs16.08KB/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
1.1ms80B/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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
1.03ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
705μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
656μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (2,59,104,80,60,61,62,98,103,81,63,76,64,66,109,65,77)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
3.23ms80B/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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
2.59ms80B/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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
1.36ms80B/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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
738μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (19,53,51,54,50,52)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
921μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
589μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (15)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
555μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
1.85ms80B/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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
900μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (79)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
524μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (17,55,56,57,58)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
1.79ms80B/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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
617μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (99)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
1.03ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
900μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (42)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
760μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (75)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
564μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (87)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
510μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (89)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
455μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (68)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
438μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (108)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
591μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (82)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
505μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (88)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
492μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (110)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07')
530μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT p.* FROM z2pdg_djc2_producers as p WHERE (p.language = 'nl-NL' OR p.language = '*') AND p.published=1 ORDER BY p.ordering asc
404μs1.05KB/modules/mod_djc2producers/helper.php:51CopySELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM z2pdg_djc2_producers as i
INNER JOIN z2pdg_djc2_images as img on img.id=(select id from z2pdg_djc2_images where type='producer' and item_id=i.id order by ordering asc limit 1)
615μs352B/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
998μs1.61KB/modules/mod_djc2filters/helper.php:165CopySELECT *
FROM z2pdg_djc2_items_extra_fields_options
WHERE field_id in (7,11,32)
ORDER BY field_id asc, ordering asc
728μs336B/modules/mod_djc2filters/helper.php:175CopySELECT distinct *
FROM z2pdg_djc2_items_extra_fields_values_text
WHERE field_id in (7,11,32)
ORDER BY field_id asc, value asc
10.67ms264B/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
1.13ms1.31KB/administrator/components/com_djcatalog2/lib/categories.php:355CopySELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM z2pdg_djc2_categories as i
INNER JOIN z2pdg_djc2_images as img on img.id=(select id from z2pdg_djc2_images where type='category' and item_id=i.id order by ordering asc limit 1)
WHERE (i.language = 'nl-NL' OR i.language = '*')
662μs352B/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 (12)) 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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07') 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
6.61ms360B/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 (12)) 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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07') 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
2.38ms360B/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 (12)) 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-02-25 20:57:07') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-25 20:57:07') 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
12.52ms360B/modules/mod_djc2filters/helper.php:287CopySELECT * FROM z2pdg_acym_list WHERE type = 'standard'
491μs1.06KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM z2pdg_acym_field
292μs1.23KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM z2pdg_acym_form WHERE active = 1 AND type != 'shortcode'
745μs544B/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor`
FROM `z2pdg_scheduler_tasks` AS `a`
LEFT JOIN `z2pdg_users` AS `uc` ON `uc`.`id` = `a`.`checked_out`
WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now
ORDER BY `a`.`title` asc
704μs2.8KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391CopySELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor`
FROM `z2pdg_scheduler_tasks` AS `a`
LEFT JOIN `z2pdg_users` AS `uc` ON `uc`.`id` = `a`.`checked_out`
WHERE `a`.`state` = :state AND `a`.`locked` IS NOT NULL
ORDER BY `a`.`title` asc
628μs2.57KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391CopySELECT `value` FROM z2pdg_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"
1.85ms64B/plugins/system/acymtriggers/acymtriggers.php:156CopySHOW TABLES
2.6ms80B/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php:505Copy