Member Benefits Include
Scholarship Opportunities
Joomla! Version | 5.2.2 |
PHP Version | 8.2.27 |
Identity | guest |
Response | 200 |
Template | ja_events_ii |
Database |
|
1 x afterRenderComponent com_jevents (523.5KB) (26.64%) | 20.77ms |
1 x afterInitialise (1.68MB) (23.41%) | 18.26ms |
1 x afterRoute (950.36KB) (10.59%) | 8.26ms |
1 x Before Access::preloadComponents (all components) (1.41MB) (10.42%) | 8.13ms |
1 x afterRenderRawModule mod_jevents_latest (Upcoming Events) (58.99KB) (7.41%) | 5.78ms |
1 x afterRender (198.8KB) (4.64%) | 3.62ms |
1 x afterRenderRawModule mod_jalogin ( Join ) (90.98KB) (3.74%) | 2.91ms |
1 x afterLoad (76.55KB) (2.85%) | 2.22ms |
1 x beforeRenderModule mod_custom (Footer Remedysoft) (54.66KB) (1.48%) | 1.15ms |
1 x afterRenderRawModule mod_menu (Links) (91.65KB) (1.43%) | 1.12ms |
1 x beforeRenderComponent com_jevents (65.03KB) (1.31%) | 1.02ms |
1 x afterRenderRawModule mod_menu (Event Types) (38.52KB) (1.28%) | 1.00ms |
1 x After Access::preloadComponents (all components) (166.03KB) (1.15%) | 893μs |
1 x afterDispatch (78.67KB) (0.67%) | 520μs |
1 x afterRenderRawModule mod_custom (Footer Remedysoft) (4.26KB) (0.63%) | 491μs |
1 x afterRenderModule mod_custom (Footer Remedysoft) (3.34KB) (0.24%) | 186μs |
1 x afterRenderModule mod_menu (Event Types) (2.08KB) (0.14%) | 109μs |
1 x afterRenderModule mod_jevents_latest (Upcoming Events) (3.17KB) (0.12%) | 95μs |
1 x After Access::getAssetRules (id:198 name:com_jevents) (6.89KB) (0.12%) | 91μs |
1 x afterRenderModule mod_menu (Links) (2.13KB) (0.11%) | 89μs |
1 x afterRenderModule mod_jalogin ( Join ) (1.63KB) (0.1%) | 81μs |
1 x afterRenderModule mod_custom (Contact Us) (2.42KB) (0.1%) | 76μs |
1 x afterRenderRawModule mod_custom (Scholarships) (1.02KB) (0.1%) | 76μs |
1 x afterRenderModule mod_custom (Scholarships) (1.89KB) (0.09%) | 71μs |
1 x beforeRenderModule mod_jevents_latest (Upcoming Events) (7.55KB) (0.09%) | 70μs |
1 x beforeRenderModule mod_custom (Contact Us) (552B) (0.09%) | 68μs |
1 x afterRenderModule mod_custom (Join Today) (1.8KB) (0.09%) | 67μs |
1 x afterRenderRawModule mod_custom (Contact Us) (912B) (0.08%) | 63μs |
1 x beforeRenderModule mod_jalogin ( Join ) (3.98KB) (0.08%) | 60μs |
1 x afterRenderRawModule mod_custom (Join Today) (1008B) (0.08%) | 59μs |
1 x beforeRenderModule mod_menu (Links) (280B) (0.07%) | 51μs |
1 x beforeRenderModule mod_custom (Join Today) (568B) (0.05%) | 38μs |
1 x beforeRenderModule mod_menu (Event Types) (2.1KB) (0.05%) | 38μs |
1 x beforeRenderModule mod_custom (Scholarships) (9.33KB) (0.03%) | 23μs |
1 x Before Access::getAssetRules (id:198 name:com_jevents) (56B) (0.02%) | 18μs |
1 x beforeRenderModule mod_jalogin ( Join ) (720B) (0.02%) | 16μs |
1 x beforeRenderModule mod_custom (Footer Remedysoft) (720B) (0.01%) | 6μs |
1 x beforeRenderModule mod_menu (Links) (704B) (0.01%) | 6μs |
1 x beforeRenderModule mod_jevents_latest (Upcoming Events) (720B) (0.01%) | 6μs |
1 x beforeRenderModule mod_menu (Event Types) (720B) (0.01%) | 5μs |
1 x beforeRenderModule mod_custom (Join Today) (720B) (0.01%) | 4μs |
1 x beforeRenderModule mod_custom (Contact Us) (720B) (0%) | 3μs |
1 x beforeRenderModule mod_custom (Scholarships) (720B) (0%) | 3μs |
SELECT @@SESSION.sql_mode;
53μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308CopySELECT `data`
FROM `mzmip_session`
WHERE `session_id` = ?
99μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250CopySELECT `session_id`
FROM `mzmip_session`
WHERE `session_id` = :session_id LIMIT 1
159μs1.3KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `mzmip_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
572μs944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `mzmip_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
292μs17.86KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `mzmip_viewlevels`
71μs656B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `mzmip_usergroups` AS `a`
LEFT JOIN `mzmip_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
145μs1.33KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `mzmip_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`
947μs4.48KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT `path`
FROM mzmip_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'
129μs1.63KB/administrator/components/com_rsfirewall/helpers/config.php:56CopySELECT `file`
FROM mzmip_rsfirewall_hashes
WHERE `type`='protect'
306μs520B/administrator/components/com_rsfirewall/helpers/config.php:63CopySELECT *
FROM mzmip_rsfirewall_configuration
145μs1.88KB/administrator/components/com_rsfirewall/helpers/config.php:71CopySHOW FULL COLUMNS FROM `mzmip_rsfirewall_logs`
934μs1.42KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT *
FROM mzmip_rsform_config
129μs1.31KB/administrator/components/com_rsform/helpers/config.php:52CopySELECT *
FROM mzmip_rsmembership_configuration
110μs1.56KB/administrator/components/com_rsmembership/helpers/config.php:58CopySELECT `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 `mzmip_menu` AS `m`
LEFT JOIN `mzmip_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`
589μs36.17KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT *
FROM mzmip_rsfirewall_hashes
WHERE (`type`='5.2.2' OR `type`='protect') AND (`flag`!='C' OR `flag` IS NULL)
331μs848B/plugins/system/rsfirewall/rsfirewall.php:1078CopySELECT *
FROM mzmip_rsfirewall_snapshots
WHERE `type`='protect'
45μs1.92KB/administrator/components/com_rsfirewall/helpers/snapshot.php:49CopySELECT `ip`,`reason`
FROM mzmip_rsfirewall_lists
WHERE (`ip`='66.248.200.15' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='1' AND `published`='1'
51μs576B/plugins/system/rsfirewall/rsfirewall.php:172CopySELECT `ip`,`reason`
FROM mzmip_rsfirewall_lists
WHERE (`ip`='66.248.200.15' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='0' AND `published`='1'
44μs576B/plugins/system/rsfirewall/rsfirewall.php:172CopySELECT *
FROM mzmip_rsfirewall_exceptions
WHERE `published`='1'
51μs1.42KB/plugins/system/rsfirewall/rsfirewall.php:729CopySELECT `s`.`membership_id`,`s`.`params`,`s`.`type`
FROM `mzmip_rsmembership_membership_shared` AS `s`
LEFT JOIN `mzmip_rsmembership_memberships` AS `m` ON `s`.`membership_id` = `m`.`id`
WHERE `s`.`published` = '1' AND `m`.`published` = '1' AND `s`.`type` = 'menu' AND `s`.`params` LIKE '271'
57μs640B/administrator/components/com_rsmembership/helpers/helper.php:343CopySELECT `s`.`extra_value_id`,`s`.`params`,`s`.`type`
FROM `mzmip_rsmembership_extra_value_shared` AS `s`
LEFT JOIN `mzmip_rsmembership_extra_values` AS `v` ON `s`.`extra_value_id` = `v`.`id`
WHERE `s`.`published` = '1' AND `v`.`published` = '1' AND `s`.`type` = 'menu' AND `s`.`params` LIKE '271'
51μs640B/administrator/components/com_rsmembership/helpers/helper.php:367CopySELECT `s`.`membership_id`,`s`.`params`,`s`.`type`
FROM `mzmip_rsmembership_membership_shared` AS `s`
LEFT JOIN `mzmip_rsmembership_memberships` AS `m` ON `s`.`membership_id` = `m`.`id`
WHERE `s`.`published` = '1' AND `m`.`published` = '1' AND `s`.`type` = 'frontendurl' AND `s`.`params` LIKE 'com_jevents%'
51μs640B/administrator/components/com_rsmembership/helpers/helper.php:343CopySELECT `s`.`extra_value_id`,`s`.`params`,`s`.`type`
FROM `mzmip_rsmembership_extra_value_shared` AS `s`
LEFT JOIN `mzmip_rsmembership_extra_values` AS `v` ON `s`.`extra_value_id` = `v`.`id`
WHERE `s`.`published` = '1' AND `v`.`published` = '1' AND `s`.`type` = 'frontendurl' AND `s`.`params` LIKE 'com_jevents%'
47μs640B/administrator/components/com_rsmembership/helpers/helper.php:367CopySELECT `membership_id`,`params`
FROM `mzmip_rsmembership_membership_shared`
WHERE `type` = 'menu' AND `published` = '1'
41μs576B/plugins/system/rsmembership/rsmembership.php:281CopySELECT `extra_value_id`,`params`
FROM `mzmip_rsmembership_extra_value_shared`
WHERE `type` = 'menu' AND `published` = '1'
43μs576B/plugins/system/rsmembership/rsmembership.php:291CopySELECT *
FROM `mzmip_rsmembership_payments`
WHERE `published` = '1'
ORDER BY `ordering` ASC
69μs896B/plugins/system/rsmembershipwire/rsmembershipwire.php:45CopySHOW FULL COLUMNS FROM `mzmip_rsmembership_payments`
479μs1.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT *
FROM `mzmip_rsmembership_payments`
WHERE `id` = '2'
75μs896B/libraries/src/Table/Table.php:780CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `mzmip_template_styles` AS `s`
LEFT JOIN `mzmip_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
198μs16.92KB/administrator/components/com_templates/src/Model/StyleModel.php:775CopySELECT *
FROM `mzmip_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
109μs1.59KB/libraries/src/Language/LanguageHelper.php:177CopySELECT 'a word a' REGEXP '[[:<:]]word[[:>:]]'
4.82ms965.49KB/plugins/jevents/jevcustomfields/jevcustomfields.php:57CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `mzmip_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,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47,:preparedArray48,:preparedArray49,:preparedArray50,:preparedArray51,:preparedArray52)
1.85ms164.36KBParams/libraries/src/Access/Access.php:357CopySHOW FULL COLUMNS FROM `mzmip_content`
2.11ms124.64KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT 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 mzmip_fields AS a
LEFT JOIN `mzmip_languages` AS l ON l.lang_code = a.language
LEFT JOIN mzmip_users AS uc ON uc.id=a.checked_out
LEFT JOIN mzmip_viewlevels AS ag ON ag.id = a.access
LEFT JOIN mzmip_users AS ua ON ua.id = a.created_user_id
LEFT JOIN mzmip_fields_groups AS g ON g.id = a.group_id
WHERE
(
(`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND
(`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform
ORDER BY a.ordering ASC
1.14ms97.76KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `mzmip_modules` AS `m`
LEFT JOIN `mzmip_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `mzmip_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`
198μs11.02KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT `membership_id`,`params`
FROM `mzmip_rsmembership_membership_shared`
WHERE `type` = 'module' AND `published` = '1'
76μs13.66KB/plugins/system/rsmembership/rsmembership.php:80CopySELECT `extra_value_id`,`params`
FROM `mzmip_rsmembership_extra_value_shared`
WHERE `type` = 'module' AND `published` = '1'
4.64ms48.42KB/plugins/system/rsmembership/rsmembership.php:94CopySHOW FULL COLUMNS FROM `mzmip_jev_users`
671μs58.34KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT `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 `mzmip_categories` AS `c`
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1
ORDER BY `c`.`lft`
266μs20.96KBParams/libraries/src/Categories/Categories.php:375CopySELECT c.id
FROM mzmip_categories AS c
WHERE c.access IN (1,5)
AND c.published = 1
AND c.language in ('en-GB','*')
AND c.extension = 'com_jevents'
AND ((c.lft>=71 AND c.rgt<=72 ))
ORDER BY c.lft asc
3.78ms82.76KB/components/com_jevents/libraries/dbmodel.php:558CopySELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* , ev.rawdata as evrawdata, ev.state as published, ev.created as created , jfc.imagename1 AS imageurl1, jfc.imagetitle1 AS imagetitle1, jfc.imagecomment1 AS imagecomment1 , CASE WHEN (jfc.filename1='') THEN '' ELSE CONCAT('/images/jevents/',jfc.filename1) END as filehref1
, jfc.filetitle1 as filetitle1
, CASE WHEN (jfc.filename1='') THEN '' ELSE CONCAT('<a href="/images/jevents/',jfc.filename1,'" />',jfc.filetitle1,'</a>') END as filelink1, loc.loc_id,loc.title as loc_title, loc.title as location, loc.street as loc_street, loc.description as loc_desc, loc.postcode as loc_postcode, loc.city as loc_city, loc.country as loc_country, loc.state as loc_state, loc.phone as loc_phone , loc.image as loc_image , loc.url as loc_url , loc.geolon as loc_lon , loc.geolat as loc_lat , loc.geozoom as loc_zoom , loc.mapicon as loc_mapicon , GROUP_CONCAT(DISTINCT loccat.title SEPARATOR ',') AS location_category_list,GROUP_CONCAT(loccatmap.catid SEPARATOR ',') AS location_catid_list,
atd.regopen, atd.regclose, atd.allrepeats, atd.allowregistration, GROUP_CONCAT(DISTINCT catmapcat.id ORDER BY catmapcat.lft ASC SEPARATOR ',' ) as catids
, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
, YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn
, HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
, HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM mzmip_jevents_repetition as rpt
INNER JOIN mzmip_jevents_vevent as ev ON rpt.eventid = ev.ev_id
INNER JOIN mzmip_jevents_icsfile as icsf ON icsf.ics_id=ev.icsid
INNER JOIN mzmip_jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN mzmip_jevents_rrule as rr ON rr.eventid = rpt.eventid
LEFT JOIN mzmip_jev_files_combined as jfc ON jfc.ev_id = ev.ev_id
LEFT JOIN mzmip_jev_locations as loc ON loc.loc_id=det.loc_id
LEFT JOIN mzmip_jevlocations_catmap AS loccatmap ON loccatmap.locid = loc.loc_id
LEFT JOIN mzmip_categories AS loccat ON loccat.id = loccatmap.catid
LEFT JOIN mzmip_jev_attendance as atd ON ev.ev_id=atd.ev_id LEFT JOIN mzmip_jev_invitees as inv ON inv.at_id=atd.id
LEFT JOIN
mzmip_jevents_catmap as catmap ON catmap.evid = rpt.eventid
LEFT JOIN
mzmip_categories AS catmapcat ON catmap.catid = catmapcat.id
WHERE 1
AND rpt.endrepeat >= '2023-12-20 00:00:00' AND rpt.startrepeat <= '2023-12-20 23:59:59'
AND NOT (rpt.startrepeat < '2023-12-20 00:00:00' AND det.multiday=0) AND ev.state=1 AND (atd.hidenoninvitees IS NULL
OR ev.created_by=0
OR atd.hidenoninvitees=0
OR atd.invites=0
OR (atd.invites=1 AND atd.hidenoninvitees=1 AND inv.email_address='FALSE' AND ((atd.allinvites=1 AND inv.rp_id=0) OR (atd.allinvites=0 AND inv.rp_id=rpt.rp_id)))) AND catmap.catid IN(-1,37)
AND ev.access IN (1,5) AND icsf.state=1 AND icsf.access IN (1,5)
GROUP BY rpt.rp_id
9.79ms318.95KB/components/com_jevents/libraries/dbmodel.php:3300CopySELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , jfc.imagename1 AS imageurl1, jfc.imagetitle1 AS imagetitle1, jfc.imagecomment1 AS imagecomment1 , CASE WHEN (jfc.filename1='') THEN '' ELSE CONCAT('/images/jevents/',jfc.filename1) END as filehref1
, jfc.filetitle1 as filetitle1
, CASE WHEN (jfc.filename1='') THEN '' ELSE CONCAT('<a href="/images/jevents/',jfc.filename1,'" />',jfc.filetitle1,'</a>') END as filelink1, loc.loc_id,loc.title as loc_title, loc.title as location, loc.street as loc_street, loc.description as loc_desc, loc.postcode as loc_postcode, loc.city as loc_city, loc.country as loc_country, loc.state as loc_state, loc.phone as loc_phone , loc.image as loc_image , loc.url as loc_url , loc.geolon as loc_lon , loc.geolat as loc_lat , loc.geozoom as loc_zoom , loc.mapicon as loc_mapicon , GROUP_CONCAT(DISTINCT loccat.title SEPARATOR ',') AS location_category_list,GROUP_CONCAT(loccatmap.catid SEPARATOR ',') AS location_catid_list,
atd.regopen, atd.regclose, atd.allrepeats, atd.allowregistration, GROUP_CONCAT(DISTINCT catmapcat.id ORDER BY catmapcat.lft ASC SEPARATOR ',' ) as catids
, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
, YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn
, HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
, HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM mzmip_jevents_repetition as rpt
INNER JOIN mzmip_jevents_vevent as ev ON rpt.eventid = ev.ev_id
INNER JOIN mzmip_jevents_icsfile as icsf ON icsf.ics_id=ev.icsid
INNER JOIN mzmip_jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN mzmip_jevents_rrule as rr ON rr.eventid = rpt.eventid
LEFT JOIN mzmip_jev_files_combined as jfc ON jfc.ev_id = ev.ev_id
LEFT JOIN mzmip_jev_locations as loc ON loc.loc_id=det.loc_id
LEFT JOIN mzmip_jevlocations_catmap AS loccatmap ON loccatmap.locid = loc.loc_id
LEFT JOIN mzmip_categories AS loccat ON loccat.id = loccatmap.catid
LEFT JOIN mzmip_jev_attendance as atd ON ev.ev_id=atd.ev_id LEFT JOIN mzmip_jev_invitees as inv ON inv.at_id=atd.id
LEFT JOIN
mzmip_jevents_catmap as catmap ON catmap.evid = rpt.eventid
LEFT JOIN
mzmip_categories AS catmapcat ON catmap.catid = catmapcat.id
WHERE 1
AND rpt.endrepeat >= '2025-01-09 10:34:15' AND rpt.startrepeat <= '2025-11-05 23:59:59'
AND (rpt.startrepeat >= '2025-01-09 00:00:00' OR det.multiday=1) AND ev.state=1 AND (atd.hidenoninvitees IS NULL
OR ev.created_by=0
OR atd.hidenoninvitees=0
OR atd.invites=0
OR (atd.invites=1 AND atd.hidenoninvitees=1 AND inv.email_address='FALSE' AND ((atd.allinvites=1 AND inv.rp_id=0) OR (atd.allinvites=0 AND inv.rp_id=rpt.rp_id)))) AND catmap.catid IN(-1,37)
AND ev.access IN (1,5) AND icsf.state=1
AND icsf.access IN (1,5)
GROUP BY rpt.startrepeat , rpt.rp_id
ORDER BY rpt.startrepeat ASC LIMIT 10
463μs1.45KB/components/com_jevents/libraries/dbmodel.php:3300CopySELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , jfc.imagename1 AS imageurl1, jfc.imagetitle1 AS imagetitle1, jfc.imagecomment1 AS imagecomment1 , CASE WHEN (jfc.filename1='') THEN '' ELSE CONCAT('/images/jevents/',jfc.filename1) END as filehref1
, jfc.filetitle1 as filetitle1
, CASE WHEN (jfc.filename1='') THEN '' ELSE CONCAT('<a href="/images/jevents/',jfc.filename1,'" />',jfc.filetitle1,'</a>') END as filelink1, loc.loc_id,loc.title as loc_title, loc.title as location, loc.street as loc_street, loc.description as loc_desc, loc.postcode as loc_postcode, loc.city as loc_city, loc.country as loc_country, loc.state as loc_state, loc.phone as loc_phone , loc.image as loc_image , loc.url as loc_url , loc.geolon as loc_lon , loc.geolat as loc_lat , loc.geozoom as loc_zoom , loc.mapicon as loc_mapicon , GROUP_CONCAT(DISTINCT loccat.title SEPARATOR ',') AS location_category_list,GROUP_CONCAT(loccatmap.catid SEPARATOR ',') AS location_catid_list,
atd.regopen, atd.regclose, atd.allrepeats, atd.allowregistration, GROUP_CONCAT(DISTINCT catmapcat.id ORDER BY catmapcat.lft ASC SEPARATOR ',' ) as catids
, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
, YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn
, HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
, HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM mzmip_jevents_repetition as rpt
INNER JOIN mzmip_jevents_vevent as ev ON rpt.eventid = ev.ev_id
INNER JOIN mzmip_jevents_icsfile as icsf ON icsf.ics_id=ev.icsid
INNER JOIN mzmip_jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN mzmip_jevents_rrule as rr ON rr.eventid = rpt.eventid
LEFT JOIN mzmip_jev_files_combined as jfc ON jfc.ev_id = ev.ev_id
LEFT JOIN mzmip_jev_locations as loc ON loc.loc_id=det.loc_id
LEFT JOIN mzmip_jevlocations_catmap AS loccatmap ON loccatmap.locid = loc.loc_id
LEFT JOIN mzmip_categories AS loccat ON loccat.id = loccatmap.catid
LEFT JOIN mzmip_jev_attendance as atd ON ev.ev_id=atd.ev_id LEFT JOIN mzmip_jev_invitees as inv ON inv.at_id=atd.id
LEFT JOIN
mzmip_jevents_catmap as catmap ON catmap.evid = rpt.eventid
LEFT JOIN
mzmip_categories AS catmapcat ON catmap.catid = catmapcat.id
WHERE 1
AND rpt.endrepeat >= '2025-01-09 00:00:00' AND rpt.startrepeat <= '2025-01-09 10:34:15'
AND (rpt.startrepeat >= '2025-01-09 00:00:00' OR det.multiday=1) AND ev.state=1 AND (atd.hidenoninvitees IS NULL
OR ev.created_by=0
OR atd.hidenoninvitees=0
OR atd.invites=0
OR (atd.invites=1 AND atd.hidenoninvitees=1 AND inv.email_address='FALSE' AND ((atd.allinvites=1 AND inv.rp_id=0) OR (atd.allinvites=0 AND inv.rp_id=rpt.rp_id)))) AND catmap.catid IN(-1,37)
AND ev.access IN (1,5) AND icsf.state=1
AND icsf.access IN (1,5)
GROUP BY rpt.startrepeat , rpt.rp_id
ORDER BY rpt.startrepeat desc LIMIT 10
441μs1.45KB/components/com_jevents/libraries/dbmodel.php:3300CopySELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , jfc.imagename1 AS imageurl1, jfc.imagetitle1 AS imagetitle1, jfc.imagecomment1 AS imagecomment1 , CASE WHEN (jfc.filename1='') THEN '' ELSE CONCAT('/images/jevents/',jfc.filename1) END as filehref1
, jfc.filetitle1 as filetitle1
, CASE WHEN (jfc.filename1='') THEN '' ELSE CONCAT('<a href="/images/jevents/',jfc.filename1,'" />',jfc.filetitle1,'</a>') END as filelink1, loc.loc_id,loc.title as loc_title, loc.title as location, loc.street as loc_street, loc.description as loc_desc, loc.postcode as loc_postcode, loc.city as loc_city, loc.country as loc_country, loc.state as loc_state, loc.phone as loc_phone , loc.image as loc_image , loc.url as loc_url , loc.geolon as loc_lon , loc.geolat as loc_lat , loc.geozoom as loc_zoom , loc.mapicon as loc_mapicon , GROUP_CONCAT(DISTINCT loccat.title SEPARATOR ',') AS location_category_list,GROUP_CONCAT(loccatmap.catid SEPARATOR ',') AS location_catid_list,
atd.regopen, atd.regclose, atd.allrepeats, atd.allowregistration, GROUP_CONCAT(DISTINCT catmapcat.id ORDER BY catmapcat.lft ASC SEPARATOR ',' ) as catids
, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
, YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn
, HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
, HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM mzmip_jevents_repetition as rpt
INNER JOIN mzmip_jevents_vevent as ev ON rpt.eventid = ev.ev_id
INNER JOIN mzmip_jevents_icsfile as icsf ON icsf.ics_id=ev.icsid
INNER JOIN mzmip_jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN mzmip_jevents_rrule as rr ON rr.eventid = rpt.eventid
LEFT JOIN mzmip_jev_files_combined as jfc ON jfc.ev_id = ev.ev_id
LEFT JOIN mzmip_jev_locations as loc ON loc.loc_id=det.loc_id
LEFT JOIN mzmip_jevlocations_catmap AS loccatmap ON loccatmap.locid = loc.loc_id
LEFT JOIN mzmip_categories AS loccat ON loccat.id = loccatmap.catid
LEFT JOIN mzmip_jev_attendance as atd ON ev.ev_id=atd.ev_id LEFT JOIN mzmip_jev_invitees as inv ON inv.at_id=atd.id
LEFT JOIN
mzmip_jevents_catmap as catmap ON catmap.evid = rpt.eventid
LEFT JOIN
mzmip_categories AS catmapcat ON catmap.catid = catmapcat.id
WHERE 1
AND rpt.endrepeat >= '2025-01-09 00:00:00' AND rpt.startrepeat <= '2025-01-09 10:34:15'
AND (rpt.startrepeat <= '2025-01-09 00:00:00' OR det.multiday=1) AND ev.state=1 AND (atd.hidenoninvitees IS NULL
OR ev.created_by=0
OR atd.hidenoninvitees=0
OR atd.invites=0
OR (atd.invites=1 AND atd.hidenoninvitees=1 AND inv.email_address='FALSE' AND ((atd.allinvites=1 AND inv.rp_id=0) OR (atd.allinvites=0 AND inv.rp_id=rpt.rp_id)))) AND catmap.catid IN(-1,37)
AND ev.access IN (1,5) AND icsf.state=1
AND icsf.access IN (1,5)
GROUP BY rpt.startrepeat , rpt.rp_id
ORDER BY rpt.startrepeat asc LIMIT 10
2.73ms-9.58KB/components/com_jevents/libraries/dbmodel.php:3300CopySELECT COALESCE(`c`.`name`, '') AS `category_name`, m.* FROM `mzmip_rsmembership_memberships` AS `m` LEFT JOIN `mzmip_rsmembership_categories` AS `c` ON `c`.`id` = `m`.`category_id` WHERE `m`.`published` = '1' ORDER BY `ordering` ASC
2.57ms63.81KB/templates/ja_events_ii/html/mod_jalogin/default.php:130CopySELECT 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 `mzmip_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
2.9ms179.56KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465CopySELECT `session_id`
FROM `mzmip_session`
WHERE `session_id` = ?
88μs-8.14KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277CopyUPDATE `mzmip_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
0μs0BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy