Heksen in het bos
Heksen
Op ontdekking in het bos (maand september)
Wekelijks trekken we op avontuur naar het bos.
Kijk je eens mee wat we deze maand zoal beleefden?
Joomla! Version | 4.3.4 |
PHP Version | 8.1.31 |
Identity | guest |
Response | 200 |
Template | j51_chloe |
Database |
|
1 x afterRenderComponent com_content (1.17MB) (34.76%) | 54.50ms |
1 x afterInitialise (844.46KB) (15.07%) | 23.63ms |
1 x afterRender (211.09KB) (12.08%) | 18.94ms |
1 x afterRenderRawModule mod_articles_category (Sport nieuws) (72.19KB) (5.8%) | 9.09ms |
1 x afterLoad (541.66KB) (4.03%) | 6.32ms |
1 x afterRenderRawModule mod_articles_category (Lagere school nieuws) (67.82KB) (3.46%) | 5.42ms |
1 x afterRenderRawModule mod_articles_category (Kleuterschool nieuws) (19.2KB) (2.8%) | 4.39ms |
1 x beforeRenderComponent com_content (104.8KB) (2.26%) | 3.54ms |
1 x afterRoute (192.08KB) (2.15%) | 3.37ms |
1 x Before Access::getAssetRules (id:8 name:com_content) (41.84KB) (1.73%) | 2.71ms |
1 x afterDispatch (316.95KB) (1.26%) | 1.98ms |
1 x afterRenderRawModule mod_menu () (241.01KB) (1.19%) | 1.86ms |
1 x beforeRenderRawModule mod_articles_category (Sport nieuws) (20.8KB) (1.09%) | 1.70ms |
1 x Before Access::preloadComponents (all components) (135.34KB) (1.08%) | 1.70ms |
1 x beforeRenderRawModule mod_menu () (77.27KB) (0.88%) | 1.38ms |
1 x After Access::preloadPermissions (com_content) (232.95KB) (0.8%) | 1.25ms |
1 x afterRenderRawModule mod_menu () (233.66KB) (0.71%) | 1.12ms |
1 x After Access::preloadComponents (all components) (112.59KB) (0.61%) | 949μs |
1 x afterRenderRawModule mod_j51layerslideshow (J51_LayerSlideshow) (17.45KB) (0.4%) | 627μs |
1 x beforeRenderRawModule mod_custom (logo nieuwsbrief) (208B) (0.35%) | 545μs |
1 x beforeRenderRawModule mod_j51layerslideshow (J51_LayerSlideshow) (15.66KB) (0.32%) | 501μs |
1 x beforeRenderRawModule mod_custom (logo menu) (584B) (0.28%) | 440μs |
1 x afterRenderRawModule mod_custom (Logo STJ Side) (3.87KB) (0.24%) | 382μs |
1 x afterRenderRawModule mod_menu () (1.52KB) (0.22%) | 350μs |
1 x beforeRenderRawModule mod_custom (Logo STJ Side) (14.34KB) (0.2%) | 309μs |
1 x afterRenderModule mod_articles_category (Sport nieuws) (3.19KB) (0.1%) | 156μs |
1 x After Access::getAssetRules (id:714 name:com_content.category.69) (8.56KB) (0.05%) | 83μs |
1 x beforeRenderRawModule mod_articles_category (Lagere school nieuws) (1.45KB) (0.05%) | 81μs |
1 x afterRenderRawModule mod_custom (logo nieuwsbrief) (976B) (0.04%) | 67μs |
1 x afterRenderModule mod_menu () (7.1KB) (0.04%) | 66μs |
1 x afterRenderRawModule mod_custom (logo menu) (976B) (0.04%) | 64μs |
1 x beforeRenderRawModule mod_articles_category (Kleuterschool nieuws) (608B) (0.03%) | 50μs |
1 x afterRenderModule mod_articles_category (Kleuterschool nieuws) (3.2KB) (0.03%) | 45μs |
1 x afterRenderModule mod_articles_category (Lagere school nieuws) (5.7KB) (0.03%) | 45μs |
1 x afterRenderModule mod_j51layerslideshow (J51_LayerSlideshow) (5.95KB) (0.03%) | 40μs |
1 x Before Access::getAssetRules (id:714 name:com_content.category.69) (18.8KB) (0.02%) | 39μs |
1 x afterRenderModule mod_custom (Logo STJ Side) (2.26KB) (0.02%) | 39μs |
1 x afterRenderModule mod_custom (logo menu) (2.32KB) (0.02%) | 33μs |
3 x beforeRenderModule mod_menu () (696B) (0.02%) | 33μs |
1 x afterRenderModule mod_custom (logo nieuwsbrief) (2.32KB) (0.02%) | 33μs |
1 x afterRenderModule mod_menu () (5.27KB) (0.02%) | 31μs |
1 x afterRenderModule mod_menu () (2.59KB) (0.02%) | 30μs |
1 x beforeRenderRawModule mod_menu () (3.38KB) (0.02%) | 27μs |
1 x beforeRenderRawModule mod_menu () (3.48KB) (0.01%) | 23μs |
1 x Before Access::preloadPermissions (com_content) (3.85KB) (0.01%) | 18μs |
1 x beforeRenderModule mod_articles_category (Sport nieuws) (720B) (0.01%) | 14μs |
1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%) | 10μs |
1 x beforeRenderModule mod_articles_category (Kleuterschool nieuws) (736B) (0%) | 7μs |
1 x beforeRenderModule mod_articles_category (Lagere school nieuws) (736B) (0%) | 6μs |
1 x beforeRenderModule mod_custom (Logo STJ Side) (720B) (0%) | 5μs |
1 x beforeRenderModule mod_j51layerslideshow (J51_LayerSlideshow) (736B) (0%) | 5μs |
1 x beforeRenderModule mod_custom (logo nieuwsbrief) (720B) (0%) | 4μs |
1 x beforeRenderModule mod_custom (logo menu) (720B) (0%) | 4μs |
SELECT @@SESSION.sql_mode;
271μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `kbk_session`
WHERE `session_id` = ?
282μs1.68KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `kbk_session`
WHERE `session_id` = :session_id LIMIT 1
126μs1.9KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `kbk_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
2.11ms928BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `kbk_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
683μs3.9KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `kbk_viewlevels`
205μs17.01KB/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `kbk_usergroups` AS `a`
LEFT JOIN `kbk_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
252μs1.68KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `kbk_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`
876μs3.84KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT `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 `kbk_menu` AS `m`
LEFT JOIN `kbk_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`
969μs8.72KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT *
FROM `kbk_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
182μs3.17KB/libraries/src/Language/LanguageHelper.php:142CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `kbk_template_styles` AS `s`
LEFT JOIN `kbk_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
255μs9.52KB/administrator/components/com_templates/src/Model/StyleModel.php:771CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `kbk_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)
538μs23.35KBParams/libraries/src/Access/Access.php:357CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `kbk_assets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0
537μs18.22KBParams/libraries/src/Access/Access.php:301CopySELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug`,(
SELECT COUNT(`i`.`id`)
FROM `kbk_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `kbk_categories` AS `s`
INNER JOIN `kbk_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
1.43ms7.3KBParams/libraries/src/Categories/Categories.php:375CopySELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count`
FROM `kbk_content` AS `a`
LEFT JOIN `kbk_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `kbk_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `kbk_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `kbk_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `kbk_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `kbk_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
INNER JOIN `kbk_contentitem_tag_map` AS `tagmap` ON `tagmap`.`content_item_id` = `a`.`id` AND `tagmap`.`type_alias` = 'com_content.article'
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`catid` = :categoryId OR `a`.`catid` IN (
SELECT `sub`.`id`
FROM `kbk_categories` AS `sub`
INNER JOIN `kbk_categories` AS `this` ON `sub`.`lft` > `this`.`lft` AND `sub`.`rgt` < `this`.`rgt`
WHERE `this`.`id` = :subCategoryId)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `tagmap`.`tag_id` = :tagId
ORDER BY c.lft, CASE WHEN a.publish_up IS NULL THEN a.created ELSE a.publish_up END DESC , a.created LIMIT 18, 23
2.24ms14.23KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT COUNT(*)
FROM `kbk_content` AS `a`
LEFT JOIN `kbk_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `kbk_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `kbk_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `kbk_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `kbk_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `kbk_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
INNER JOIN `kbk_contentitem_tag_map` AS `tagmap` ON `tagmap`.`content_item_id` = `a`.`id` AND `tagmap`.`type_alias` = 'com_content.article'
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`catid` = :categoryId OR `a`.`catid` IN (
SELECT `sub`.`id`
FROM `kbk_categories` AS `sub`
INNER JOIN `kbk_categories` AS `this` ON `sub`.`lft` > `this`.`lft` AND `sub`.`rgt` < `this`.`rgt`
WHERE `this`.`id` = :subCategoryId)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `tagmap`.`tag_id` = :tagId
426μs6.32KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:199CopySELECT `m`.`tag_id`,`t`.*
FROM `kbk_contentitem_tag_map` AS `m`
INNER JOIN `kbk_tags` AS `t` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)
354μs9.8KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug`
FROM `kbk_categories` AS `s`
INNER JOIN `kbk_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
303μs7.19KBParams/libraries/src/Categories/Categories.php:375CopySELECT 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 kbk_fields AS a
LEFT JOIN `kbk_languages` AS l ON l.lang_code = a.language
LEFT JOIN kbk_users AS uc ON uc.id=a.checked_out
LEFT JOIN kbk_viewlevels AS ag ON ag.id = a.access
LEFT JOIN kbk_users AS ua ON ua.id = a.created_user_id
LEFT JOIN kbk_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `kbk_fields_categories` AS fc ON fc.field_id = a.id
WHERE
(
(`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) 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.2ms8.05KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT
`fileurl`,
`filename`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `kbk_sigplus_folder` AS a
WHERE
a.`folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/heksenbos' AND
i.`imageid` = 1639 AND depthnum <= 0
179μs2.51KB/plugins/content/sigplus/core/core.php:2944CopySELECT `folderid`, `foldertime`, `entitytag` FROM `kbk_sigplus_folder` WHERE `folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/heksenbos'
94μs1.91KB/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM kbk_sigplus_view
WHERE folderid = 11 AND hash = 0x494388490e21c4eedaf2c235ed09bf95
151μs912B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 11 AND NOT EXISTS (SELECT * FROM `kbk_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 6) AND depthnum <= 0
384μs1.76KB/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `kbk_sigplus_language`
WHERE
`lang` = 'nl'
110μs912B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `kbk_sigplus_country`
WHERE
`country` = 'NL'
90μs920B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `kbk_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `kbk_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `kbk_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 116 AND
c.`countryid` = 141
WHERE
a.`folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/heksenbos' AND
`viewid` = 6
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
1.59ms5.26KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `kbk_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `kbk_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `kbk_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 116 AND
c.`countryid` = 141
WHERE
a.`folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/heksenbos' AND
`viewid` = 6
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
1.28ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT
`fileurl`,
`filename`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `kbk_sigplus_folder` AS a
WHERE
a.`folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/heksen' AND
i.`imageid` = 1639 AND depthnum <= 0
122μs2.51KB/plugins/content/sigplus/core/core.php:2944CopySELECT `folderid`, `foldertime`, `entitytag` FROM `kbk_sigplus_folder` WHERE `folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/heksen'
96μs1.91KB/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM kbk_sigplus_view
WHERE folderid = 14 AND hash = 0xf58036a5be6c9a7284ed78b98f90a62b
81μs912B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 14 AND NOT EXISTS (SELECT * FROM `kbk_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 7) AND depthnum <= 0
256μs1.76KB/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `kbk_sigplus_language`
WHERE
`lang` = 'nl'
85μs912B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `kbk_sigplus_country`
WHERE
`country` = 'NL'
109μs11.9KB/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `kbk_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `kbk_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `kbk_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 116 AND
c.`countryid` = 141
WHERE
a.`folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/heksen' AND
`viewid` = 7
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
1.63ms5.24KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `kbk_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `kbk_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `kbk_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 116 AND
c.`countryid` = 141
WHERE
a.`folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/heksen' AND
`viewid` = 7
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
1.2ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT
`fileurl`,
`filename`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `kbk_sigplus_folder` AS a
WHERE
a.`folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/septemberbos' AND
i.`imageid` = 1639 AND depthnum <= 0
119μs2.51KB/plugins/content/sigplus/core/core.php:2944CopySELECT `folderid`, `foldertime`, `entitytag` FROM `kbk_sigplus_folder` WHERE `folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/septemberbos'
82μs1.91KB/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM kbk_sigplus_view
WHERE folderid = 9 AND hash = 0xba2c5aa7b953896903a560bd6b94b7d7
111μs912B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 9 AND NOT EXISTS (SELECT * FROM `kbk_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 5) AND depthnum <= 0
252μs1.76KB/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `kbk_sigplus_language`
WHERE
`lang` = 'nl'
87μs912B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `kbk_sigplus_country`
WHERE
`country` = 'NL'
63μs920B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `kbk_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `kbk_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `kbk_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 116 AND
c.`countryid` = 141
WHERE
a.`folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/septemberbos' AND
`viewid` = 5
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
1.55ms5.26KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `kbk_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `kbk_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `kbk_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 116 AND
c.`countryid` = 141
WHERE
a.`folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/septemberbos' AND
`viewid` = 5
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
1.46ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT
`fileurl`,
`filename`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `kbk_sigplus_folder` AS a
WHERE
a.`folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/september' AND
i.`imageid` = 1639 AND depthnum <= 0
116μs2.51KB/plugins/content/sigplus/core/core.php:2944CopySELECT `folderid`, `foldertime`, `entitytag` FROM `kbk_sigplus_folder` WHERE `folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/september'
107μs1.91KB/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM kbk_sigplus_view
WHERE folderid = 1 AND hash = 0x3365ef843404c930330419317c33c7c5
82μs912B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 1 AND NOT EXISTS (SELECT * FROM `kbk_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 1) AND depthnum <= 0
278μs1.76KB/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `kbk_sigplus_language`
WHERE
`lang` = 'nl'
84μs912B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `kbk_sigplus_country`
WHERE
`country` = 'NL'
63μs920B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `kbk_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `kbk_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `kbk_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 116 AND
c.`countryid` = 141
WHERE
a.`folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/september' AND
`viewid` = 1
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
1.59ms5.26KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `kbk_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `kbk_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `kbk_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 116 AND
c.`countryid` = 141
WHERE
a.`folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/september' AND
`viewid` = 1
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
1.65ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT
`fileurl`,
`filename`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `kbk_sigplus_folder` AS a
WHERE
a.`folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/start' AND
i.`imageid` = 1639 AND depthnum <= 0
134μs2.51KB/plugins/content/sigplus/core/core.php:2944CopySELECT `folderid`, `foldertime`, `entitytag` FROM `kbk_sigplus_folder` WHERE `folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/start'
88μs1.91KB/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM kbk_sigplus_view
WHERE folderid = 3 AND hash = 0x2c8c9eaaf12502c2761a24f26b9c3622
96μs912B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 3 AND NOT EXISTS (SELECT * FROM `kbk_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 3) AND depthnum <= 0
365μs1.76KB/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `kbk_sigplus_language`
WHERE
`lang` = 'nl'
85μs912B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `kbk_sigplus_country`
WHERE
`country` = 'NL'
82μs920B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `kbk_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `kbk_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `kbk_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 116 AND
c.`countryid` = 141
WHERE
a.`folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/start' AND
`viewid` = 3
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
2.25ms5.26KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `kbk_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `kbk_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `kbk_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 116 AND
c.`countryid` = 141
WHERE
a.`folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/start' AND
`viewid` = 3
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
2.05ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT 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 kbk_fields AS a
LEFT JOIN `kbk_languages` AS l ON l.lang_code = a.language
LEFT JOIN kbk_users AS uc ON uc.id=a.checked_out
LEFT JOIN kbk_viewlevels AS ag ON ag.id = a.access
LEFT JOIN kbk_users AS ua ON ua.id = a.created_user_id
LEFT JOIN kbk_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.42ms7.39KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug`
FROM `kbk_categories` AS `s`
INNER JOIN `kbk_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
405μs7.19KBParams/libraries/src/Categories/Categories.php:375CopySELECT 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 kbk_fields AS a
LEFT JOIN `kbk_languages` AS l ON l.lang_code = a.language
LEFT JOIN kbk_users AS uc ON uc.id=a.checked_out
LEFT JOIN kbk_viewlevels AS ag ON ag.id = a.access
LEFT JOIN kbk_users AS ua ON ua.id = a.created_user_id
LEFT JOIN kbk_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `kbk_fields_categories` AS fc ON fc.field_id = a.id
WHERE
(
(`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) 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.37ms8.05KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug`
FROM `kbk_categories` AS `s`
INNER JOIN `kbk_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
415μs7.19KBParams/libraries/src/Categories/Categories.php:375CopySELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count`
FROM `kbk_content` AS `a`
LEFT JOIN `kbk_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `kbk_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `kbk_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `kbk_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `kbk_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `kbk_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
INNER JOIN `kbk_contentitem_tag_map` AS `tagmap` ON `tagmap`.`content_item_id` = `a`.`id` AND `tagmap`.`type_alias` = 'com_content.article'
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `tagmap`.`tag_id` = :tagId
ORDER BY publish_up DESC LIMIT 5
1.55ms29.44KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count`
FROM `kbk_content` AS `a`
LEFT JOIN `kbk_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `kbk_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `kbk_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `kbk_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `kbk_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `kbk_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
INNER JOIN (
SELECT DISTINCT `content_item_id`
FROM `kbk_contentitem_tag_map`
WHERE `tag_id` IN (:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17) AND `type_alias` = 'com_content.article') AS `tagmap` ON `tagmap`.`content_item_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)
ORDER BY a.created DESC LIMIT 5
1.61ms24.87KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count`
FROM `kbk_content` AS `a`
LEFT JOIN `kbk_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `kbk_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `kbk_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `kbk_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `kbk_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `kbk_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
INNER JOIN (
SELECT DISTINCT `content_item_id`
FROM `kbk_contentitem_tag_map`
WHERE `tag_id` IN (:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12) AND `type_alias` = 'com_content.article') AS `tagmap` ON `tagmap`.`content_item_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)
ORDER BY a.created DESC LIMIT 5
1.22ms14.8KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `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 `kbk_scheduler_tasks` AS `a`
LEFT JOIN `kbk_users` AS `uc` ON `uc`.`id` = `a`.`checked_out`
WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now
ORDER BY `a`.`title` asc
227μs5.74KBParams/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 `kbk_scheduler_tasks` AS `a`
LEFT JOIN `kbk_users` AS `uc` ON `uc`.`id` = `a`.`checked_out`
WHERE `a`.`state` = :state AND `a`.`locked` IS NOT NULL
ORDER BY `a`.`title` asc
179μs5.73KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy