A St-Nicolas le mercredi 16 février. à 9h00
Joomla! Version | 5.3.3 |
PHP Version | 8.2.29 |
Identity | guest |
Response | 200 |
Template | cassiopeia |
Database |
|
1 x afterInitialise (2.8MB) (11.48%) | 24.15ms |
1 x afterRoute (1.74MB) (8.38%) | 17.64ms |
1 x onJCalProEventsModelGetCategoriesEnd (19.57KB) (8.09%) | 17.03ms |
1 x onJCalProSiteViewDisplayEnd (120.84KB) (5.25%) | 11.05ms |
1 x onJCalProSiteViewDisplayStart (831.51KB) (4.24%) | 8.92ms |
1 x onJCalProEventsModelPrepareEventStart: 3308 (336.04KB) (3.47%) | 7.31ms |
1 x Before Access::preloadPermissions (com_jcalpro) (29.91KB) (3.36%) | 7.07ms |
1 x After Access::preloadPermissions (com_jcalpro) (2.82MB) (3.21%) | 6.76ms |
1 x onJCalProEventsModelConstructStart (211.94KB) (2.76%) | 5.82ms |
1 x onJCalProEventsModelGetCategoriesStart (83.04KB) (2.57%) | 5.41ms |
1 x onJCalProEventsModelCategoryXrefStart (210.07KB) (2.22%) | 4.67ms |
1 x onJCalProEventsModelConstructStart (49.64KB) (2.15%) | 4.52ms |
1 x onJCalProEventsModelPrepareEventStart: 4962 (106.22KB) (2.12%) | 4.46ms |
1 x onJCalProEventsModelConstructStart (106.58KB) (1.85%) | 3.90ms |
1 x onJCalProEventsModelPrepareEventStart: 11554 (41.32KB) (1.7%) | 3.58ms |
1 x afterRender (72.49KB) (1.49%) | 3.14ms |
1 x onJCalProEventsModelPrepareEventStart: 6116 (59.32KB) (1.43%) | 3.00ms |
1 x onJCalProEventsModelPrepareEventStart: 4963 (103.73KB) (1.4%) | 2.94ms |
1 x onJCalProEventsModelPrepareEventStart: 6157 (54.93KB) (1.36%) | 2.86ms |
1 x onJCalProEventsModelPrepareEventStart: 6156 (68.93KB) (1.36%) | 2.86ms |
1 x onJCalProEventsModelPrepareEventStart: 6137 (55.15KB) (1.35%) | 2.84ms |
1 x onJCalProEventsModelPrepareEventStart: 4966 (69.81KB) (1.35%) | 2.84ms |
1 x onJCalProEventsModelPrepareEventStart: 4967 (59.21KB) (1.35%) | 2.83ms |
1 x onJCalProEventsModelPrepareEventStart: 4968 (69.45KB) (1.34%) | 2.82ms |
1 x onJCalProEventsModelPrepareEventStart: 6115 (68.88KB) (1.33%) | 2.79ms |
1 x onJCalProEventsModelPrepareEventStart: 4964 (68.74KB) (1.32%) | 2.78ms |
1 x onJCalProEventsModelPrepareEventStart: 6136 (69.05KB) (1.32%) | 2.77ms |
1 x onJCalProEventsModelPrepareEventStart: 4965 (71.73KB) (1.31%) | 2.75ms |
1 x onJCalProEventsModelGetItemsEnd (20) (54.92KB) (1.28%) | 2.70ms |
1 x onJCalProEventsModelPrepareEventStart: 5151 (56.2KB) (1.28%) | 2.70ms |
1 x onJCalProEventsModelPrepareEventStart: 4971 (56.96KB) (1.26%) | 2.66ms |
1 x onJCalProEventsModelPrepareEventStart: 6114 (68.84KB) (1.25%) | 2.64ms |
1 x onJCalProEventsModelPrepareEventStart: 6138 (70.7KB) (1.22%) | 2.56ms |
1 x onJCalProEventsModelPrepareEventStart: 4972 (55.15KB) (1.2%) | 2.53ms |
1 x onJCalProEventsModelCategoryXrefStart (46.3KB) (1.01%) | 2.13ms |
1 x afterLoad (72.79KB) (1.01%) | 2.13ms |
1 x onJCalProEventsModelGetItemsEnd (3) (55.38KB) (0.94%) | 1.97ms |
1 x onJCalProEventsModelPrepareEventStart: 11577 (55.45KB) (0.83%) | 1.75ms |
1 x onJCalProEventsModelPrepareEventStart: 11562 (55.66KB) (0.81%) | 1.70ms |
1 x onJCalProEventsModelConstructEnd (65.25KB) (0.8%) | 1.69ms |
1 x After Access::preloadComponents (all components) (138.68KB) (0.74%) | 1.55ms |
1 x onJCalProEventsModelGetCategoriesEnd (53.2KB) (0.64%) | 1.34ms |
1 x onJCalProEventsModelCategoryXrefStart (12.66KB) (0.57%) | 1.20ms |
1 x onJCalProEventsModelCategoryXrefStart (14.18KB) (0.56%) | 1.17ms |
1 x Before Access::preloadComponents (all components) (7.56KB) (0.55%) | 1.16ms |
1 x onJCalProEventsModelCategoryXrefEnd: 20 events processed (3307,3308,6116,4962,4968,6136,4963,6137,4964,4971,6114,5151,6138,4965,4972,6115,4966,4967,6156,6157) (23.59KB) (0.54%) | 1.14ms |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (3307) (10.98KB) (0.52%) | 1.09ms |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11577) (3.23KB) (0.48%) | 1.01ms |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11554) (12.13KB) (0.47%) | 983μs |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11562) (12.12KB) (0.44%) | 923μs |
1 x beforeRenderComponent com_jcalpro (42.58KB) (0.34%) | 708μs |
1 x afterDispatch (66.2KB) (0.08%) | 168μs |
1 x Before Access::getAssetRules (id:6166 name:com_jcalpro.category.169) (131.05KB) (0.08%) | 165μs |
3 x onJCalProEventsModelConstructEnd (960B) (0.07%) | 154μs |
1 x onJCalProStart (18.77KB) (0.07%) | 145μs |
1 x onJCalProEventsModelGetItemsStart (21.87KB) (0.06%) | 133μs |
1 x After Access::getAssetRules (id:1 name:root.1) (5.64KB) (0.06%) | 131μs |
1 x onJCalProEventsModelConstructStart (1.56KB) (0.03%) | 64μs |
1 x After Access::getAssetRules (id:6166 name:com_jcalpro.category.169) (7.27KB) (0.02%) | 34μs |
1 x Before Access::getAssetRules (id:1 name:root.1) (1.51KB) (0.01%) | 14μs |
1 x onJCalProEventsModelCategoryXrefStart (8.04KB) (0.01%) | 12μs |
1 x onJCalProEventsModelGetCategoriesStart (1.13KB) (0%) | 9μs |
1 x onJCalProEventsModelPrepareEventStart: 3307 (720B) (0%) | 8μs |
1 x onJCalProEventsModelPrepareEventStart: 3307 (744B) (0%) | 8μs |
1 x onJCalProEventsModelGetItemsStart (736B) (0%) | 7μs |
1 x onJCalProEnd (696B) (0%) | 7μs |
1 x onJCalProEventsModelPrepareEventStart: 3307 (768B) (0%) | 6μs |
1 x afterRenderComponent com_jcalpro (12.3KB) (0%) | 5μs |
SELECT @@SESSION.sql_mode;
238μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259CopySELECT `data`
FROM `testaoutsession`
WHERE `session_id` = ?
429μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250CopySELECT `session_id`
FROM `testaoutsession`
WHERE `session_id` = :session_id LIMIT 1
387μs1.3KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `testaoutsession`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
1.12ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `id`,`rules`
FROM `testaoutviewlevels`
410μs992B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `testaoutusergroups` AS `a`
LEFT JOIN `testaoutusergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
537μs1.33KBParams/libraries/src/Access/Access.php:868CopySELECT *
FROM `testaoutnextend2_section_storage`
WHERE `application` = 'smartslider' AND `section` = 'settings'
485μs896B/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:182CopySHOW FULL COLUMNS FROM `testaoutjcalpro_events`
2.95ms2.27KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539CopySELECT *
FROM `testaoutjcalpro_events`
WHERE `id` = '3307'
733μs6.72KB/libraries/src/Table/Table.php:780CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
547μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT category_id
FROM testaoutjcalpro_event_categories
WHERE event_id = 3307
ORDER BY canonical DESC
2.4ms536B/administrator/components/com_jcalpro/tables/event.php:355CopySELECT `extension_id`,`name`,`enabled`,`params`
FROM testaoutextensions
WHERE `type` = 'component' AND `element` = 'com_jcalpro'
517μs704B/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:170CopySELECT *
FROM `testaoutjcalpro_events`
WHERE `id` = '3307'
579μs6.09KB/libraries/src/Table/Table.php:780CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
443μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT category_id
FROM testaoutjcalpro_event_categories
WHERE event_id = 3307
ORDER BY canonical DESC
1.65ms536B/administrator/components/com_jcalpro/tables/event.php:355CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 3307
2.7ms656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT `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 `testaoutcategories` AS `s`
INNER JOIN `testaoutcategories` 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`
951μs5.17KBParams/libraries/src/Categories/Categories.php:375CopySELECT id,type
FROM testaoutjcalpro_forms
WHERE `default` = 1 AND published = 1
412μs576B/components/com_jcalpro/models/categories.php:263CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `testaoutassets`
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,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47)
1.06ms7.81KBParams/libraries/src/Access/Access.php:357CopySELECT a.id, a.title, a.alias, a.note, a.published, a.access, a.checked_out, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language, a.description,`l`.`title` AS `language_title`,`l`.`image` AS `language_image`,`uc`.`name` AS `editor`,`ag`.`title` AS `access_level`,`ua`.`name` AS `author_name`,a.params,a.metadata,a.description
FROM `testaoutcategories` AS `a`
LEFT JOIN `testaoutlanguages` AS `l` ON `l`.`lang_code` = `a`.`language`
LEFT JOIN `testaoutusers` AS `uc` ON `uc`.`id` = `a`.`checked_out`
LEFT JOIN `testaoutviewlevels` AS `ag` ON `ag`.`id` = `a`.`access`
LEFT JOIN `testaoutusers` AS `ua` ON `ua`.`id` = `a`.`created_user_id`
WHERE `a`.`extension` = :extension AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND `a`.`published` = :published
GROUP BY a.id,
a.title,
a.alias,
a.note,
a.published,
a.access,
a.checked_out,
a.checked_out_time,
a.created_user_id,
a.path,
a.parent_id,
a.level,
a.lft,
a.rgt,
a.language,
l.title,
l.image,
uc.name,
ag.title,
ua.name,a.id
ORDER BY a.lft ASC
1.78ms3.78KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT Xref.category_id, COUNT(Event.id) as count
FROM testaoutjcalpro_events AS Event
LEFT JOIN testaoutjcalpro_event_categories AS Xref ON Xref.event_id = Event.id
WHERE Xref.category_id IN (160,161,162,164,166,167,168,169,170,171) AND Event.published = 1 AND Event.approved = 1 AND (Event.private = 0 OR (Event.private = 1 AND Event.created_by = 0))
GROUP BY Xref.category_id
8.68ms736B/components/com_jcalpro/models/categories.php:187CopySELECT Xref.category_id, COUNT(Event.id) as count
FROM testaoutjcalpro_events AS Event
LEFT JOIN testaoutjcalpro_event_categories AS Xref ON Xref.event_id = Event.id
WHERE Xref.category_id IN (160,161,162,164,166,167,168,169,170,171) AND Event.published = 1 AND Event.approved = 1 AND (Event.private = 0 OR (Event.private = 1 AND Event.created_by = 0)) AND Event.start_date >= '2025-10-07 22:00:00'
GROUP BY Xref.category_id
4.96ms624B/components/com_jcalpro/models/categories.php:195CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (3307)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
799μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Model/AbstractModelEvents.php:1108CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
329μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySHOW FULL COLUMNS FROM `testaoutjcalpro_locations`
1.01ms1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539CopySELECT *
FROM `testaoutjcalpro_locations`
WHERE `id` = '7'
355μs2.5KB/libraries/src/Table/Table.php:780CopySELECT id
FROM testaoutcategories
WHERE `published` = 1 AND `extension` = 'com_jcalpro' AND access IN (1,5)
343μs680B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Model/AbstractModelEvents.php:2071CopySELECT `Event`.*,'com_jcalpro' AS context,CASE `Event`.`created_by` WHEN 0 THEN 'Invité' WHEN -1 THEN 'Système' ELSE `author`.`name` END AS author_name,CASE `Event`.`created_by` WHEN 0 THEN 'invité' WHEN -1 THEN 'système' ELSE `author`.`username` END AS author_username,CASE `Event`.`checked_out` WHEN 0 THEN 'Invité' WHEN -1 THEN 'Système' ELSE `editor`.`name` END AS editor_name,CASE `Event`.`checked_out` WHEN 0 THEN 'invité' WHEN -1 THEN 'système' ELSE `editor`.`username` END AS editor_username
FROM testaoutjcalpro_events AS `Event`
LEFT JOIN testaoutusers AS author ON author.id = `Event`.`created_by`
LEFT JOIN testaoutusers AS editor ON editor.id = `Event`.`checked_out`
INNER JOIN (
SELECT event_id,category_id
FROM testaoutjcalpro_event_categories
WHERE category_id IN (168,169,170,171)) AS `Category` ON `Category`.`event_id` = `Event`.`id`
WHERE `Event`.`approved` = 1 AND `Event`.`published` = 1 AND `Event`.`location` = 7 AND `Event`.`start_date` < '2025-10-08 23:50:52' AND `Event`.`private` = 0
GROUP BY `Event`.`id`
ORDER BY `Event`.`featured` DESC,`Event`.`start_date` ASC LIMIT 20
3.47ms9.3KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (3308,6116,4962,4968,6136,4963,6137,4964,4971,6114,5151,6138,4965,4972,6115,4966,4967,6156,6157)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
859μs1KB/administrator/components/com_jcalpro/library/alledia/Jcalpro/Model/AbstractModelEvents.php:1108CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
327μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
621μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 3308
868μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
329μs3.82KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
477μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 6116
839μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT `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 `testaoutcategories` AS `s`
INNER JOIN `testaoutcategories` 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`
514μs3.92KBParams/libraries/src/Categories/Categories.php:375CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
283μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
456μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 4962
806μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
284μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
414μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 4968
803μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
252μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
438μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 6136
842μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
282μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
414μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 4963
865μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
298μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
439μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 6137
809μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
288μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
403μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 4964
861μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
239μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
369μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 4971
758μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
246μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
370μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 6114
765μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
245μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
553μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 5151
790μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
240μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
371μs15.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 6138
755μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
252μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
434μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 4965
761μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
223μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
406μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 4972
824μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
285μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
385μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 6115
815μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
303μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
425μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 4966
785μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
271μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
535μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 4967
873μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
279μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
390μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 6156
951μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
288μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
398μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 6157
807μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
267μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
418μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `Event`.*,'com_jcalpro' AS context,CASE `Event`.`created_by` WHEN 0 THEN 'Invité' WHEN -1 THEN 'Système' ELSE `author`.`name` END AS author_name,CASE `Event`.`created_by` WHEN 0 THEN 'invité' WHEN -1 THEN 'système' ELSE `author`.`username` END AS author_username,CASE `Event`.`checked_out` WHEN 0 THEN 'Invité' WHEN -1 THEN 'Système' ELSE `editor`.`name` END AS editor_name,CASE `Event`.`checked_out` WHEN 0 THEN 'invité' WHEN -1 THEN 'système' ELSE `editor`.`username` END AS editor_username
FROM testaoutjcalpro_events AS `Event`
LEFT JOIN testaoutusers AS author ON author.id = `Event`.`created_by`
LEFT JOIN testaoutusers AS editor ON editor.id = `Event`.`checked_out`
INNER JOIN (
SELECT event_id,category_id
FROM testaoutjcalpro_event_categories
WHERE category_id IN (168,169,170,171)) AS `Category` ON `Category`.`event_id` = `Event`.`id`
WHERE `Event`.`approved` = 1 AND `Event`.`published` = 1 AND `Event`.`location` = 7 AND `Event`.`start_date` >= '2025-10-08 23:50:52' AND `Event`.`private` = 0
GROUP BY `Event`.`id`
ORDER BY `Event`.`featured` DESC,`Event`.`start_date` ASC LIMIT 20
3.04ms9.03KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 11554
784μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11554)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
718μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Model/AbstractModelEvents.php:1108CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
238μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
390μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 11562
801μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11562)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
685μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Model/AbstractModelEvents.php:1108CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
245μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
408μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 11577
792μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT `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 `testaoutcategories` AS `s`
INNER JOIN `testaoutcategories` 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`
464μs3.92KBParams/libraries/src/Categories/Categories.php:375CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11577)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
704μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Model/AbstractModelEvents.php:1108CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
255μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
409μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT *
FROM `testaoutjcalpro_events`
WHERE `id` = '3307'
323μs6.09KB/libraries/src/Table/Table.php:780CopySELECT `t`.`id`
FROM `testaouttags` AS `t`
INNER JOIN `testaoutcontentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
249μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySELECT category_id
FROM testaoutjcalpro_event_categories
WHERE event_id = 3307
ORDER BY canonical DESC
695μs536B/administrator/components/com_jcalpro/tables/event.php:355CopySELECT 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 testaoutfields AS a
LEFT JOIN `testaoutlanguages` AS l ON l.lang_code = a.language
LEFT JOIN testaoutusers AS uc ON uc.id=a.checked_out
LEFT JOIN testaoutviewlevels AS ag ON ag.id = a.access
LEFT JOIN testaoutusers AS ua ON ua.id = a.created_user_id
LEFT JOIN testaoutfields_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
434μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `testaoutassets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0
2.34ms229.48KBParams/libraries/src/Access/Access.php:301CopySELECT a.id, a.title, a.alias, a.note, a.published, a.access, a.checked_out, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language, a.description,`l`.`title` AS `language_title`,`l`.`image` AS `language_image`,`uc`.`name` AS `editor`,`ag`.`title` AS `access_level`,`ua`.`name` AS `author_name`,a.params,a.metadata,a.description
FROM `testaoutcategories` AS `a`
LEFT JOIN `testaoutlanguages` AS `l` ON `l`.`lang_code` = `a`.`language`
LEFT JOIN `testaoutusers` AS `uc` ON `uc`.`id` = `a`.`checked_out`
LEFT JOIN `testaoutviewlevels` AS `ag` ON `ag`.`id` = `a`.`access`
LEFT JOIN `testaoutusers` AS `ua` ON `ua`.`id` = `a`.`created_user_id`
WHERE `a`.`extension` = :extension AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND `a`.`published` = :published
GROUP BY a.id,
a.title,
a.alias,
a.note,
a.published,
a.access,
a.checked_out,
a.checked_out_time,
a.created_user_id,
a.path,
a.parent_id,
a.level,
a.lft,
a.rgt,
a.language,
l.title,
l.image,
uc.name,
ag.title,
ua.name,a.id
ORDER BY a.lft ASC
603μs3.78KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT Form.*,COUNT(Xref.field_id) AS FormFieldCount,CASE `Form`.`created_by` WHEN 0 THEN 'Invité' WHEN -1 THEN 'Système' ELSE `author`.`name` END AS author_name,CASE `Form`.`created_by` WHEN 0 THEN 'invité' WHEN -1 THEN 'système' ELSE `author`.`username` END AS author_username,CASE `Form`.`checked_out` WHEN 0 THEN 'Invité' WHEN -1 THEN 'Système' ELSE `editor`.`name` END AS editor_name,CASE `Form`.`checked_out` WHEN 0 THEN 'invité' WHEN -1 THEN 'système' ELSE `editor`.`username` END AS editor_username
FROM testaoutjcalpro_forms AS Form
LEFT JOIN testaoutjcalpro_form_fields AS Xref ON Form.id=Xref.form_id
LEFT JOIN testaoutusers AS author ON author.id = `Form`.`created_by`
LEFT JOIN testaoutusers AS editor ON editor.id = `Form`.`checked_out`
WHERE Form.published = 1 AND Form.type = 0 AND Form.default = 1
GROUP BY Form.id
ORDER BY Form.title ASC
353μs2.36KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `m`.`tag_id`,`t`.*
FROM `testaoutcontentitem_tag_map` AS `m`
INNER JOIN `testaouttags` 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)
411μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT *
FROM `testaoutjcalpro_locations`
WHERE `id` = '7'
323μs2.5KB/libraries/src/Table/Table.php:780CopySELECT `event`.`id`,`event`.`alias`,`category`.`category_id`
FROM testaoutjcalpro_events AS `event`
LEFT JOIN testaoutjcalpro_event_categories AS `category` ON `category`.`event_id` = `event`.`id` AND `category`.`canonical` = 1
WHERE `event`.`id` = 3307
825μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT 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 `testaoutscheduler_tasks` AS `a`
WHERE `a`.`state` = 1
297μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517CopySELECT `session_id`
FROM `testaoutsession`
WHERE `session_id` = ?
268μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277CopyUPDATE `testaoutsession`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
618μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy