Joomla! Version | 5.3.3 |
PHP Version | 8.2.29 |
Identity | guest |
Response | 200 |
Template | cassiopeia |
Database |
|
1 x afterInitialise (2.8MB) (9.75%) | 21.53ms |
1 x onJCalProEventsModelGetCategoriesEnd (24.66KB) (5.8%) | 12.80ms |
1 x onJCalProEventsModelPrepareEventStart: 6236 (257.2KB) (3.32%) | 7.33ms |
1 x After Access::preloadPermissions (com_jcalpro) (2.86MB) (3.15%) | 6.96ms |
5 x onJCalProEventsModelCategoryXrefStart (13.87KB) (2.55%) | 5.64ms |
1 x onJCalProEventsModelPrepareEventStart: 3305 (308.41KB) (2.51%) | 5.54ms |
1 x onJCalProEventsModelConstructStart (418.63KB) (2.19%) | 4.83ms |
1 x onJCalProEventsModelCategoryXrefStart (44.81KB) (2.09%) | 4.63ms |
1 x onJCalProEventsModelCategoryXrefStart (205.48KB) (2.03%) | 4.47ms |
1 x onJCalProEventsModelPrepareEventStart: 11511 (197.88KB) (1.75%) | 3.87ms |
1 x afterRender (60.17KB) (1.69%) | 3.73ms |
3 x onJCalProEventsModelCategoryXrefStart (14.23KB) (1.54%) | 3.40ms |
1 x onJCalProEventsModelConstructStart (453.3KB) (1.44%) | 3.19ms |
1 x onJCalProEventsModelPrepareEventStart: 4976 (80.29KB) (1.4%) | 3.10ms |
1 x onJCalProEventsModelPrepareEventStart: 6237 (101.32KB) (1.39%) | 3.07ms |
1 x onJCalProEventsModelPrepareEventStart: 6291 (70.68KB) (1.37%) | 3.03ms |
1 x onJCalProEventsModelPrepareEventStart: 6290 (85.62KB) (1.36%) | 3.01ms |
1 x onJCalProEventsModelPrepareEventStart: 6283 (69.18KB) (1.32%) | 2.91ms |
1 x onJCalProEventsModelPrepareEventStart: 6239 (68.77KB) (1.32%) | 2.91ms |
1 x onJCalProEventsModelPrepareEventStart: 6148 (69.18KB) (1.3%) | 2.88ms |
1 x onJCalProEventsModelPrepareEventStart: 4969 (67.92KB) (1.27%) | 2.81ms |
1 x onJCalProEventsModelPrepareEventStart: 6292 (72.55KB) (1.27%) | 2.80ms |
1 x onJCalProEventsModelPrepareEventStart: 6302 (72.87KB) (1.25%) | 2.76ms |
1 x onJCalProEventsModelPrepareEventStart: 6238 (54.33KB) (1.24%) | 2.73ms |
1 x onJCalProEventsModelPrepareEventStart: 6293 (68.35KB) (1.22%) | 2.70ms |
1 x onJCalProEventsModelGetCategoriesStart (63.33KB) (1.22%) | 2.69ms |
1 x onJCalProEventsModelPrepareEventStart: 6163 (68.48KB) (1.21%) | 2.68ms |
1 x onJCalProEventsModelGetItemsEnd (20) (69.12KB) (1.21%) | 2.67ms |
1 x onJCalProEventsModelPrepareEventStart: 6146 (72.35KB) (1.19%) | 2.62ms |
1 x onJCalProEventsModelPrepareEventStart: 6181 (54.26KB) (1.18%) | 2.60ms |
1 x onJCalProEventsModelPrepareEventStart: 5103 (54.77KB) (1.17%) | 2.59ms |
1 x onJCalProEventsModelPrepareEventStart: 6297 (56.66KB) (1.16%) | 2.57ms |
2 x onJCalProEventsModelCategoryXrefStart (13.69KB) (1.14%) | 2.51ms |
1 x onJCalProSiteViewDisplayEnd (30.95KB) (1.08%) | 2.38ms |
1 x afterRoute (1.46MB) (1.06%) | 2.35ms |
2 x onJCalProEventsModelCategoryXrefStart (14.02KB) (1.01%) | 2.23ms |
1 x afterLoad (72.79KB) (0.92%) | 2.04ms |
1 x onJCalProEventsModelCategoryXrefStart (13.59KB) (0.81%) | 1.79ms |
1 x onJCalProEventsModelPrepareEventStart: 11583 (53.38KB) (0.8%) | 1.76ms |
1 x onJCalProEventsModelPrepareEventStart: 11513 (59.08KB) (0.78%) | 1.73ms |
1 x onJCalProEventsModelPrepareEventStart: 11514 (57.47KB) (0.76%) | 1.67ms |
1 x onJCalProEventsModelPrepareEventStart: 11555 (55.02KB) (0.75%) | 1.66ms |
1 x onJCalProEventsModelPrepareEventStart: 11558 (57.68KB) (0.73%) | 1.62ms |
1 x onJCalProEventsModelPrepareEventStart: 11543 (54.72KB) (0.73%) | 1.62ms |
1 x onJCalProEventsModelPrepareEventStart: 11568 (57.66KB) (0.73%) | 1.60ms |
1 x onJCalProEventsModelPrepareEventStart: 11580 (54.72KB) (0.72%) | 1.60ms |
1 x onJCalProEventsModelPrepareEventStart: 11563 (54.66KB) (0.72%) | 1.59ms |
1 x onJCalProEventsModelPrepareEventStart: 11564 (58.72KB) (0.71%) | 1.57ms |
1 x onJCalProEventsModelPrepareEventStart: 11512 (54.66KB) (0.7%) | 1.55ms |
1 x onJCalProEventsModelPrepareEventStart: 11581 (57.47KB) (0.7%) | 1.54ms |
1 x onJCalProEventsModelPrepareEventStart: 11566 (54.91KB) (0.69%) | 1.53ms |
1 x onJCalProEventsModelGetItemsEnd (20) (54.64KB) (0.69%) | 1.52ms |
1 x onJCalProEventsModelPrepareEventStart: 11567 (54.97KB) (0.69%) | 1.52ms |
1 x onJCalProEventsModelPrepareEventStart: 11565 (61.56KB) (0.68%) | 1.51ms |
1 x onJCalProEventsModelPrepareEventStart: 11485 (57.47KB) (0.68%) | 1.51ms |
1 x onJCalProEventsModelPrepareEventStart: 11541 (54.81KB) (0.68%) | 1.51ms |
1 x onJCalProEventsModelPrepareEventStart: 11542 (79.16KB) (0.68%) | 1.49ms |
1 x Before Access::preloadPermissions (com_jcalpro) (4.51KB) (0.66%) | 1.46ms |
1 x onJCalProEventsModelPrepareEventStart: 11544 (54.75KB) (0.66%) | 1.45ms |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11513) (11.77KB) (0.61%) | 1.36ms |
1 x onJCalProEventsModelCategoryXrefStart (13.6KB) (0.56%) | 1.25ms |
1 x onJCalProEventsModelCategoryXrefStart (12.27KB) (0.52%) | 1.14ms |
1 x onJCalProEventsModelCategoryXrefStart (14.15KB) (0.52%) | 1.14ms |
1 x onJCalProEventsModelCategoryXrefStart (13.99KB) (0.52%) | 1.14ms |
1 x onJCalProEventsModelCategoryXrefStart (14.01KB) (0.51%) | 1.13ms |
1 x onJCalProEventsModelConstructEnd (61.74KB) (0.51%) | 1.13ms |
1 x onJCalProEventsModelCategoryXrefStart (17.98KB) (0.5%) | 1.11ms |
1 x onJCalProEventsModelCategoryXrefEnd: 20 events processed (3306,3305,4969,6146,4976,6163,5103,6181,6236,6237,6148,6238,6239,6283,6290,6291,6292,6302,6297,6293) (22.7KB) (0.5%) | 1.10ms |
1 x onJCalProEventsModelGetCategoriesEnd (50.67KB) (0.5%) | 1.10ms |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11568) (4.95KB) (0.47%) | 1.03ms |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11555) (11.77KB) (0.46%) | 1.00ms |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11558) (11.73KB) (0.44%) | 976μs |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11583) (11.71KB) (0.43%) | 960μs |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11511) (11.77KB) (0.43%) | 956μs |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11563) (11.74KB) (0.43%) | 954μs |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11514) (12.39KB) (0.43%) | 954μs |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11512) (11.77KB) (0.43%) | 952μs |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11541) (11.7KB) (0.43%) | 950μs |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11544) (11.7KB) (0.43%) | 944μs |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11485) (11.71KB) (0.42%) | 930μs |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11564) (11.74KB) (0.42%) | 927μs |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11567) (11.74KB) (0.42%) | 924μs |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11543) (11.7KB) (0.42%) | 922μs |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11565) (11.74KB) (0.41%) | 911μs |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11542) (12.95KB) (0.41%) | 910μs |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11566) (11.74KB) (0.41%) | 900μs |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11580) (11.73KB) (0.4%) | 890μs |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events processed (11581) (11.71KB) (0.4%) | 890μs |
1 x Before Access::preloadComponents (all components) (7.04KB) (0.38%) | 841μs |
1 x After Access::preloadComponents (all components) (138.31KB) (0.38%) | 833μs |
1 x beforeRenderComponent com_jcalpro (42.58KB) (0.2%) | 442μs |
1 x onJCalProEventsViewPrepareDisplayBeforeGetPending (15.09KB) (0.14%) | 315μs |
1 x onJCalProSiteViewDisplayStart (21.41KB) (0.08%) | 171μs |
1 x afterDispatch (1.88KB) (0.07%) | 154μs |
1 x onJCalProEventsModelGetItemsStart (21.82KB) (0.06%) | 130μs |
1 x onJCalProEventsModelGetItemsEnd (1) (26.93KB) (0.05%) | 107μs |
1 x onJCalProStart (18.77KB) (0.04%) | 96μs |
1 x After Access::getAssetRules (id:1 name:root.1) (5.64KB) (0.04%) | 95μs |
1 x Before Access::getAssetRules (id:6166 name:com_jcalpro.category.169) (131.05KB) (0.03%) | 76μs |
1 x onJCalProEventsViewPrepareDisplayBeforeGetItems (2.2KB) (0.03%) | 65μs |
1 x onJCalProEventsModelCategoryXrefStart (2.82KB) (0.03%) | 64μs |
1 x Before Access::getAssetRules (id:6168 name:com_jcalpro.category.171) (624B) (0.02%) | 52μs |
1 x Before Access::getAssetRules (id:6167 name:com_jcalpro.category.170) (432B) (0.02%) | 40μs |
1 x onJCalProEventsModelConstructEnd (960B) (0.02%) | 37μs |
1 x After Access::getAssetRules (id:6166 name:com_jcalpro.category.169) (7.27KB) (0.01%) | 29μs |
1 x onJCalProEventsModelPrepareEventStart: 11568 (312B) (0.01%) | 15μs |
1 x Before Access::getAssetRules (id:1 name:root.1) (904B) (0.01%) | 12μs |
2 x onJCalProEventsModelGetItemsStart (736B) (0%) | 8μs |
1 x onJCalProEventsModelPrepareEventStart: 3306 (776B) (0%) | 7μs |
1 x onJCalProEventsViewPrepareDisplayBeforeGetLinkData (1.85KB) (0%) | 5μs |
1 x After Access::getAssetRules (id:6168 name:com_jcalpro.category.171) (1.3KB) (0%) | 5μs |
1 x onJCalProEnd (696B) (0%) | 5μs |
1 x afterRenderComponent com_jcalpro (13.3KB) (0%) | 5μs |
1 x onJCalProEventsModelCategoryXrefEnd: 1 events cached (11568) (1.65KB) (0%) | 4μs |
1 x onJCalProEventsViewPrepareDisplayBeforeGetItemsCount (736B) (0%) | 4μs |
1 x onJCalProEventsModelGetCategoriesStart (1.18KB) (0%) | 4μs |
1 x After Access::getAssetRules (id:6167 name:com_jcalpro.category.170) (1.3KB) (0%) | 4μs |
1 x onJCalProEventsViewPrepareDisplayStart (736B) (0%) | 3μs |
1 x onJCalProEventsViewPrepareDisplayBeforeGetCategories (736B) (0%) | 3μs |
SELECT @@SESSION.sql_mode;
219μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259CopySELECT `data`
FROM `testaoutsession`
WHERE `session_id` = ?
233μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250CopySELECT `session_id`
FROM `testaoutsession`
WHERE `session_id` = :session_id LIMIT 1
275μ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)
777μs944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `id`,`rules`
FROM `testaoutviewlevels`
288μ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
280μs1.33KBParams/libraries/src/Access/Access.php:868CopySELECT *
FROM `testaoutnextend2_section_storage`
WHERE `application` = 'smartslider' AND `section` = 'settings'
321μs896B/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:182CopySELECT `extension_id`,`name`,`enabled`,`params`
FROM testaoutextensions
WHERE `type` = 'component' AND `element` = 'com_jcalpro'
303μs704B/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:170CopySELECT id
FROM testaoutcategories
WHERE `published` = 1 AND `extension` = 'com_jcalpro' AND access IN (1,5)
293μs1.29KB/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`.`private` = 0 AND ((`Event`.`start_date` <= '2026-03-10 00:00:00' AND `Event`.`end_date` >= '2026-03-10 23:59:59' AND `Event`.`end_date` != '2038-01-18 00:00:00') OR (`Event`.`start_date` >= '2026-03-10 00:00:00' AND `Event`.`start_date` < '2026-03-10 23:59:59' AND `Event`.`end_date` = '2038-01-18 00:00:00') OR (`Event`.`start_date` > '2026-03-10 00:00:00' AND `Event`.`start_date` <= '2026-03-10 23:59:59') OR (`Event`.`end_date` > '2026-03-10 00:00:00' AND `Event`.`end_date` <= '2026-03-10 23:59:59'))
GROUP BY `Event`.`id`
ORDER BY `Event`.`featured` DESC,`Event`.`start_date` ASC
3.26ms9KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11568)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
721μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Model/AbstractModelEvents.php:1108CopySELECT `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` = 11568
780μ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`
483μs3.92KBParams/libraries/src/Categories/Categories.php:375CopySELECT id,type
FROM testaoutjcalpro_forms
WHERE `default` = 1 AND published = 1
323μ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)
494μs7.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
627μs3.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
6.2ms1.97KB/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-08 22:00:00'
GROUP BY Xref.category_id
4.99ms624B/components/com_jcalpro/models/categories.php:195CopySELECT `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)
264μs1.32KBParams/libraries/src/Helper/TagsHelper.php:503CopySHOW FULL COLUMNS FROM `testaoutjcalpro_locations`
634μs1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539CopySELECT *
FROM `testaoutjcalpro_locations`
WHERE `id` = '5'
331μs2.5KB/libraries/src/Table/Table.php:780CopySELECT `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` = 5 AND `Event`.`start_date` < '2025-10-09 01:46:07' AND `Event`.`private` = 0
GROUP BY `Event`.`id`
ORDER BY `Event`.`featured` DESC,`Event`.`start_date` ASC LIMIT 20
3.94ms9.3KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (3306,3305,4969,6146,4976,6163,5103,6181,6236,6237,6148,6238,6239,6283,6290,6291,6292,6302,6297,6293)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
809μs960B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Model/AbstractModelEvents.php:1108CopySELECT `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` = 3306
748μ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`
453μ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)
231μ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
378μ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` = 3305
891μ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)
229μ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
381μ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` = 4969
749μ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)
244μ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
396μs6.56KBParams/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` = 6146
942μ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)
241μ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
383μ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` = 4976
780μ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)
262μ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
375μ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` = 6163
772μ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)
281μ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` = 5103
774μ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)
262μ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
411μ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` = 6181
884μ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)
268μ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` = 6236
840μ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)
311μ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
519μ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` = 6237
817μ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)
291μ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
437μ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` = 6148
835μ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)
302μ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
444μ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` = 6238
817μ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)
293μ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
460μ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` = 6239
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)
307μ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
449μ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` = 6283
908μ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)
323μs12.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
396μ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` = 6290
858μ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)
307μ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μ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` = 6291
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)
261μ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
475μ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` = 6292
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)
258μ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
400μ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` = 6302
771μ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)
270μ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
375μ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` = 6297
795μ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)
266μ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μ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` = 6293
773μ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)
263μ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`.*,'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` = 5 AND `Event`.`start_date` >= '2025-10-09 01:46:07' AND `Event`.`private` = 0
GROUP BY `Event`.`id`
ORDER BY `Event`.`featured` DESC,`Event`.`start_date` ASC LIMIT 20
3.26ms25.3KB/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` = 11511
783μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11511)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
729μ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)
231μ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` = 11558
800μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11558)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
721μ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)
268μ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
399μ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` = 11555
893μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11555)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
733μ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)
263μ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
388μ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` = 11563
810μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11563)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
715μ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)
262μ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
374μ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` = 11512
759μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11512)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
724μ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)
217μ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
355μ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` = 11485
776μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11485)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
702μ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)
229μ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
358μ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` = 11513
1.44ms656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11513)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
1.09ms656B/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)
247μ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
392μ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` = 11514
1.03ms656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11514)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
713μ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)
232μ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
377μ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` = 11564
762μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11564)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
696μ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)
226μ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
376μ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` = 11541
787μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11541)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
710μ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
375μ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` = 11580
776μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11580)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
670μ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)
222μ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
358μs12.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` = 11542
749μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11542)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
682μ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)
226μ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
463μ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` = 11543
750μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11543)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
690μ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)
231μ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
366μ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` = 11565
746μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11565)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
690μ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)
220μ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
348μ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` = 11544
788μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11544)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
719μ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)
228μ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
372μ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` = 11566
769μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11566)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
671μ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)
222μ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
367μ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` = 11581
746μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11581)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
668μ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)
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
374μ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` = 11567
785μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11567)
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)
230μ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
394μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `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)
237μ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
407μ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` = 11583
782μs656B/administrator/components/com_jcalpro/library/alledia/Jcalpro/Helper/UrlHelper.php:494CopySELECT Xref.*
FROM testaoutjcalpro_event_categories AS Xref
WHERE `Xref`.`event_id` IN (11583)
ORDER BY Xref.event_id ASC, Xref.canonical DESC, Xref.category_id ASC
739μ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)
234μ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
378μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT 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
564μs3.78KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `Event`.`id`,Xref.category_id AS catid
FROM testaoutjcalpro_events AS Event
LEFT JOIN testaoutjcalpro_event_categories AS `Xref` ON `Xref`.`event_id` = `Event`.`id` AND `Xref`.`canonical` = 1
WHERE `Event`.`approved` = 0 AND `Event`.`published` IN (1, 0)
GROUP BY `Event`.`id`
1.11ms768B/components/com_jcalpro/models/events.php:191CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `testaoutassets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0
2.33ms229.48KBParams/libraries/src/Access/Access.php:301CopySELECT `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)
350μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT 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
248μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517CopySELECT `session_id`
FROM `testaoutsession`
WHERE `session_id` = ?
289μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277CopyUPDATE `testaoutsession`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
976μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy