Auteur | Michael Persson |
ISBN/ EAN | 9789463821582 |
Bindwijze | Paperback |
Pagina's | 256 |
Uitgever | Balans |
Verschijningsdatum | maart 2021 |
Taal | Nederlands |
Joomla! Version | 4.3.4 |
PHP Version | 7.4.33 |
Identity | guest |
Response | 200 |
Template | flex |
Database |
|
1 x afterRenderRawModule mod_djc2categories (Onze Rubrieken) (533.29KB) (14.92%) | 71.30ms |
1 x afterRenderRawModule mod_sppagebuilder (Contact Footer Ramsjgat) (3.35MB) (14.22%) | 67.97ms |
1 x beforeRenderRawModule mod_search (Search) (139.56KB) (12.4%) | 59.26ms |
1 x afterInitialise (1.67MB) (10.22%) | 48.81ms |
1 x afterRoute (1.82MB) (8.5%) | 40.62ms |
1 x Before Access::getAssetRules (id:1 name:root.1) (2.02MB) (7.3%) | 34.86ms |
1 x afterRenderRawModule mod_djc2filters (Filteren op:) (862.28KB) (6.45%) | 30.81ms |
1 x afterRenderComponent com_djcatalog2 (380.85KB) (6%) | 28.65ms |
1 x afterRender (490.44KB) (5.84%) | 27.93ms |
1 x Before Access::preloadComponents (all components) (1.4MB) (5.82%) | 27.79ms |
1 x beforeRenderComponent com_djcatalog2 (346.52KB) (1.56%) | 7.47ms |
1 x afterLoad (539.05KB) (1.21%) | 5.80ms |
1 x afterRenderRawModule mod_djc2filters (Filtert) (23.96KB) (0.65%) | 3.11ms |
1 x afterRenderRawModule mod_djc2producers (Boekstatus) (28.75KB) (0.59%) | 2.82ms |
1 x afterRenderRawModule mod_menu (Main Menu) (21.42KB) (0.53%) | 2.54ms |
1 x After Access::preloadComponents (all components) (130.01KB) (0.43%) | 2.05ms |
1 x afterRenderRawModule mod_search (Search) (17KB) (0.43%) | 2.04ms |
1 x afterRenderRawModule mod_custom (Nieuwe Boeken 40%) (3.82KB) (0.24%) | 1.16ms |
1 x afterRenderModule mod_djc2categories (Onze Rubrieken) (2.08KB) (0.13%) | 638μs |
1 x afterDispatch (6.71KB) (0.08%) | 388μs |
1 x afterRenderModule mod_search (Search) (3.14KB) (0.08%) | 388μs |
1 x afterRenderModule mod_djc2filters (Filteren op:) (9.91KB) (0.06%) | 308μs |
1 x afterRenderModule mod_djc2producers (Boekstatus) (3.18KB) (0.04%) | 200μs |
1 x afterRenderModule mod_menu (Main Menu) (2.65KB) (0.03%) | 148μs |
1 x afterRenderModule mod_custom (Nieuwe Boeken 40%) (2.15KB) (0.03%) | 145μs |
1 x afterRenderModule mod_djc2filters (Filtert) (1.3KB) (0.03%) | 136μs |
1 x After Access::getAssetRules (id:166 name:com_djcatalog2) (7.84KB) (0.03%) | 125μs |
1 x afterRenderModule mod_sppagebuilder (Contact Footer Ramsjgat) (17.96KB) (0.03%) | 122μs |
1 x beforeRenderRawModule mod_djc2filters (Filtert) (3.47KB) (0.02%) | 79μs |
1 x beforeRenderRawModule mod_djc2producers (Boekstatus) (14.44KB) (0.02%) | 75μs |
1 x beforeRenderRawModule mod_sppagebuilder (Contact Footer Ramsjgat) (2.02KB) (0.01%) | 53μs |
1 x beforeRenderRawModule mod_djc2filters (Filteren op:) (680B) (0.01%) | 40μs |
1 x Before Access::getAssetRules (id:166 name:com_djcatalog2) (3.65KB) (0.01%) | 35μs |
1 x beforeRenderRawModule mod_menu (Main Menu) (552B) (0.01%) | 29μs |
1 x beforeRenderRawModule mod_custom (Nieuwe Boeken 40%) (3.13KB) (0.01%) | 27μs |
1 x beforeRenderRawModule mod_djc2categories (Onze Rubrieken) (488B) (0.01%) | 24μs |
1 x beforeRenderModule mod_djc2filters (Filtert) (720B) (0%) | 19μs |
1 x After Access::getAssetRules (id:1 name:root.1) (2.22KB) (0%) | 17μs |
1 x beforeRenderModule mod_djc2categories (Onze Rubrieken) (720B) (0%) | 17μs |
1 x beforeRenderModule mod_djc2filters (Filteren op:) (720B) (0%) | 17μs |
1 x beforeRenderModule mod_sppagebuilder (Contact Footer Ramsjgat) (736B) (0%) | 11μs |
1 x beforeRenderModule mod_djc2producers (Boekstatus) (720B) (0%) | 9μs |
1 x beforeRenderModule mod_search (Search) (704B) (0%) | 8μs |
1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%) | 8μs |
1 x beforeRenderModule mod_custom (Nieuwe Boeken 40%) (720B) (0%) | 6μs |
SELECT `data`
FROM `z2pdg_session`
WHERE `session_id` = ?
678μs1.65KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `z2pdg_session`
WHERE `session_id` = :session_id LIMIT 1
397μ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)
498μs1.63KBParamsCopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `z2pdg_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
1.2ms256B/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `z2pdg_viewlevels`
324μ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
301μ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.18ms1.41KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT `template`
FROM `z2pdg_template_styles`
WHERE `client_id` = 0 AND `home` = 1
901μs72B/components/com_sppagebuilder/parser/addon-parser.php:1095CopySELECT `template`
FROM `z2pdg_template_styles`
WHERE `client_id` = 0 AND `home` = 1
1.38ms1.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`
3.28ms2.95KBParams/libraries/src/Menu/SiteMenu.php:166CopySHOW TABLES
2.9ms80B/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php:505CopySELECT * FROM z2pdg_acym_configuration
1.28ms128B/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM z2pdg_acym_plugin
598μs920B/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'acychecker' LIMIT 1
626μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'acymailer' LIMIT 1
565μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'amazon' LIMIT 1
548μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'article' LIMIT 1
696μs3.4KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'birthday' LIMIT 1
611μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'createuser' LIMIT 1
696μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value`
FROM z2pdg_usergroups AS `groups`
528μs456B/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'elasticemail' LIMIT 1
556μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'forward' LIMIT 1
263μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'mailgun' LIMIT 1
268μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'module' LIMIT 1
253μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'online' LIMIT 1
255μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'override' LIMIT 1
248μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'phpmail' LIMIT 1
277μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'postmark' LIMIT 1
258μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'qmail' LIMIT 1
404μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'segment' LIMIT 1
324μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'sendgrid' LIMIT 1
308μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'sendinblue' LIMIT 1
340μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'luecredentials' LIMIT 1
332μs11.9KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'lueintegration' LIMIT 1
330μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'luetransactional' LIMIT 1
283μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'luelist' LIMIT 1
305μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'lueusers' LIMIT 1
285μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'luesender' LIMIT 1
289μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'luecampaign' LIMIT 1
281μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'luewebhooks' LIMIT 1
267μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'sendmail' LIMIT 1
293μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'smtp' LIMIT 1
332μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'statistics' LIMIT 1
281μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'subscriber' LIMIT 1
312μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'subscription' LIMIT 1
290μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'time' LIMIT 1
315μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'user' LIMIT 1
286μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM z2pdg_acym_plugin WHERE folder_name = 'managetext' LIMIT 1
256μs920B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT *
FROM `z2pdg_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
311μ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
641μ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
2.74ms1.31KB/administrator/components/com_djcatalog2/lib/categories.php:355CopySELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM z2pdg_djc2_categories as i
INNER JOIN z2pdg_djc2_images as img on img.id=(select id from z2pdg_djc2_images where type='category' and item_id=i.id order by ordering asc limit 1)
WHERE (i.language = 'nl-NL' OR i.language = '*')
1.56ms352B/administrator/components/com_djcatalog2/lib/categories.php:368Copyselect alias from z2pdg_djc2_items_extra_fields where type='checkbox' or type='radio' or type='select'
713μ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.45ms10.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
438μs64B/components/com_djcatalog2/helpers/user.php:368Copyselect * from z2pdg_djc2_countries where is_default=1
364μs488B/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
431μs536B/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 =2316 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-02-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
GROUP BY i.id
956μs6.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
892μs1.31KB/administrator/components/com_djcatalog2/lib/categories.php:355CopySELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM z2pdg_djc2_categories as i
INNER JOIN z2pdg_djc2_images as img on img.id=(select id from z2pdg_djc2_images where type='category' and item_id=i.id order by ordering asc limit 1)
WHERE (i.language = 'nl-NL' OR i.language = '*')
580μs352B/administrator/components/com_djcatalog2/lib/categories.php:368CopySELECT category_id
FROM z2pdg_djc2_items_categories
WHERE item_id=2316
309μs72B/components/com_djcatalog2/models/item.php:570CopySELECT *
FROM z2pdg_djc2_item_reviews
WHERE item_id=2316 LIMIT 100
205μ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=2316 AND fields.cart_variant=2 AND fields.published = 1
ORDER BY fields.ordering asc, fieldoptions.ordering asc
778μs648B/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=2316 AND (fields.visibility = 1 OR fields.visibility = 3) AND fields.published = 1
ORDER BY fields.ordering asc, fieldoptions.ordering asc
738μs648B/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=2316 AND (fields.visibility = 1 OR fields.visibility = 3) AND fields.published = 1
369μs8.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=2316 AND (fields.visibility = 1 OR fields.visibility = 3) AND fields.published = 1
ORDER BY fields.ordering asc
350μ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=2316
ORDER BY l.ordering
489μs664B/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 = 2316 AND (p.available = 1 OR p.price > 0.0)
ORDER BY cg.ordering
346μs480B/components/com_djcatalog2/models/item.php:647CopySELECT COUNT(*)
FROM z2pdg_djc2_items_combinations
WHERE item_id =2316
187μ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-23 15:47:32') AND (expire_date IS NULL OR expire_date = '0000-00-00 00:00:00' OR expire_date >= '2025-02-23 15:47:32')
ORDER BY ordering
270μs2.14KB/components/com_djcatalog2/helpers/price.php:703CopySELECT *
FROM z2pdg_djc2_items_price_tiers
WHERE item_id=2316
ORDER BY quantity ASC
217μs200B/components/com_djcatalog2/models/item.php:1291CopySELECT sections
FROM `z2pdg_djc2_categories`
WHERE `id` = 90
171μs72B/components/com_djcatalog2/models/item.php:309CopySELECT sections
FROM `z2pdg_djc2_categories`
WHERE `id` = 90
257μ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
867μs1.31KB/administrator/components/com_djcatalog2/lib/categories.php:355CopySELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM z2pdg_djc2_categories as i
INNER JOIN z2pdg_djc2_images as img on img.id=(select id from z2pdg_djc2_images where type='category' and item_id=i.id order by ordering asc limit 1)
549μs352B/administrator/components/com_djcatalog2/lib/categories.php:368Copyselect id, producer_id from z2pdg_djc2_items where published=1
2.38ms136B/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
986μs1.56KB/plugins/djcatalog2/customfield/customfield.php:41CopySELECT related_item
FROM z2pdg_djc2_items_related
WHERE item_id=2316
246μ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
780μ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
655μs336B/components/com_djcatalog2/models/item.php:410CopySELECT sections
FROM `z2pdg_djc2_categories`
WHERE `id` = 90
199μs72B/components/com_djcatalog2/models/item.php:309CopySELECT sections
FROM `z2pdg_djc2_categories`
WHERE `id` = 90
176μ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 = 2316
246μ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
566μs1.65KB/components/com_djcatalog2/models/item.php:458CopySELECT sections
FROM `z2pdg_djc2_categories`
WHERE `id` = 90
191μ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 = 2316
230μ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 = 2316 AND c.type='i'
ORDER BY c.ordering
524μ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
227μ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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32') AND c.published = 1 AND i.cat_id=90 ORDER BY i.name asc , i.ordering, c.ordering ) as k) as subq WHERE subq.id = 2316 ORDER BY subq.position DESC LIMIT 1
1.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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32') AND c.published = 1 AND i.cat_id=90 ORDER BY i.name asc , i.ordering, c.ordering ) as k) as subq WHERE subq.position < 26 ORDER BY subq.position DESC LIMIT 1
1.24ms472B/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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32') AND c.published = 1 AND i.cat_id=90 ORDER BY i.name asc , i.ordering, c.ordering ) as k) as subq WHERE subq.position > 26 ORDER BY subq.position ASC LIMIT 1
1.22ms472B/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
694μ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
357μ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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32') AND i.published = 1 AND i.access IN (1,5) AND i.parent_id=2316 AND (i.language = 'nl-NL' OR i.language = '*')
ORDER BY c.parent_id asc, c.ordering asc, i.ordering asc
1.92ms6.4KB/components/com_djcatalog2/models/items.php:286CopySELECT * FROM z2pdg_djc2_images WHERE item_id=2316 AND type='item' AND exclude=0 ORDER BY ordering ASC, name ASC
371μs760B/administrator/components/com_djcatalog2/helpers/image.php:80CopyUPDATE z2pdg_djc2_items SET hits = hits + 1 WHERE id = 2316
1.48ms8BCopySELECT `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.59ms2.64KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT * FROM z2pdg_djc2_videos WHERE item_id=2316 AND type='item' ORDER BY ordering ASC
423μ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.13ms5KBParams/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
899μs5KBParams/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.17ms5KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT * FROM z2pdg_djc2_files WHERE item_id=2316 AND type='item' AND access IN (1,5) ORDER BY ordering ASC, name ASC
389μs928B/administrator/components/com_djcatalog2/helpers/file.php:76CopySELECT *
FROM `z2pdg_sppagebuilder`
WHERE `extension` = 'mod_sppagebuilder' AND `extension_view` = 'module' AND `view_id` = '164'
3.14ms1.84KB/modules/mod_sppagebuilder/helper.php:49CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `z2pdg_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
871μs144B/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:123CopySELECT `template`
FROM `z2pdg_template_styles`
WHERE `client_id` = 0 AND `home` = 1
842μ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.19ms400B/components/com_sppagebuilder/builder/classes/base.php:326CopySELECT a.enabled
FROM `z2pdg_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'
1ms64B/components/com_sppagebuilder/builder/classes/base.php:872CopySELECT a.enabled
FROM `z2pdg_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'
879μs64B/components/com_sppagebuilder/builder/classes/base.php:872CopySELECT a.enabled
FROM `z2pdg_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'
856μ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')
873μs64B/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'
712μs72B/components/com_sppagebuilder/builder/classes/base.php:849CopySELECT `id`,`name`
FROM `z2pdg_acym_list`
WHERE `active` = '1'
ORDER BY name DESC
719μs128B/components/com_sppagebuilder/builder/classes/base.php:798CopySELECT `template`
FROM `z2pdg_template_styles`
WHERE `client_id` = 0 AND `home` = 1
1.05ms72B/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.5ms1.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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
1.62ms80B/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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
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 (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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
3.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 (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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
1.49ms80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
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 (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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
2.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 (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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
1.61ms80B/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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
9.17ms80B/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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
3.72ms80B/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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
1.62ms80B/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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
2.47ms80B/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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
739μ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 (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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
602μ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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
612μ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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
987μ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 (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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
841μ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 (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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
608μ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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
515μ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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
3.12ms80B/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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
1.09ms80B/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 (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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
549μ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 (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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
490μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (41)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-02-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
649μ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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
895μ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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
567μ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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
530μ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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
836μ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 (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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
761μ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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
498μ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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
782μ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 (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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
640μ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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
512μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (86)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-02-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
901μ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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
520μs80B/administrator/components/com_djcatalog2/lib/categories.php:172CopySELECT COUNT(DISTINCT i.id)
FROM z2pdg_djc2_items AS i
INNER JOIN (
SELECT ic.item_id
FROM z2pdg_djc2_items_categories AS ic
INNER JOIN z2pdg_djc2_categories AS c ON c.id=ic.category_id
WHERE c.published = 1 AND ic.category_id IN (75)) AS category_filter ON i.id = category_filter.item_id
WHERE i.published = 1 AND i.parent_id = 0 AND (i.publish_up IS NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-02-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
461μ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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
474μ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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
458μ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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
432μ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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
487μ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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
460μ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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
456μ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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32')
418μ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
380μ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)
364μ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
972μ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
624μ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
8.11ms264B/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
914μs1.31KB/administrator/components/com_djcatalog2/lib/categories.php:355CopySELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM z2pdg_djc2_categories as i
INNER JOIN z2pdg_djc2_images as img on img.id=(select id from z2pdg_djc2_images where type='category' and item_id=i.id order by ordering asc limit 1)
WHERE (i.language = 'nl-NL' OR i.language = '*')
668μ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 (90,93)) 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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32') 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
2.24ms360B/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 (90,93)) 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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32') 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.03ms360B/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 (90,93)) 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-23 15:47:32') AND (i.publish_down IS NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-02-23 15:47:32') 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
2.02ms360B/modules/mod_djc2filters/helper.php:287CopySELECT * FROM z2pdg_acym_list WHERE type = 'standard'
939μs1.06KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM z2pdg_acym_field
498μs1.23KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM z2pdg_acym_form WHERE active = 1 AND type != 'shortcode'
557μ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
915μ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
905μs2.57KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391CopySELECT `value` FROM z2pdg_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"
678μs64B/plugins/system/acymtriggers/acymtriggers.php:156CopySHOW TABLES
1.36ms80B/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php:505Copy