Wij gaan op berenjacht in het bos (K2)
Op zoek naar een leuke school voor je kind?
Kerstknutselen in K2 met de ouders
Dankjewel aan alle ouders en zussen die met zoveel enthousiasme mee kwamen knustelen!
Joomla! Version | 4.3.4 |
PHP Version | 8.1.31 |
Identity | guest |
Response | 200 |
Template | j51_chloe |
Database |
|
1 x afterRenderComponent com_content (1.35MB) (49.17%) | 62.65ms |
1 x afterInitialise (853.23KB) (12.37%) | 15.77ms |
1 x afterRender (222.28KB) (11.33%) | 14.44ms |
1 x afterRenderRawModule mod_menu () (198.74KB) (2.46%) | 3.14ms |
1 x afterRenderRawModule mod_menu () (4.2KB) (2.17%) | 2.77ms |
1 x Before Access::getAssetRules (id:8 name:com_content) (45.67KB) (1.83%) | 2.34ms |
1 x afterRenderRawModule mod_menu (menu-horizontaal) (5.2KB) (1.77%) | 2.26ms |
1 x afterLoad (541.62KB) (1.44%) | 1.83ms |
1 x beforeRenderRawModule mod_menu () (101.45KB) (1.4%) | 1.79ms |
1 x afterDispatch (316.95KB) (1.24%) | 1.58ms |
1 x Before Access::preloadComponents (all components) (138.41KB) (1.07%) | 1.36ms |
1 x After Access::preloadPermissions (com_content) (231.98KB) (1%) | 1.28ms |
1 x After Access::preloadComponents (all components) (127.43KB) (0.98%) | 1.25ms |
1 x beforeRenderRawModule mod_menu (menu-leerkrachten) (34.18KB) (0.84%) | 1.07ms |
1 x afterRenderRawModule mod_menu () (19.16KB) (0.84%) | 1.07ms |
1 x beforeRenderComponent com_content (72.35KB) (0.69%) | 881μs |
1 x afterRenderRawModule mod_menu (menu-links) (3.23KB) (0.55%) | 698μs |
1 x beforeRenderRawModule mod_menu (menu-links) (17.77KB) (0.5%) | 635μs |
1 x afterRoute (301.45KB) (0.5%) | 633μs |
1 x afterRenderRawModule mod_j51layerslideshow (J51_LayerSlideshow) (17.19KB) (0.5%) | 633μs |
1 x afterRenderRawModule mod_articles_category (Sport nieuws) (14.8KB) (0.48%) | 611μs |
1 x afterRenderRawModule mod_menu (menu-leerkrachten) (2.51KB) (0.44%) | 555μs |
1 x beforeRenderRawModule mod_j51layerslideshow (J51_LayerSlideshow) (9.35KB) (0.4%) | 507μs |
1 x beforeRenderRawModule mod_articles_category (Sport nieuws) (17.51KB) (0.36%) | 458μs |
1 x afterRenderRawModule mod_articles_category (Kleuterschool nieuws) (2.17KB) (0.32%) | 405μs |
1 x afterRenderRawModule mod_articles_category (Lagere school nieuws) (1.92KB) (0.27%) | 343μs |
1 x beforeRenderRawModule mod_menu (menu-horizontaal) (10.64KB) (0.27%) | 342μs |
1 x afterRenderModule mod_menu (menu-leerkrachten) (3.85KB) (0.1%) | 122μs |
1 x afterRenderModule mod_menu () (7.1KB) (0.08%) | 101μs |
1 x After Access::getAssetRules (id:714 name:com_content.category.69) (8.56KB) (0.07%) | 85μs |
1 x afterRenderModule mod_articles_category (Kleuterschool nieuws) (3.2KB) (0.06%) | 81μs |
1 x afterRenderModule mod_articles_category (Sport nieuws) (5.05KB) (0.05%) | 63μs |
1 x beforeRenderRawModule mod_articles_category (Kleuterschool nieuws) (608B) (0.05%) | 63μs |
1 x afterRenderModule mod_articles_category (Lagere school nieuws) (3.2KB) (0.04%) | 57μs |
1 x afterRenderModule mod_menu (menu-links) (3.16KB) (0.04%) | 53μs |
1 x afterRenderModule mod_j51layerslideshow (J51_LayerSlideshow) (5.95KB) (0.04%) | 52μs |
1 x beforeRenderRawModule mod_menu () (3.48KB) (0.04%) | 50μs |
1 x afterRenderModule mod_menu (menu-horizontaal) (5.3KB) (0.04%) | 49μs |
1 x beforeRenderRawModule mod_articles_category (Lagere school nieuws) (1.45KB) (0.04%) | 47μs |
1 x afterRenderModule mod_menu () (2.59KB) (0.04%) | 46μs |
1 x afterRenderModule mod_menu () (5.27KB) (0.03%) | 40μs |
1 x beforeRenderRawModule mod_menu () (3.38KB) (0.02%) | 31μs |
1 x Before Access::preloadPermissions (com_content) (3.85KB) (0.02%) | 28μs |
3 x beforeRenderModule mod_menu () (696B) (0.02%) | 23μs |
1 x Before Access::getAssetRules (id:714 name:com_content.category.69) (18.8KB) (0.02%) | 23μs |
1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%) | 19μs |
1 x beforeRenderModule mod_menu (menu-links) (720B) (0.01%) | 8μs |
1 x beforeRenderModule mod_j51layerslideshow (J51_LayerSlideshow) (736B) (0.01%) | 7μs |
1 x beforeRenderModule mod_menu (menu-leerkrachten) (720B) (0.01%) | 7μs |
1 x beforeRenderModule mod_articles_category (Lagere school nieuws) (736B) (0.01%) | 7μs |
1 x beforeRenderModule mod_menu (menu-horizontaal) (720B) (0.01%) | 7μs |
1 x beforeRenderModule mod_articles_category (Kleuterschool nieuws) (736B) (0%) | 6μs |
1 x beforeRenderModule mod_articles_category (Sport nieuws) (720B) (0%) | 5μs |
SELECT @@SESSION.sql_mode;
116μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `kbk_session`
WHERE `session_id` = ?
413μs1.68KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `kbk_session`
WHERE `session_id` = :session_id LIMIT 1
113μ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.01ms928BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `id`,`rules`
FROM `kbk_viewlevels`
156μ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
223μ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)
751μ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
549μ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.07ms8.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 3, 23
2.09ms17.69KBParams/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
642μ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)
505μ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`
349μ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
937μs8.05KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `folderid`, `foldertime`, `entitytag` FROM `kbk_sigplus_folder` WHERE `folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/berenbos'
129μs1.91KB/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM kbk_sigplus_view
WHERE folderid = 68 AND hash = 0xea81753cead5ad3b53210ad0c2cd61eb
149μ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` = 68 AND NOT EXISTS (SELECT * FROM `kbk_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 28) AND depthnum <= 0
479μs4.26KB/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `kbk_sigplus_language`
WHERE
`lang` = 'nl'
138μs912B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `kbk_sigplus_country`
WHERE
`country` = 'NL'
129μ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/berenbos' AND
`viewid` = 28
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
1.95ms5.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/berenbos' AND
`viewid` = 28
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
1.55ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `kbk_sigplus_folder` WHERE `folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/kerstouders'
131μs1.91KB/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM kbk_sigplus_view
WHERE folderid = 62 AND hash = 0xa7aa2e3181c1b355615c579f2ee018e5
340μ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` = 62 AND NOT EXISTS (SELECT * FROM `kbk_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 26) AND depthnum <= 0
432μs1.76KB/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `kbk_sigplus_language`
WHERE
`lang` = 'nl'
128μs912B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `kbk_sigplus_country`
WHERE
`country` = 'NL'
109μ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/kerstouders' AND
`viewid` = 26
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
1.92ms5.27KB/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/kerstouders' AND
`viewid` = 26
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
1.91ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `kbk_sigplus_folder` WHERE `folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/kerstbos'
168μs1.91KB/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM kbk_sigplus_view
WHERE folderid = 59 AND hash = 0x9558472541dd5bfbaef4198f36afd9cb
96μs912B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 59 AND NOT EXISTS (SELECT * FROM `kbk_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 25) AND depthnum <= 0
325μs1.76KB/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `kbk_sigplus_language`
WHERE
`lang` = 'nl'
82μs912B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `kbk_sigplus_country`
WHERE
`country` = 'NL'
69μs11.9KB/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `kbk_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `kbk_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `kbk_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 116 AND
c.`countryid` = 141
WHERE
a.`folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/kerstbos' AND
`viewid` = 25
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
1.23ms5.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/kerstbos' AND
`viewid` = 25
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
1.09ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `kbk_sigplus_folder` WHERE `folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/bossinterklaas'
94μs1.91KB/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM kbk_sigplus_view
WHERE folderid = 46 AND hash = 0x13e3127ffff1d2c8cc6d0f464702ef12
81μs912B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 46 AND NOT EXISTS (SELECT * FROM `kbk_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 19) AND depthnum <= 0
347μs1.76KB/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `kbk_sigplus_language`
WHERE
`lang` = 'nl'
84μs912B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `kbk_sigplus_country`
WHERE
`country` = 'NL'
63μs920B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `kbk_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `kbk_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `kbk_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 116 AND
c.`countryid` = 141
WHERE
a.`folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/bossinterklaas' AND
`viewid` = 19
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
1.39ms5.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/bossinterklaas' AND
`viewid` = 19
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
1.29ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `kbk_sigplus_folder` WHERE `folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/bosmax'
91μs1.91KB/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM kbk_sigplus_view
WHERE folderid = 17 AND hash = 0xf80948936c857afd473f22f9f1e04aba
87μ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` = 17 AND NOT EXISTS (SELECT * FROM `kbk_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 9) AND depthnum <= 0
287μs1.76KB/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `kbk_sigplus_language`
WHERE
`lang` = 'nl'
93μs912B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `kbk_sigplus_country`
WHERE
`country` = 'NL'
69μ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/bosmax' AND
`viewid` = 9
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
1.15ms5.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/bosmax' AND
`viewid` = 9
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
1.05ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `kbk_sigplus_folder` WHERE `folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/heksenbos'
94μs1.91KB/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM kbk_sigplus_view
WHERE folderid = 11 AND hash = 0x494388490e21c4eedaf2c235ed09bf95
258μs912B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 11 AND NOT EXISTS (SELECT * FROM `kbk_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 6) AND depthnum <= 0
226μs1.76KB/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `kbk_sigplus_language`
WHERE
`lang` = 'nl'
77μs912B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `kbk_sigplus_country`
WHERE
`country` = 'NL'
62μ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.07ms5.26KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `kbk_sigplus_property` AS mp
INNER JOIN `kbk_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `kbk_sigplus_foldercaption` AS p
WHERE
p.`langid` = 116 AND
p.`countryid` = 141 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `kbk_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `kbk_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `kbk_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 116 AND
c.`countryid` = 141
WHERE
a.`folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/heksenbos' AND
`viewid` = 6
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC
1.04ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `kbk_sigplus_folder` WHERE `folderurl` = '/var/www/vhosts/basisschoolst-jozef.be/httpdocs/images/k2/septemberbos'
88μs1.91KB/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM kbk_sigplus_view
WHERE folderid = 9 AND hash = 0xba2c5aa7b953896903a560bd6b94b7d7
77μs912B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `kbk_sigplus_image` AS i
INNER JOIN `kbk_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `kbk_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 9 AND NOT EXISTS (SELECT * FROM `kbk_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 5) AND depthnum <= 0
262μs1.76KB/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `kbk_sigplus_language`
WHERE
`lang` = 'nl'
74μs912B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `kbk_sigplus_country`
WHERE
`country` = 'NL'
68μ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.21ms5.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.1ms0B/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
848μ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`
317μs15.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
731μ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`
318μs7.19KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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`
615μs10.83KBParams/libraries/src/Cache/Controller/CallbackController.php:120CopySELECT `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
277μ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
192μs5.73KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy