SELECTDISTINCT 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 tifas_fields AS a
LEFTJOIN`tifas_languages`AS l ON l.lang_code = a.languageLEFTJOIN tifas_users AS uc ON uc.id=a.checked_out
LEFTJOIN tifas_viewlevels AS ag ON ag.id = a.access
LEFTJOIN tifas_users AS ua ON ua.id = a.created_user_id
LEFTJOIN tifas_fields_groups AS g ON g.id = a.group_id
WHERE
(
(`a`.`context` = :context AND`a`.`access`IN (:preparedArray1)) AND
(`a`.`group_id` = 0OR`g`.`access`IN (:preparedArray2)) AND`a`.`state` = :state) AND
(`a`.`group_id` = 0OR`g`.`state` = :gstate) AND`a`.`only_use_in_subform` = :only_use_in_subform
ORDERBY a.ordering ASC668μs5.28KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
SELECT f.* FROM tifas_comprofiler_fields f
INNERJOIN tifas_comprofiler_tabs AS t ON (f.tabid = t.tabid)
WHERE f.published = 1ORDERBY t.position, t.ordering, f.ordering639μs4.86KBCopy
SELECT c.id
FROM tifas_categories AS c
WHERE c.access IN (1)
AND c.published = 1AND c.languagein ('en-GB','*')
AND c.extension = 'com_jevents'ORDERBY c.lft asc158μs904B/components/com_jevents/libraries/dbmodel.php:547Copy
SELECT c.id
FROM tifas_categories AS c
WHERE c.access IN (1)
AND c.published = 1AND c.languagein ('en-GB','*')
AND c.extension = 'com_jevents'AND ((c.lft>=87AND c.rgt<=88 ))
ORDERBY c.lft asc167μs856B/components/com_jevents/libraries/dbmodel.php:547Copy
SELECT ev.ev_id FROM tifas_jevents_repetition as rpt
INNERJOIN tifas_jevents_vevent as ev ON rpt.eventid = ev.ev_id
INNERJOIN tifas_jevents_icsfile as icsf ON icsf.ics_id=ev.icsid
INNERJOIN tifas_jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id
LEFTJOIN tifas_jevents_rrule as rr ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,68)
AND ev.created >= '2024-07-13 00:00:00'AND ev.created <= '2025-07-08 23:59:59'AND ev.state=1AND ev.access IN (1)
AND icsf.state=1AND icsf.access IN (1)
GROUPBY ev.ev_id ORDERBY ev.created DESC LIMIT 10832μs840B/components/com_jevents/libraries/dbmodel.php:271Copy
SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created
, 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 tifas_jevents_repetition as rpt
INNERJOIN tifas_jevents_vevent as ev ON rpt.eventid = ev.ev_id
INNERJOIN tifas_jevents_icsfile as icsf ON icsf.ics_id=ev.icsid
INNERJOIN tifas_jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id
LEFTJOIN tifas_jevents_rrule as rr ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,68)
AND ev.created >= '2024-07-13 00:00:00'AND ev.created <= '2025-07-08 23:59:59'AND ev.state=1AND ev.access IN (1) AND icsf.state=1AND icsf.access IN (1) AND ev.ev_id IN (0) ORDERBY ev.created DESC , rpt.startrepeat ASC481μs21.33KB/components/com_jevents/libraries/dbmodel.php:3274Copy