Wir nutzen Cookies auf unserer Website. Einige von ihnen sind essenziell für den Betrieb der Seite, während andere uns helfen, diese Website und die Nutzererfahrung zu verbessern (Tracking Cookies). Sie können selbst entscheiden, ob Sie die Cookies zulassen möchten. Bitte beachten Sie, dass bei einer Ablehnung womöglich nicht mehr alle Funktionalitäten der Seite zur Verfügung stehen.
Joomla! Version | 4.4.9 |
PHP Version | 8.2.6 |
Identity | guest |
Response | 200 |
Template | t4_bs5_blank |
Database |
|
1 x afterInitialise (7.53MB) (26.03%) | 69.77ms |
1 x Before Access::preloadComponents (all components) (4.15MB) (14.83%) | 39.75ms |
1 x afterLoad (3.93MB) (11.06%) | 29.64ms |
1 x Before Access::getAssetRules (id:16 name:com_menus) (1.13MB) (9.7%) | 26.01ms |
1 x afterRenderComponent com_jem (1.43MB) (7.16%) | 19.18ms |
1 x afterRoute (1.47MB) (6.49%) | 17.38ms |
1 x afterRender (398.95KB) (3.74%) | 10.03ms |
1 x afterRenderRawModule mod_articles_latest (Spielberichte) (291.23KB) (3.64%) | 9.77ms |
1 x afterRenderRawModule mod_menu (Mainnav) (555.26KB) (3.64%) | 9.76ms |
1 x afterRenderRawModule mod_jem (Termine) (222.22KB) (3.03%) | 8.12ms |
1 x afterRenderRawModule mod_menu (mainmenu) (35.41KB) (2.7%) | 7.23ms |
1 x afterRenderRawModule mod_articles_latest (Nachrichten) (44.98KB) (2.6%) | 6.97ms |
1 x afterRenderRawModule mod_menu (Login) (454.81KB) (2.28%) | 6.11ms |
1 x beforeRenderRawModule mod_menu (mainmenu) (74.41KB) (0.4%) | 1.07ms |
1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (40.86KB) (0.39%) | 1.05ms |
1 x After Access::preloadComponents (all components) (119.66KB) (0.31%) | 823μs |
1 x afterDispatch (32.05KB) (0.27%) | 714μs |
1 x afterRenderRawModule mod_custom (Facebook) (8.55KB) (0.22%) | 583μs |
1 x beforeRenderComponent com_jem (15.49KB) (0.18%) | 473μs |
1 x After Access::getAssetRules (id:1 name:root.1) (25.41KB) (0.12%) | 323μs |
1 x afterRenderModule mod_jem (Termine) (5.65KB) (0.1%) | 255μs |
1 x afterRenderModule mod_menu (Mainnav) (14.04KB) (0.09%) | 233μs |
1 x afterRenderModule mod_articles_latest (Spielberichte) (3.79KB) (0.08%) | 211μs |
1 x afterRenderModule mod_articles_latest (Nachrichten) (3.79KB) (0.08%) | 204μs |
1 x afterRenderModule mod_menu (Login) (3.52KB) (0.08%) | 202μs |
1 x afterRenderModule mod_custom (Facebook) (2.95KB) (0.07%) | 200μs |
1 x afterRenderModule mod_menu (mainmenu) (14.38KB) (0.06%) | 174μs |
1 x afterRenderModule mod_custom (Spielberichte - Link) (2.27KB) (0.06%) | 173μs |
1 x afterRenderModule mod_custom (Nachrichten - Link) (2.27KB) (0.06%) | 162μs |
1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.14KB) (0.05%) | 137μs |
1 x beforeRenderRawModule mod_menu (Mainnav) (2.02KB) (0.04%) | 103μs |
1 x afterRenderRawModule mod_custom (Spielberichte - Link) (2.19KB) (0.03%) | 84μs |
1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (1.04KB) (0.03%) | 82μs |
1 x afterRenderRawModule mod_custom (Nachrichten - Link) (960B) (0.03%) | 82μs |
1 x beforeRenderRawModule mod_articles_latest (Spielberichte) (688B) (0.03%) | 77μs |
1 x beforeRenderRawModule mod_jem (Termine) (1.46KB) (0.03%) | 75μs |
1 x beforeRenderRawModule mod_articles_latest (Nachrichten) (1.09KB) (0.03%) | 72μs |
1 x After Access::getAssetRules (id:16 name:com_menus) (7.73KB) (0.02%) | 49μs |
1 x beforeRenderRawModule mod_menu (Login) (5.26KB) (0.01%) | 35μs |
1 x beforeRenderRawModule mod_custom (Facebook) (2.85KB) (0.01%) | 27μs |
1 x beforeRenderRawModule mod_custom (Spielberichte - Link) (1.12KB) (0.01%) | 27μs |
1 x beforeRenderRawModule mod_custom (Nachrichten - Link) (1.12KB) (0.01%) | 26μs |
1 x Before Access::getAssetRules (id:1 name:root.1) (1.38KB) (0.01%) | 23μs |
1 x beforeRenderModule mod_articles_latest (Spielberichte) (704B) (0%) | 9μs |
1 x beforeRenderModule mod_menu (Mainnav) (704B) (0%) | 9μs |
1 x beforeRenderModule mod_menu (Login) (704B) (0%) | 8μs |
1 x beforeRenderModule mod_menu (mainmenu) (704B) (0%) | 8μs |
1 x beforeRenderModule mod_custom (Facebook) (720B) (0%) | 8μs |
1 x beforeRenderModule mod_articles_latest (Nachrichten) (704B) (0%) | 8μs |
1 x beforeRenderModule mod_jem (Termine) (704B) (0%) | 7μs |
1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%) | 7μs |
1 x beforeRenderModule mod_custom (Spielberichte - Link) (720B) (0%) | 5μs |
1 x beforeRenderModule mod_custom (Nachrichten - Link) (720B) (0%) | 4μs |
SELECT @@SESSION.sql_mode;
64μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `bc1re_session`
WHERE `session_id` = ?
158μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `bc1re_session`
WHERE `session_id` = :session_id LIMIT 1
86μs1.3KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `bc1re_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
213μs944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `bc1re_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
66μs17.73KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `bc1re_viewlevels`
44μs672B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `bc1re_usergroups` AS `a`
LEFT JOIN `bc1re_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
43μs1.33KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `bc1re_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`
73μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT *
FROM `bc1re_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
67μs2.23KB/libraries/src/Language/LanguageHelper.php:142CopySELECT *
FROM bc1re_menu
WHERE alias ='aktuelles' AND published=1
260μs2.84KB/plugins/system/t4/src/t4/MVC/Router/T4.php:352CopySELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component`
FROM `bc1re_menu` AS `m`
LEFT JOIN `bc1re_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id`
WHERE
(
(`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2)
ORDER BY `m`.`lft`
714μs36.05KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `bc1re_template_styles` AS `s`
LEFT JOIN `bc1re_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id`
WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1
60μs848B/administrator/components/com_templates/src/Model/StyleModel.php:773CopySELECT `keyname`,`value`
FROM bc1re_jem_config
64μs2.06KB/components/com_jem/classes/config.class.php:110CopySELECT DISTINCT c.id,c.catname,c.access,c.checked_out AS cchecked_out,c.color, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.groupid,a.id AS multi
FROM bc1re_jem_categories as c
LEFT JOIN bc1re_jem_cats_event_relations AS rel ON rel.catid = c.id
LEFT JOIN bc1re_jem_events AS a ON a.id = rel.itemid
WHERE c.published = 1 AND (c.access IN (1,5))
460μs2.14KB/components/com_jem/models/event.php:572CopySELECT a.id, a.id AS did, a.title, a.alias, a.dates, a.enddates, a.times, a.endtimes, a.access, a.attribs, a.metadata, a.custom1, a.custom2, a.custom3, a.custom4, a.custom5, a.custom6, a.custom7, a.custom8, a.custom9, a.custom10, a.created, a.created_by, a.published, a.registra, a.registra_from, a.registra_until, a.unregistra, a.unregistra_until, a.reginvitedonly, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.datimage, a.version, a.featured, a.seriesbooking, a.singlebooking, a.meta_keywords, a.meta_description, a.created_by_alias, a.introtext, a.fulltext, a.maxplaces, a.reservedplaces, a.minbookeduser, a.maxbookeduser, a.waitinglist, a.requestanswer, a.hits, a.language, a.recurrence_type, a.recurrence_first_id,u.name AS author,con.id AS conid, con.name AS conname, con.catid AS concatid, con.telephone AS contelephone, con.email_to AS conemail,l.custom1 AS venue1, l.custom2 AS venue2, l.custom3 AS venue3, l.custom4 AS venue4, l.custom5 AS venue5, l.custom6 AS venue6, l.custom7 AS venue7, l.custom8 AS venue8, l.custom9 AS venue9, l.custom10 AS venue10, l.id AS locid, l.alias AS localias, l.venue, l.city, l.state, l.url, l.locdescription, l.locimage, l.postalCode, l.street, l.country, l.map, l.created_by AS venueowner, l.latitude, l.longitude, l.checked_out AS vChecked_out, l.checked_out_time AS vChecked_out_time, l.published as locpublished,(
SELECT MAX(contact.id) AS id
FROM bc1re_contact_details AS contact
WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid2
FROM bc1re_jem_events AS a
LEFT JOIN bc1re_users AS u on u.id = a.created_by
LEFT JOIN bc1re_contact_details AS con ON con.id = a.contactid
LEFT JOIN bc1re_jem_venues AS l ON a.locid = l.id
LEFT JOIN bc1re_jem_cats_event_relations AS rel ON rel.itemid = a.id
LEFT JOIN bc1re_jem_categories AS c ON c.id = rel.catid
WHERE a.id = 49 AND c.id IN (1,2)
594μs10.44KB/components/com_jem/models/event.php:155CopySELECT DISTINCT c.id,c.catname,c.access,c.checked_out AS cchecked_out,c.color, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.groupid,a.id AS multi
FROM bc1re_jem_categories as c
LEFT JOIN bc1re_jem_cats_event_relations AS rel ON rel.catid = c.id
LEFT JOIN bc1re_jem_events AS a ON a.id = rel.itemid
WHERE rel.itemid =49 AND c.published = 1 AND (c.access IN (1,5))
184μs928B/components/com_jem/models/event.php:575CopySELECT SUM(places)
FROM bc1re_jem_register
WHERE event = '49' AND waiting = 0 AND status = 1
71μs1.77KB/components/com_jem/models/event.php:227CopySELECT IF (status > 0, waiting + 1, status) AS status, id, comment, places FROM bc1re_jem_register WHERE uid = '0' AND event = '49'
59μs688B/components/com_jem/models/event.php:616CopySELECT IF(r.status = 1 AND r.waiting = 1, 2, r.status) as status, r.uid, r.comment, r.places, u.name as name FROM bc1re_jem_register AS r LEFT JOIN bc1re_users AS u ON u.id = r.uid WHERE event = '49' AND waiting = 0 AND status = -1
78μs752B/components/com_jem/models/event.php:694CopySELECT IF(r.status = 1 AND r.waiting = 1, 2, r.status) as status, r.uid, r.comment, r.places, u.name as name FROM bc1re_jem_register AS r LEFT JOIN bc1re_users AS u ON u.id = r.uid WHERE event = '49' AND waiting = 0 AND status = 0
71μs752B/components/com_jem/models/event.php:694CopySELECT IF(r.status = 1 AND r.waiting = 1, 2, r.status) as status, r.uid, r.comment, r.places, u.name as name FROM bc1re_jem_register AS r LEFT JOIN bc1re_users AS u ON u.id = r.uid WHERE event = '49' AND waiting = 0 AND status = 1
73μs752B/components/com_jem/models/event.php:694CopySELECT IF(r.status = 1 AND r.waiting = 1, 2, r.status) as status, r.uid, r.comment, r.places, u.name as name FROM bc1re_jem_register AS r LEFT JOIN bc1re_users AS u ON u.id = r.uid WHERE event = '49' AND waiting = 1 AND status = 1
68μs752B/components/com_jem/models/event.php:694CopySELECT IF(r.status = 1 AND r.waiting = 1, 2, r.status) as status, r.uid, r.comment, r.places, u.name as name FROM bc1re_jem_register AS r LEFT JOIN bc1re_users AS u ON u.id = r.uid WHERE event = '49'
75μs752B/components/com_jem/models/event.php:694CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `bc1re_assets`
WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43)
137μs7.81KBParams/libraries/src/Access/Access.php:357CopySELECT 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 bc1re_fields AS a
LEFT JOIN `bc1re_languages` AS l ON l.lang_code = a.language
LEFT JOIN bc1re_users AS uc ON uc.id=a.checked_out
LEFT JOIN bc1re_viewlevels AS ag ON ag.id = a.access
LEFT JOIN bc1re_users AS ua ON ua.id = a.created_user_id
LEFT JOIN bc1re_fields_groups AS g ON g.id = a.group_id
WHERE
(
(`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND
(`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform
ORDER BY a.ordering ASC
578μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE bc1re_jem_events SET hits = hits + 1 WHERE id = 49
224μs48B/components/com_jem/models/event.php:431CopySELECT id, parent_id, catname, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug
FROM bc1re_jem_categories
WHERE id = 2 AND published = 1 AND access IN (1,5)
111μs656B/components/com_jem/classes/categories.class.php:463CopySELECT id, parent_id, catname, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug
FROM bc1re_jem_categories
WHERE id = 1 AND published = 1 AND access IN (1,5)
81μs704B/components/com_jem/classes/categories.class.php:463CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `bc1re_modules` AS `m`
LEFT JOIN `bc1re_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `bc1re_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id`
WHERE
(
(
(`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND
(`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0)
ORDER BY `m`.`position`,`m`.`ordering`
567μs1.97KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT DISTINCT c.id,c.catname,c.access,c.checked_out AS cchecked_out,c.color, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,a.id AS multi
FROM bc1re_jem_categories as c
LEFT JOIN bc1re_jem_cats_event_relations AS rel ON rel.catid = c.id
LEFT JOIN bc1re_jem_events AS a ON a.id = rel.itemid
WHERE c.published = 1 AND (c.access IN (1,5))
463μs2.11KB/components/com_jem/models/eventslist.php:780CopySELECT a.access,a.alias,a.attribs,a.checked_out,a.checked_out_time,a.contactid,a.created,a.created_by,a.created_by_alias,a.custom1,a.custom2,a.custom3,a.custom4,a.custom5,a.custom6,a.custom7,a.custom8,a.custom9,a.custom10,a.dates,a.datimage,a.enddates,a.endtimes,a.featured,a.fulltext,a.hits,a.id,a.introtext,a.language,a.locid,a.maxplaces,a.reservedplaces,a.minbookeduser,a.maxbookeduser,a.metadata,a.meta_keywords,a.meta_description,a.modified,a.modified_by,a.published,a.registra,a.times,a.title,a.unregistra,a.waitinglist,a.requestanswer,a.seriesbooking,a.singlebooking, DAYOFMONTH(a.dates) AS created_day, YEAR(a.dates) AS created_year, MONTH(a.dates) AS created_month,a.recurrence_byday,a.recurrence_counter,a.recurrence_first_id,a.recurrence_limit,a.recurrence_limit_date,a.recurrence_number, a.recurrence_type,a.version,u.name AS author,l.alias AS l_alias,l.checked_out AS l_checked_out,l.checked_out_time AS l_checked_out_time,l.city,l.country,l.created AS l_created,l.created_by AS l_createdby,l.custom1 AS l_custom1,l.custom2 AS l_custom2,l.custom3 AS l_custom3,l.custom4 AS l_custom4,l.custom5 AS l_custom5,l.custom6 AS l_custom6,l.custom7 AS l_custom7,l.custom8 AS l_custom8,l.custom9 AS l_custom9,l.custom10 AS l_custom10,l.id AS l_id,l.latitude,l.locdescription,l.locimage,l.longitude,l.map,l.meta_description AS l_meta_description,l.meta_keywords AS l_meta_keywords,l.modified AS l_modified,l.modified_by AS l_modified_by,l.postalCode,l.publish_up AS l_publish_up,l.publish_down AS l_publish_down,l.published AS l_published,l.state,l.street,l.url,l.venue,l.version AS l_version,ct.name AS countryname, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(l.alias) != 0 THEN CONCAT_WS(':', a.locid, l.alias) ELSE a.locid END as venueslug
FROM bc1re_jem_events as a
LEFT JOIN bc1re_users AS u on u.id = a.created_by
LEFT JOIN bc1re_jem_venues AS l ON l.id = a.locid
LEFT JOIN bc1re_jem_countries AS ct ON ct.iso2 = l.country
LEFT JOIN bc1re_jem_cats_event_relations AS rel ON rel.itemid = a.id
LEFT JOIN bc1re_jem_categories AS c ON c.id = rel.catid
WHERE a.access IN (1,5) AND ((`a`.published =1)) AND ((TIMESTAMPDIFF(MINUTE, NOW(), CONCAT(a.dates,' ',IFNULL(a.times,'00:00:00'))) > 0) ) AND a.dates IS NOT NULL AND c.id IN (1,2)
GROUP BY a.id
ORDER BY a.dates ASC,a.times ASC,a.created ASC LIMIT 3
1.88ms10.78KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT DISTINCT c.id,c.catname,c.access,c.checked_out AS cchecked_out,c.color, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,a.id AS multi
FROM bc1re_jem_categories as c
LEFT JOIN bc1re_jem_cats_event_relations AS rel ON rel.catid = c.id
LEFT JOIN bc1re_jem_events AS a ON a.id = rel.itemid
WHERE rel.itemid =61 AND c.published = 1 AND (c.access IN (1,5))
169μs896B/components/com_jem/models/eventslist.php:784CopySELECT DISTINCT c.id,c.catname,c.access,c.checked_out AS cchecked_out,c.color, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,a.id AS multi
FROM bc1re_jem_categories as c
LEFT JOIN bc1re_jem_cats_event_relations AS rel ON rel.catid = c.id
LEFT JOIN bc1re_jem_events AS a ON a.id = rel.itemid
WHERE rel.itemid =62 AND c.published = 1 AND (c.access IN (1,5))
162μs3.38KB/components/com_jem/models/eventslist.php:784CopySELECT DISTINCT c.id,c.catname,c.access,c.checked_out AS cchecked_out,c.color, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,a.id AS multi
FROM bc1re_jem_categories as c
LEFT JOIN bc1re_jem_cats_event_relations AS rel ON rel.catid = c.id
LEFT JOIN bc1re_jem_events AS a ON a.id = rel.itemid
WHERE rel.itemid =63 AND c.published = 1 AND (c.access IN (1,5))
151μs896B/components/com_jem/models/eventslist.php:784CopySELECT COUNT(id) as total, SUM(IF(status = 1 AND waiting = 0, places, 0)) AS registered, SUM(IF(status = 1 AND waiting > 0, places, 0)) AS waiting, SUM(IF(status = -1, places, 0)) AS unregistered, SUM(IF(status = 0, places, 0)) AS invited, event FROM bc1re_jem_register WHERE event IN (61,62,63) GROUP BY event
35μs816B/components/com_jem/helpers/helper.php:944CopySELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count`
FROM `bc1re_content` AS `a`
LEFT JOIN `bc1re_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `bc1re_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `bc1re_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `bc1re_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `bc1re_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `bc1re_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)
ORDER BY a.created DESC LIMIT 5
4.11ms23.17KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug`
FROM `bc1re_categories` AS `s`
INNER JOIN `bc1re_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
120μs3.92KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `bc1re_categories` AS `s`
INNER JOIN `bc1re_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
93μs3.92KBParams/libraries/src/Categories/Categories.php:375CopySELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count`
FROM `bc1re_content` AS `a`
LEFT JOIN `bc1re_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `bc1re_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `bc1re_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `bc1re_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `bc1re_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `bc1re_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)
ORDER BY a.publish_up DESC LIMIT 5
5.21ms22.42KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug`
FROM `bc1re_categories` AS `s`
INNER JOIN `bc1re_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
97μs3.92KBParams/libraries/src/Categories/Categories.php:375CopySELECT 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 `bc1re_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
136μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466CopySELECT `session_id`
FROM `bc1re_session`
WHERE `session_id` = ?
127μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyUPDATE `bc1re_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
161μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy