Dit zijn de werkjes van de leerlingen. We zijn heel tevreden met de resultaten.
Wij schilderden vandaag naar het voorbeeld van Vincent Van Gogh. Volgende week werken we dit verder af. Benieuwd naar de resultaten...
| Joomla! Version | 4.3.4 |
| PHP Version | 8.1.31 |
| Identity | guest |
| Response | 200 |
| Template | j51_chloe |
| Database |
|
| 1 x afterRenderComponent com_content (666.06KB) (25.59%) | 30.42ms |
| 1 x afterInitialise (855.86KB) (14.62%) | 17.38ms |
| 1 x afterRenderRawModule mod_articles_category (Sport nieuws) (58.16KB) (7.08%) | 8.41ms |
| 1 x afterRender (136.22KB) (6.18%) | 7.35ms |
| 1 x afterRenderRawModule mod_articles_category (Lagere school nieuws) (61.73KB) (4.6%) | 5.47ms |
| 1 x afterRenderRawModule mod_menu () (230.49KB) (4.54%) | 5.40ms |
| 1 x afterRenderRawModule mod_articles_category (Kleuterschool nieuws) (36.39KB) (4.28%) | 5.08ms |
| 1 x afterLoad (541.73KB) (3.49%) | 4.15ms |
| 1 x Before Access::preloadComponents (all components) (138.41KB) (2.47%) | 2.93ms |
| 1 x beforeRenderRawModule mod_menu () (89.63KB) (2.03%) | 2.41ms |
| 1 x Before Access::getAssetRules (id:8 name:com_content) (45.82KB) (2.02%) | 2.40ms |
| 1 x afterDispatch (316.98KB) (1.74%) | 2.07ms |
| 1 x beforeRenderComponent com_content (79.05KB) (1.55%) | 1.84ms |
| 1 x afterRenderRawModule mod_menu (menu-horizontaal) (5.2KB) (1.46%) | 1.73ms |
| 1 x afterRenderRawModule mod_menu () (4.2KB) (1.24%) | 1.47ms |
| 1 x After Access::preloadComponents (all components) (129.03KB) (1.18%) | 1.40ms |
| 1 x beforeRenderRawModule mod_menu (menu-leerkrachten) (33.59KB) (1.12%) | 1.33ms |
| 1 x After Access::preloadPermissions (com_content) (239.39KB) (1.08%) | 1.28ms |
| 1 x afterRoute (301.45KB) (0.84%) | 996μs |
| 1 x afterRenderRawModule mod_menu () (19.16KB) (0.74%) | 877μs |
| 1 x afterRenderRawModule mod_menu (menu-links) (3.2KB) (0.55%) | 659μs |
| 1 x afterRenderRawModule mod_j51layerslideshow (J51_LayerSlideshow) (17.19KB) (0.55%) | 657μs |
| 1 x beforeRenderRawModule mod_custom (logo nieuwsbrief) (208B) (0.49%) | 586μs |
| 1 x beforeRenderRawModule mod_menu (menu-links) (1.77KB) (0.43%) | 514μs |
| 1 x beforeRenderRawModule mod_custom (logo menu) (584B) (0.43%) | 508μs |
| 1 x beforeRenderRawModule mod_custom (Logo Bingel) (152B) (0.4%) | 477μs |
| 1 x afterRenderRawModule mod_menu (menu-leerkrachten) (2.51KB) (0.4%) | 470μs |
| 1 x afterRenderRawModule mod_custom (Logo STJ Side) (3.87KB) (0.37%) | 444μs |
| 1 x beforeRenderRawModule mod_j51layerslideshow (J51_LayerSlideshow) (9.29KB) (0.31%) | 367μs |
| 1 x beforeRenderRawModule mod_articles_category (Sport nieuws) (17.51KB) (0.3%) | 359μs |
| 1 x beforeRenderRawModule mod_custom (Logo STJ Side) (14.34KB) (0.27%) | 323μs |
| 1 x beforeRenderRawModule mod_menu (menu-horizontaal) (10.58KB) (0.26%) | 305μs |
| 1 x afterRenderModule mod_menu (menu-leerkrachten) (3.85KB) (0.1%) | 118μs |
| 1 x After Access::getAssetRules (id:714 name:com_content.category.69) (8.56KB) (0.09%) | 111μs |
| 1 x afterRenderModule mod_menu () (7.1KB) (0.08%) | 96μs |
| 1 x afterRenderRawModule mod_custom (logo nieuwsbrief) (976B) (0.08%) | 92μs |
| 1 x afterRenderModule mod_articles_category (Sport nieuws) (5.68KB) (0.06%) | 69μs |
| 1 x afterRenderRawModule mod_custom (logo menu) (976B) (0.06%) | 68μs |
| 1 x beforeRenderRawModule mod_articles_category (Kleuterschool nieuws) (608B) (0.06%) | 67μs |
| 1 x afterRenderRawModule mod_custom (Logo Bingel) (976B) (0.06%) | 67μs |
| 1 x afterRenderModule mod_articles_category (Lagere school nieuws) (3.2KB) (0.05%) | 65μs |
| 1 x afterRenderModule mod_menu (menu-horizontaal) (5.3KB) (0.05%) | 58μs |
| 1 x afterRenderModule mod_custom (logo menu) (2.32KB) (0.05%) | 56μs |
| 1 x beforeRenderRawModule mod_articles_category (Lagere school nieuws) (1.45KB) (0.05%) | 54μs |
| 1 x afterRenderModule mod_custom (logo nieuwsbrief) (2.32KB) (0.04%) | 50μs |
| 1 x afterRenderModule mod_custom (Logo STJ Side) (2.26KB) (0.04%) | 49μs |
| 1 x afterRenderModule mod_articles_category (Kleuterschool nieuws) (3.2KB) (0.04%) | 46μs |
| 1 x afterRenderModule mod_menu () (5.27KB) (0.04%) | 42μs |
| 1 x afterRenderModule mod_j51layerslideshow (J51_LayerSlideshow) (16.95KB) (0.04%) | 42μs |
| 1 x afterRenderModule mod_menu (menu-links) (3.16KB) (0.03%) | 39μs |
| 1 x beforeRenderRawModule mod_menu () (3.38KB) (0.03%) | 39μs |
| 1 x afterRenderModule mod_menu () (2.59KB) (0.03%) | 35μs |
| 1 x afterRenderModule mod_custom (Logo Bingel) (2.32KB) (0.03%) | 34μs |
| 1 x Before Access::getAssetRules (id:714 name:com_content.category.69) (18.8KB) (0.03%) | 30μs |
| 1 x beforeRenderRawModule mod_menu () (3.48KB) (0.02%) | 29μs |
| 3 x beforeRenderModule mod_menu () (696B) (0.02%) | 25μs |
| 1 x Before Access::preloadPermissions (com_content) (3.85KB) (0.02%) | 22μs |
| 1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%) | 10μs |
| 1 x beforeRenderModule mod_articles_category (Lagere school nieuws) (736B) (0.01%) | 8μs |
| 1 x beforeRenderModule mod_articles_category (Sport nieuws) (720B) (0.01%) | 7μs |
| 1 x beforeRenderModule mod_menu (menu-horizontaal) (720B) (0.01%) | 7μs |
| 1 x beforeRenderModule mod_menu (menu-leerkrachten) (720B) (0.01%) | 6μs |
| 1 x beforeRenderModule mod_articles_category (Kleuterschool nieuws) (736B) (0.01%) | 6μs |
| 1 x beforeRenderModule mod_custom (Logo STJ Side) (720B) (0.01%) | 6μs |
| 1 x beforeRenderModule mod_custom (logo nieuwsbrief) (720B) (0.01%) | 6μs |
| 1 x beforeRenderModule mod_menu (menu-links) (720B) (0.01%) | 6μs |
| 1 x beforeRenderModule mod_j51layerslideshow (J51_LayerSlideshow) (736B) (0.01%) | 6μs |
| 1 x beforeRenderModule mod_custom (logo menu) (720B) (0%) | 4μs |
| 1 x beforeRenderModule mod_custom (Logo Bingel) (720B) (0%) | 4μs |
SELECT @@SESSION.sql_mode;167μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `kbk_session`
WHERE `session_id` = ?243μs1.68KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `kbk_session`
WHERE `session_id` = :session_id LIMIT 1114μ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.3ms928BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `id`,`rules`
FROM `kbk_viewlevels`150μ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` = :guest190μ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)659μ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` = 0523μ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.04ms8.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 231.44ms14.2KBParams/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` = :tagId459μ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)335μ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`353μ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 ASC1.01ms8.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/l3/Schilderen_2' AND
i.`imageid` = 508 AND depthnum <= 0193μ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/l3/Schilderen_2'109μs1.91KB/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM kbk_sigplus_view
WHERE folderid = 57 AND hash = 0xf69820b466e16474f9653215d5016c8f162μ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` = 57 AND NOT EXISTS (SELECT * FROM `kbk_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 23) AND depthnum <= 0416μs1.76KB/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `kbk_sigplus_language`
WHERE
`lang` = 'nl'126μ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/l3/Schilderen_2' AND
`viewid` = 23
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC1.42ms5.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/l3/Schilderen_2' AND
`viewid` = 23
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC951μ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/l3/Schilderen' AND
i.`imageid` = 508 AND depthnum <= 0140μ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/l3/Schilderen'116μs1.91KB/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM kbk_sigplus_view
WHERE folderid = 36 AND hash = 0x37af7f9d2b44a3977007ddea709e5ffe98μ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` = 36 AND NOT EXISTS (SELECT * FROM `kbk_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 17) AND depthnum <= 0313μ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'84μ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/l3/Schilderen' AND
`viewid` = 17
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC1.12ms5.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/l3/Schilderen' AND
`viewid` = 17
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC891μs0B/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 ASC829μ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`368μ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 ASC767μs19.05KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `kbk_modules` AS `m`
LEFT JOIN `kbk_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `kbk_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id`
WHERE
(
(
(`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND
(`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0)
ORDER BY `m`.`position`,`m`.`ordering`582μs10.83KBParams/libraries/src/Cache/Controller/CallbackController.php:120CopySELECT `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 51.49ms13.45KBParams/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`340μ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 (
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 51.78ms16.92KBParams/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 51.35ms30.72KBParams/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` asc353μ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` asc362μs5.73KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy