Rapport du concours externe 2022
Rapports antérieurs :
Rapport du concours externe 2021
Rapport du concours externe 2020
Rapport du concours externe 2019
Rapport du concours externe 2018
Rapport du concours interne 2018 (histoire ancienne au programme du concours)
Rapport du concours externe 2016
| Joomla! Version | 4.4.9 |
| PHP Version | 8.2.28 |
| Identity | guest |
| Response | 200 |
| Template | cassiopeia |
| Database |
|
| 1 x afterInitialise (1.09MB) (36.74%) | 32.24ms |
| 1 x afterRenderComponent com_content (261.05KB) (18.54%) | 16.26ms |
| 1 x afterRoute (288.45KB) (8.57%) | 7.52ms |
| 1 x afterRenderRawModule mod_menu (Menu 2019) (821.51KB) (5.4%) | 4.74ms |
| 1 x beforeRenderComponent com_content (68.29KB) (4.2%) | 3.68ms |
| 1 x afterRenderRawModule mod_accordeonmenuck (Accordeon Menu CK) (104.61KB) (3.41%) | 3.00ms |
| 1 x beforeRenderRawModule mod_menu (Menu 2019) (289.55KB) (3.19%) | 2.80ms |
| 1 x afterRender (167.1KB) (2.97%) | 2.61ms |
| 1 x afterLoad (456.25KB) (2.95%) | 2.59ms |
| 1 x After Access::preloadComponents (all components) (123.11KB) (2.57%) | 2.25ms |
| 1 x After Access::preloadPermissions (com_content) (428.59KB) (2.05%) | 1.80ms |
| 1 x beforeRenderRawModule mod_db8sitelastmodified (Dernières mise à jour) (62.07KB) (1.73%) | 1.52ms |
| 1 x Before Access::preloadComponents (all components) (105.56KB) (1.37%) | 1.20ms |
| 1 x afterRenderModule mod_accordeonmenuck (Accordeon Menu CK) (63.5KB) (1.2%) | 1.05ms |
| 1 x beforeRenderModule mod_custom (Pied de page) (9.33KB) (0.86%) | 756μs |
| 1 x afterRenderRawModule mod_breadcrumbs (Fil de navigation) (8.44KB) (0.68%) | 597μs |
| 1 x afterRenderRawModule mod_search (Recherche) (19.1KB) (0.58%) | 511μs |
| 1 x afterRenderRawModule mod_random_image (Bandeaux aléatoires 2019) (4.25KB) (0.45%) | 395μs |
| 1 x afterDispatch (2.28KB) (0.24%) | 207μs |
| 1 x afterRenderModule mod_db8sitelastmodified (Dernières mise à jour) (2.6KB) (0.17%) | 145μs |
| 1 x beforeRenderRawModule mod_custom (Icones) (43.25KB) (0.14%) | 120μs |
| 1 x afterRenderModule mod_custom (Pied de page) (3.71KB) (0.13%) | 118μs |
| 1 x afterRenderModule mod_breadcrumbs (Fil de navigation) (3.6KB) (0.12%) | 109μs |
| 1 x After Access::getAssetRules (id:1852 name:com_content.article.1711) (7.38KB) (0.12%) | 104μs |
| 1 x afterRenderModule mod_search (Recherche) (2.63KB) (0.09%) | 81μs |
| 1 x afterRenderModule mod_custom (Icones) (2.4KB) (0.08%) | 74μs |
| 1 x afterRenderRawModule mod_custom (Pied de page) (41.73KB) (0.08%) | 69μs |
| 1 x afterRenderModule mod_custom (Module de module icones) (4.15KB) (0.07%) | 65μs |
| 1 x afterRenderModule mod_random_image (Bandeaux aléatoires 2019) (2.05KB) (0.07%) | 65μs |
| 1 x afterRenderRawModule mod_db8sitelastmodified (Dernières mise à jour) (2.59KB) (0.07%) | 62μs |
| 1 x afterRenderModule mod_menu (Menu 2019) (17.87KB) (0.07%) | 61μs |
| 1 x beforeRenderRawModule mod_breadcrumbs (Fil de navigation) (960B) (0.07%) | 59μs |
| 1 x beforeRenderRawModule mod_custom (Pied de page) (23.63KB) (0.06%) | 50μs |
| 1 x beforeRenderRawModule mod_custom (Module de module icones) (28.67KB) (0.06%) | 49μs |
| 1 x afterRenderRawModule mod_custom (Icones) (976B) (0.05%) | 44μs |
| 1 x beforeRenderRawModule mod_accordeonmenuck (Accordeon Menu CK) (23.22KB) (0.05%) | 42μs |
| 1 x afterRenderRawModule mod_custom (Module de module icones) (44.08KB) (0.05%) | 41μs |
| 1 x beforeRenderModule mod_menu (Menu 2019) (1.84KB) (0.05%) | 40μs |
| 1 x beforeRenderRawModule mod_random_image (Bandeaux aléatoires 2019) (576B) (0.04%) | 35μs |
| 1 x Before Access::getAssetRules (id:1852 name:com_content.article.1711) (18.65KB) (0.04%) | 31μs |
| 1 x Before Access::preloadPermissions (com_content) (1.7KB) (0.03%) | 29μs |
| 1 x beforeRenderModule mod_accordeonmenuck (Accordeon Menu CK) (22.13KB) (0.03%) | 28μs |
| 1 x beforeRenderRawModule mod_search (Recherche) (2.17KB) (0.02%) | 20μs |
| 1 x beforeRenderModule mod_db8sitelastmodified (Dernières mise à jour) (736B) (0.01%) | 5μs |
| 1 x beforeRenderModule mod_search (Recherche) (720B) (0.01%) | 5μs |
| 1 x beforeRenderModule mod_random_image (Bandeaux aléatoires 2019) (736B) (0%) | 4μs |
| 1 x beforeRenderModule mod_breadcrumbs (Fil de navigation) (704B) (0%) | 4μs |
| 1 x beforeRenderModule mod_custom (Icones) (704B) (0%) | 3μs |
| 1 x beforeRenderModule mod_custom (Module de module icones) (720B) (0%) | 3μs |
Flux AlerteSELECT @@SESSION.sql_mode;65μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `sophau_session`
WHERE `session_id` = ?138μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `sophau_session`
WHERE `session_id` = :session_id LIMIT 174μs1.3KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `sophau_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)16.93ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `sophau_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1336μs1.73KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `sophau_viewlevels`103μs656B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `sophau_usergroups` AS `a`
LEFT JOIN `sophau_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest149μs1.33KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `sophau_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`518μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component`
FROM `sophau_menu` AS `m`
LEFT JOIN `sophau_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id`
WHERE
(
(`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2)
ORDER BY `m`.`lft`1.12ms117.92KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT *
FROM `sophau_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC179μs1.61KB/libraries/src/Language/LanguageHelper.php:142CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `sophau_template_styles` AS `s`
LEFT JOIN `sophau_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id`
WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1183μs864B/administrator/components/com_templates/src/Model/StyleModel.php:773CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `sophau_assets`
WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43)406μs7.81KBParams/libraries/src/Access/Access.php:357CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `sophau_assets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0562μs45.48KBParams/libraries/src/Access/Access.php:301CopySHOW FULL COLUMNS FROM `sophau_content`387μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopyUPDATE `sophau_content`
SET `hits` = (`hits` + 1)
WHERE `id` = '1711'4.53ms48B/libraries/src/Table/Table.php:1325CopySELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`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`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count`
FROM `sophau_content` AS `a`
INNER JOIN `sophau_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `sophau_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `sophau_users` AS `u` ON `u`.`id` = `a`.`created_by`
LEFT JOIN `sophau_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `sophau_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE
(
(`a`.`id` = :pk AND `c`.`published` > 0) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)385μs6.12KBParams/components/com_content/src/Model/ArticleModel.php:215CopySELECT `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 `sophau_categories` AS `s`
INNER JOIN `sophau_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`307μs5.19KBParams/libraries/src/Categories/Categories.php:375CopySELECT `m`.`tag_id`,`t`.*
FROM `sophau_contentitem_tag_map` AS `m`
INNER JOIN `sophau_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)171μs3.97KBParams/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 `sophau_categories` AS `s`
INNER JOIN `sophau_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`409μs3.94KBParams/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 sophau_fields AS a
LEFT JOIN `sophau_languages` AS l ON l.lang_code = a.language
LEFT JOIN sophau_users AS uc ON uc.id=a.checked_out
LEFT JOIN sophau_viewlevels AS ag ON ag.id = a.access
LEFT JOIN sophau_users AS ua ON ua.id = a.created_user_id
LEFT JOIN sophau_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `sophau_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,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) 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 ASC690μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `sophau_modules` AS `m`
LEFT JOIN `sophau_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `sophau_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`421μs1.97KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT *
FROM sophau_modules
WHERE published=1
ORDER BY id230μs19.27KB/administrator/components/com_accordeonmenuck/helpers/ckfof.php:165CopySELECT a.layoutcss, a.customcss FROM sophau_accordeonmenuck_styles as a WHERE (a.state IN (0, 1)) AND a.id = 194μs592B/administrator/components/com_accordeonmenuck/helpers/ckfof.php:174CopySELECT 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 sophau_fields AS a
LEFT JOIN `sophau_languages` AS l ON l.lang_code = a.language
LEFT JOIN sophau_users AS uc ON uc.id=a.checked_out
LEFT JOIN sophau_viewlevels AS ag ON ag.id = a.access
LEFT JOIN sophau_users AS ua ON ua.id = a.created_user_id
LEFT JOIN sophau_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 ASC671μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySHOW TABLES231μs1.76KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678CopySELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count
FROM `sophau_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1112μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466CopySELECT `session_id`
FROM `sophau_session`
WHERE `session_id` = ?85μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyUPDATE `sophau_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?3.45ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy