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.19MB) (39.54%) | 58.02ms |
1 x afterInitialise (855.72KB) (11.77%) | 17.27ms |
1 x afterRender (210.81KB) (11.39%) | 16.72ms |
1 x afterRenderRawModule mod_articles_category (Sport nieuws) (75.74KB) (4.14%) | 6.07ms |
1 x afterRenderRawModule mod_articles_category (Lagere school nieuws) (45.93KB) (3.65%) | 5.36ms |
1 x afterRenderRawModule mod_articles_category (Kleuterschool nieuws) (18.83KB) (3.57%) | 5.23ms |
1 x afterLoad (541.9KB) (3.03%) | 4.44ms |
1 x Before Access::preloadComponents (all components) (138.46KB) (2.73%) | 4.01ms |
1 x Before Access::getAssetRules (id:8 name:com_content) (45.82KB) (1.73%) | 2.53ms |
1 x afterRenderRawModule mod_menu () (294.7KB) (1.59%) | 2.34ms |
1 x afterDispatch (316.98KB) (1.56%) | 2.30ms |
1 x afterRenderRawModule mod_menu () (302.08KB) (1.47%) | 2.16ms |
1 x beforeRenderRawModule mod_menu () (78.2KB) (1.06%) | 1.56ms |
1 x beforeRenderComponent com_content (79.47KB) (1.05%) | 1.54ms |
1 x After Access::preloadPermissions (com_content) (244.23KB) (1.01%) | 1.48ms |
1 x beforeRenderRawModule mod_articles_category (Sport nieuws) (20.84KB) (0.95%) | 1.39ms |
1 x After Access::preloadComponents (all components) (129.03KB) (0.84%) | 1.23ms |
1 x afterRoute (302.07KB) (0.69%) | 1.01ms |
1 x beforeRenderRawModule mod_custom (Logo STJ Side) (14.34KB) (0.62%) | 909μs |
1 x afterRenderRawModule mod_j51layerslideshow (J51_LayerSlideshow) (17.45KB) (0.42%) | 611μs |
1 x beforeRenderRawModule mod_j51layerslideshow (J51_LayerSlideshow) (15.59KB) (0.34%) | 497μs |
1 x beforeRenderRawModule mod_custom (logo nieuwsbrief) (208B) (0.33%) | 486μs |
1 x beforeRenderRawModule mod_custom (logo menu) (584B) (0.31%) | 449μs |
1 x afterRenderRawModule mod_menu () (1.52KB) (0.21%) | 315μs |
1 x afterRenderRawModule mod_custom (Logo STJ Side) (3.87KB) (0.2%) | 298μs |
1 x After Access::getAssetRules (id:714 name:com_content.category.69) (8.56KB) (0.1%) | 150μs |
1 x afterRenderModule mod_articles_category (Sport nieuws) (3.81KB) (0.07%) | 100μs |
1 x afterRenderModule mod_menu () (7.1KB) (0.05%) | 76μs |
1 x afterRenderRawModule mod_custom (logo nieuwsbrief) (976B) (0.04%) | 63μs |
1 x afterRenderRawModule mod_custom (logo menu) (976B) (0.04%) | 61μs |
1 x beforeRenderRawModule mod_articles_category (Lagere school nieuws) (1.45KB) (0.03%) | 51μs |
1 x beforeRenderRawModule mod_articles_category (Kleuterschool nieuws) (608B) (0.03%) | 49μs |
1 x afterRenderModule mod_articles_category (Lagere school nieuws) (5.7KB) (0.03%) | 44μs |
1 x afterRenderModule mod_articles_category (Kleuterschool nieuws) (3.45KB) (0.03%) | 42μs |
1 x afterRenderModule mod_j51layerslideshow (J51_LayerSlideshow) (5.95KB) (0.03%) | 39μs |
1 x afterRenderModule mod_menu () (2.59KB) (0.03%) | 37μs |
1 x afterRenderModule mod_custom (Logo STJ Side) (2.26KB) (0.03%) | 37μs |
1 x afterRenderModule mod_menu () (5.27KB) (0.02%) | 33μs |
1 x afterRenderModule mod_custom (logo nieuwsbrief) (2.32KB) (0.02%) | 33μs |
1 x afterRenderModule mod_custom (logo menu) (2.32KB) (0.02%) | 33μs |
1 x Before Access::preloadPermissions (com_content) (3.85KB) (0.02%) | 30μs |
1 x beforeRenderRawModule mod_menu () (3.38KB) (0.02%) | 28μs |
1 x Before Access::getAssetRules (id:714 name:com_content.category.69) (18.8KB) (0.02%) | 28μs |
1 x beforeRenderRawModule mod_menu () (3.48KB) (0.02%) | 23μs |
3 x beforeRenderModule mod_menu () (696B) (0.01%) | 18μs |
1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%) | 10μs |
1 x beforeRenderModule mod_articles_category (Sport nieuws) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_articles_category (Lagere school nieuws) (736B) (0%) | 6μs |
1 x beforeRenderModule mod_articles_category (Kleuterschool 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%) | 3μs |
SELECT @@SESSION.sql_mode;
219μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `kbk_session`
WHERE `session_id` = ?
225μs1.68KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `kbk_session`
WHERE `session_id` = :session_id LIMIT 1
118μ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.26ms928BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `id`,`rules`
FROM `kbk_viewlevels`
192μs17.63KB/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
239μs1.68KBParams/libraries/src/Access/Access.php:868CopySELECT `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)
634μ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
602μ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.17ms8.55KBParams/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 24, 23
1.91ms14.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
746μ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)
568μs7.3KBParams/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`
361μ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
938μs8.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` = 1559 AND depthnum <= 0
206μ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'
119μs1.91KB/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM kbk_sigplus_view
WHERE folderid = 11 AND hash = 0x494388490e21c4eedaf2c235ed09bf95
204μs3.39KB/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
513μs1.76KB/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `kbk_sigplus_language`
WHERE
`lang` = 'nl'
157μs912B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `kbk_sigplus_country`
WHERE
`country` = 'NL'
147μ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.41ms5.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
998μs0B/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` = 1559 AND depthnum <= 0
127μ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'
114μs1.91KB/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM kbk_sigplus_view
WHERE folderid = 14 AND hash = 0xf58036a5be6c9a7284ed78b98f90a62b
119μ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
356μs1.76KB/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `kbk_sigplus_language`
WHERE
`lang` = 'nl'
113μs912B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `kbk_sigplus_country`
WHERE
`country` = 'NL'
108μ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/heksen' AND
`viewid` = 7
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
1.25ms5.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.14ms0B/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` = 1559 AND depthnum <= 0
268μ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'
92μs1.91KB/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM kbk_sigplus_view
WHERE folderid = 9 AND hash = 0xba2c5aa7b953896903a560bd6b94b7d7
97μs11.89KB/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
364μs1.76KB/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `kbk_sigplus_language`
WHERE
`lang` = 'nl'
95μs912B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `kbk_sigplus_country`
WHERE
`country` = 'NL'
76μ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.54ms5.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.09ms0B/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` = 1559 AND depthnum <= 0
124μ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'
84μs1.91KB/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM kbk_sigplus_view
WHERE folderid = 1 AND hash = 0x3365ef843404c930330419317c33c7c5
91μ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
309μs1.76KB/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `kbk_sigplus_language`
WHERE
`lang` = 'nl'
170μs912B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `kbk_sigplus_country`
WHERE
`country` = 'NL'
94μ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.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/september' AND
`viewid` = 1
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
1.06ms0B/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` = 1559 AND depthnum <= 0
153μ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'
74μs1.91KB/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM kbk_sigplus_view
WHERE folderid = 3 AND hash = 0x2c8c9eaaf12502c2761a24f26b9c3622
93μ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
344μs1.76KB/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `kbk_sigplus_language`
WHERE
`lang` = 'nl'
89μs912B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `kbk_sigplus_country`
WHERE
`country` = 'NL'
64μ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
1.61ms5.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
1.23ms0B/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
752μs7.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`
328μ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
850μs8.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`
292μ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.19ms29.45KBParams/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.92ms16.96KBParams/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.43ms14.77KBParams/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
410μ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
191μs5.73KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy