Page 124 sur 132
Une émission réalisée et enregistrée au cœur d’Istanbul, en partenariat avec l’Institut du Bosphore. La Turquie célébrera, dimanche 29 octobre[…]
par Panayotis Soldatos, le 17 février 2025
par Bruno Vever, le 15 janvier 2025
par Panayotis Soldatos, le 1er octobre 2024
par Bruno Vever, le 23 septembre 2024
par Xavier Grosclaude, le 14 avril 2024
Joomla! Version | 4.2.8 |
PHP Version | 8.0.30 |
Identity | guest |
Response | 200 |
Template | cassiopeia |
Database |
|
1 x afterRenderComponent com_content (1.94MB) (34.63%) | 107.51ms |
1 x afterRenderRawModule mod_articles_category (L'EUROPE DES IDEES...) (186.8KB) (18.45%) | 57.28ms |
1 x afterInitialise (5.63MB) (11.8%) | 36.62ms |
1 x afterLoad (4.18MB) (4.5%) | 13.97ms |
1 x Before Access::getAssetRules (id:8 name:com_content) (314.14KB) (3.43%) | 10.65ms |
1 x afterRender (594.41KB) (3.14%) | 9.76ms |
1 x beforeRenderComponent com_content (1.18MB) (2.88%) | 8.94ms |
1 x beforeRenderRawModule mod_custom (RESEAUX SOCIAUX ) (762.26KB) (2.75%) | 8.55ms |
1 x Before Access::preloadComponents (all components) (997.11KB) (1.8%) | 5.58ms |
1 x afterRoute (356.07KB) (1.59%) | 4.94ms |
1 x After Access::preloadPermissions (com_content) (812.7KB) (0.96%) | 2.97ms |
1 x After Access::preloadComponents (all components) (114.63KB) (0.85%) | 2.63ms |
1 x afterRenderRawModule mod_rss_reader_david (PODCAST) (69.32KB) (0.73%) | 2.27ms |
1 x afterRenderRawModule mod_menu (Menu principal) (138.41KB) (0.61%) | 1.89ms |
1 x afterRenderRawModule mod_custom (RESEAUX SOCIAUX ) (37.88KB) (0.26%) | 811μs |
1 x beforeRenderModule mod_custom (Partenaires) (34.73KB) (0.1%) | 296μs |
1 x After Access::getAssetRules (id:53 name:com_content.category.9) (28.8KB) (0.06%) | 188μs |
1 x afterRenderModule mod_custom (Partenaires) (6.62KB) (0.06%) | 173μs |
1 x afterRenderRawModule mod_custom (Partenaires) (912B) (0.05%) | 153μs |
1 x afterRenderModule mod_custom (RESEAUX SOCIAUX ) (2.95KB) (0.03%) | 105μs |
1 x afterRenderModule mod_articles_category (L'EUROPE DES IDEES...) (5.96KB) (0.03%) | 93μs |
1 x beforeRenderRawModule mod_menu (Menu principal) (5.09KB) (0.03%) | 88μs |
1 x afterRenderModule mod_rss_reader_david (PODCAST) (3.95KB) (0.03%) | 88μs |
1 x afterRenderModule mod_menu (Menu principal) (5.73KB) (0.03%) | 78μs |
1 x afterDispatch (2.25KB) (0.02%) | 75μs |
1 x beforeRenderRawModule mod_custom (Partenaires) (1.17KB) (0.02%) | 75μs |
1 x beforeRenderModule mod_menu (Menu principal) (6.07KB) (0.02%) | 64μs |
1 x beforeRenderRawModule mod_articles_category (L'EUROPE DES IDEES...) (5.27KB) (0.01%) | 39μs |
1 x beforeRenderModule mod_custom (RESEAUX SOCIAUX ) (16B) (0.01%) | 38μs |
1 x Before Access::getAssetRules (id:53 name:com_content.category.9) (67.17KB) (0.01%) | 33μs |
1 x beforeRenderRawModule mod_rss_reader_david (PODCAST) (4.25KB) (0.01%) | 29μs |
1 x beforeRenderModule mod_articles_category (L'EUROPE DES IDEES...) (6.21KB) (0.01%) | 27μs |
1 x After Access::getAssetRules (id:8 name:com_content) (7.88KB) (0.01%) | 26μs |
1 x beforeRenderModule mod_rss_reader_david (PODCAST) (3.2KB) (0.01%) | 22μs |
1 x Before Access::preloadPermissions (com_content) (4.59KB) (0%) | 12μs |
SELECT @@SESSION.sql_mode;
233μs1.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:293CopySELECT `data`
FROM `ju3mf_session`
WHERE `session_id` = ?
375μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `ju3mf_session`
WHERE `session_id` = :session_id LIMIT 1
251μs1.61KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `ju3mf_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
1.74ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ju3mf_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
577μs4.73KB/libraries/src/Component/ComponentHelper.php:393CopySELECT `id`,`rules`
FROM `ju3mf_viewlevels`
422μs1.11KB/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `ju3mf_usergroups` AS `a`
LEFT JOIN `ju3mf_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
427μs1.67KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `ju3mf_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`
1.37ms11.8KBParams/libraries/src/Plugin/PluginHelper.php:283CopySELECT `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 `ju3mf_menu` AS `m`
LEFT JOIN `ju3mf_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`
611μs7.89KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT *
FROM `ju3mf_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
355μs2.67KB/libraries/src/Language/LanguageHelper.php:142CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `ju3mf_template_styles` AS `s`
LEFT JOIN `ju3mf_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id`
WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1
565μs1.33KB/administrator/components/com_templates/src/Model/StyleModel.php:771CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `ju3mf_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)
934μs10.25KBParams/libraries/src/Access/Access.php:357CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `ju3mf_assets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0
2.09ms145.8KBParams/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 `ju3mf_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `ju3mf_categories` AS `s`
INNER JOIN `ju3mf_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`
5.15ms6.14KBParams/libraries/src/Categories/Categories.php:360CopySELECT `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 `ju3mf_content` AS `a`
LEFT JOIN `ju3mf_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `ju3mf_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `ju3mf_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `ju3mf_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `ju3mf_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `ju3mf_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` = :categoryId AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)
ORDER BY c.lft, CASE WHEN a.publish_up IS NULL THEN a.created ELSE a.publish_up END DESC , a.created LIMIT 1107, 13
42.19ms221.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165CopySELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.*
FROM `ju3mf_contentitem_tag_map` AS `m`
INNER JOIN `ju3mf_tags` AS `t` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :contentType AND `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13) AND `t`.`access` IN (:preparedArray14,:preparedArray15)
593μs6.16KBParams/libraries/src/Helper/TagsHelper.php:448CopySELECT COUNT(*)
FROM `ju3mf_content` AS `a`
LEFT JOIN `ju3mf_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `ju3mf_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `ju3mf_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `ju3mf_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `ju3mf_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `ju3mf_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` = :categoryId AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)
20.93ms7.43KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:198CopySELECT `m`.`tag_id`,`t`.*
FROM `ju3mf_contentitem_tag_map` AS `m`
INNER JOIN `ju3mf_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)
714μs5.22KBParams/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 `ju3mf_categories` AS `s`
INNER JOIN `ju3mf_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`
1.05ms6.03KBParams/libraries/src/Categories/Categories.php:360CopySELECT 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 ju3mf_fields AS a
LEFT JOIN `ju3mf_languages` AS l ON l.lang_code = a.language
LEFT JOIN ju3mf_users AS uc ON uc.id=a.checked_out
LEFT JOIN ju3mf_viewlevels AS ag ON ag.id = a.access
LEFT JOIN ju3mf_users AS ua ON ua.id = a.created_user_id
LEFT JOIN ju3mf_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `ju3mf_fields_categories` AS fc ON fc.field_id = a.id
WHERE
(
(`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) AND `a`.`state` = :state) AND
(`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform
ORDER BY a.ordering ASC
1.38ms6KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165CopySELECT 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 ju3mf_fields AS a
LEFT JOIN `ju3mf_languages` AS l ON l.lang_code = a.language
LEFT JOIN ju3mf_users AS uc ON uc.id=a.checked_out
LEFT JOIN ju3mf_viewlevels AS ag ON ag.id = a.access
LEFT JOIN ju3mf_users AS ua ON ua.id = a.created_user_id
LEFT JOIN ju3mf_fields_groups AS g ON g.id = a.group_id
WHERE
(
(`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND
(`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform
ORDER BY a.ordering ASC
1.02ms5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165CopySELECT `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 `ju3mf_categories` AS `s`
INNER JOIN `ju3mf_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`
909μs6.03KBParams/libraries/src/Categories/Categories.php:360CopySELECT 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 ju3mf_fields AS a
LEFT JOIN `ju3mf_languages` AS l ON l.lang_code = a.language
LEFT JOIN ju3mf_users AS uc ON uc.id=a.checked_out
LEFT JOIN ju3mf_viewlevels AS ag ON ag.id = a.access
LEFT JOIN ju3mf_users AS ua ON ua.id = a.created_user_id
LEFT JOIN ju3mf_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `ju3mf_fields_categories` AS fc ON fc.field_id = a.id
WHERE
(
(`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) AND `a`.`state` = :state) AND
(`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform
ORDER BY a.ordering ASC
1.17ms6KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165CopySELECT `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 `ju3mf_categories` AS `s`
INNER JOIN `ju3mf_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`
900μs6.03KBParams/libraries/src/Categories/Categories.php:360CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `ju3mf_modules` AS `m`
LEFT JOIN `ju3mf_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `ju3mf_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`
1.3ms2.83KBParams/libraries/src/Cache/Controller/CallbackController.php:52CopySELECT `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 `ju3mf_content` AS `a`
LEFT JOIN `ju3mf_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `ju3mf_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `ju3mf_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `ju3mf_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `ju3mf_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `ju3mf_content_rating` AS `v` ON `a`.`id` = `v`.`content_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 publish_up DESC LIMIT 5
49ms188.92KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165CopySELECT 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 ju3mf_fields AS a
LEFT JOIN `ju3mf_languages` AS l ON l.lang_code = a.language
LEFT JOIN ju3mf_users AS uc ON uc.id=a.checked_out
LEFT JOIN ju3mf_viewlevels AS ag ON ag.id = a.access
LEFT JOIN ju3mf_users AS ua ON ua.id = a.created_user_id
LEFT JOIN ju3mf_fields_groups AS g ON g.id = a.group_id
WHERE
(
(`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND
(`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform
ORDER BY a.ordering ASC
1.12ms5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165CopySELECT `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 `ju3mf_scheduler_tasks` AS `a`
LEFT JOIN `ju3mf_users` AS `uc` ON `uc`.`id` = `a`.`checked_out`
WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now
ORDER BY `a`.`title` asc
494μs4.45KBParams/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 `ju3mf_scheduler_tasks` AS `a`
LEFT JOIN `ju3mf_users` AS `uc` ON `uc`.`id` = `a`.`checked_out`
WHERE `a`.`state` = :state AND `a`.`locked` IS NOT NULL
ORDER BY `a`.`title` asc
478μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy