Joomla! Version | 4.4.3 |
PHP Version | 8.3.6 |
Identity | guest |
Response | 200 |
Template | g5_vermilion |
Database |
|
1 x afterRenderComponent com_content (1.1MB) (23.41%) | 102.32ms |
1 x afterRoute (2.4MB) (16.65%) | 72.78ms |
1 x afterRender (500.86KB) (16.17%) | 70.68ms |
1 x afterInitialise (3.29MB) (11.46%) | 50.09ms |
1 x Before Access::getAssetRules (id:1 name:root.1) (513.64KB) (9.29%) | 40.60ms |
1 x beforeRenderRawModule mod_rseventspro_events (events - this month) (2.89MB) (9.27%) | 40.49ms |
1 x afterDispatch (397.05KB) (4.52%) | 19.74ms |
1 x After Access::preloadPermissions (com_content) (1.45MB) (1.97%) | 8.60ms |
1 x afterRenderRawModule mod_articles_category (Events News) (91.7KB) (1.48%) | 6.47ms |
1 x Before Access::getAssetRules (id:8 name:com_content) (71.09KB) (1.36%) | 5.96ms |
1 x afterRenderRawModule mod_rseventspro_events (events - this month) (167.74KB) (0.85%) | 3.72ms |
1 x After Access::preloadComponents (all components) (144.79KB) (0.82%) | 3.59ms |
1 x afterLoad (458.19KB) (0.61%) | 2.66ms |
1 x Before Access::preloadComponents (all components) (163.51KB) (0.57%) | 2.50ms |
1 x afterRenderRawModule mod_rseventspro_events (events - next month) (57.25KB) (0.41%) | 1.78ms |
1 x afterRenderRawModule mod_custom (CHPSC logo) (3.94KB) (0.25%) | 1.10ms |
1 x beforeRenderRawModule mod_articles_category (Events News) (9.83KB) (0.21%) | 920μs |
1 x beforeRenderRawModule mod_custom (CHPSC logo) (19.28KB) (0.14%) | 611μs |
1 x afterRenderModule mod_rseventspro_events (events - this month) (2.74KB) (0.09%) | 385μs |
1 x afterRenderModule mod_rseventspro_events (events - next month) (2.1KB) (0.07%) | 319μs |
1 x afterRenderModule mod_custom (CHPSC logo) (2.38KB) (0.07%) | 286μs |
1 x beforeRenderComponent com_content (27.4KB) (0.06%) | 257μs |
1 x afterRenderModule mod_articles_category (Events News) (1.9KB) (0.04%) | 171μs |
1 x After Access::getAssetRules (id:1494 name:com_content.category.172) (7.47KB) (0.03%) | 136μs |
1 x Before Access::getAssetRules (id:1494 name:com_content.category.172) (66.65KB) (0.03%) | 117μs |
1 x After Access::getAssetRules (id:8 name:com_content) (6.27KB) (0.01%) | 51μs |
1 x beforeRenderRawModule mod_rseventspro_events (events - next month) (344B) (0.01%) | 47μs |
1 x After Access::getAssetRules (id:1 name:root.1) (6.02KB) (0.01%) | 42μs |
1 x Before Access::preloadPermissions (com_content) (2.1KB) (0.01%) | 24μs |
1 x beforeRenderModule mod_rseventspro_events (events - next month) (736B) (0%) | 16μs |
1 x beforeRenderModule mod_articles_category (Events News) (704B) (0%) | 13μs |
1 x beforeRenderModule mod_custom (CHPSC logo) (720B) (0%) | 12μs |
1 x beforeRenderModule mod_rseventspro_events (events - this month) (736B) (0%) | 11μs |
select distinct reference_table from jos_falang_content
420μs1.01KB/plugins/system/falangdriver/falang_database.php:224CopySELECT `value` FROM jos_acyc_configuration WHERE `name` = "license_key"
177μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `value` FROM jos_acyc_configuration WHERE `name` = "last_cron_trigger"
93μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acyc_configuration
161μs896B/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acyc_configuration
120μs1.19KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM jos_rsform_config
315μs1.81KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM jos_rsmembership_configuration
199μs1.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `value` FROM jos_acym_configuration WHERE `name` = 'level'
121μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `value` FROM jos_acym_configuration WHERE `name` = 'active_cron'
126μs1.15KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `value` FROM jos_acym_configuration WHERE `name` = 'cron_next'
82μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `value` FROM jos_acym_configuration WHERE `name` = 'queue_type'
74μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `value` FROM jos_acym_configuration WHERE `name` = 'cron_frequency'
134μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `value` FROM jos_acym_configuration WHERE `name` = 'queue_batch_auto'
112μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `jos_rsmembership_payments`
WHERE `published` = '1'
ORDER BY `ordering` ASC
139μs880B/plugins/system/falangdriver/falang_database.php:330CopySELECT `s`.`membership_id`,`s`.`params`,`s`.`type`
FROM `jos_rsmembership_membership_shared` AS `s`
LEFT JOIN `jos_rsmembership_memberships` AS `m` ON `s`.`membership_id` = `m`.`id`
WHERE `s`.`published` = '1' AND `m`.`published` = '1' AND `s`.`type` IN ('article','category')
96μs640B/plugins/system/falangdriver/falang_database.php:330CopySELECT `s`.`extra_value_id`,`s`.`params`,`s`.`type`
FROM `jos_rsmembership_extra_value_shared` AS `s`
LEFT JOIN `jos_rsmembership_extra_values` AS `v` ON `s`.`extra_value_id` = `v`.`id`
WHERE `s`.`published` = '1' AND `v`.`published` = '1' AND `s`.`type` IN ('article','category')
100μs640B/plugins/system/falangdriver/falang_database.php:330CopySELECT `parent_id` FROM jos_categories WHERE `extension`='com_content' AND `id`='172'
113μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT joomlatablename,tablepkID FROM `jos_falang_tableinfo`
92μs800B/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_languages ORDER BY ordering
195μs1.61KB/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `jos_languages`
327μs1.52KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `parent_id` FROM jos_categories WHERE `extension`='com_content' AND `id`='83'
109μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `s`.`membership_id`,`s`.`params`,`s`.`type`
FROM `jos_rsmembership_membership_shared` AS `s`
LEFT JOIN `jos_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 '475'
90μs640B/plugins/system/falangdriver/falang_database.php:330CopySELECT `s`.`extra_value_id`,`s`.`params`,`s`.`type`
FROM `jos_rsmembership_extra_value_shared` AS `s`
LEFT JOIN `jos_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 '475'
98μs640B/plugins/system/falangdriver/falang_database.php:330CopySELECT `s`.`membership_id`,`s`.`params`,`s`.`type`
FROM `jos_rsmembership_membership_shared` AS `s`
LEFT JOIN `jos_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_content%'
118μs640B/plugins/system/falangdriver/falang_database.php:330CopySELECT `s`.`extra_value_id`,`s`.`params`,`s`.`type`
FROM `jos_rsmembership_extra_value_shared` AS `s`
LEFT JOIN `jos_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_content%'
81μs640B/plugins/system/falangdriver/falang_database.php:330CopySELECT `membership_id`,`params`
FROM `jos_rsmembership_membership_shared`
WHERE `type` = 'menu' AND `published` = '1'
62μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT `extra_value_id`,`params`
FROM `jos_rsmembership_extra_value_shared`
WHERE `type` = 'menu' AND `published` = '1'
58μs576B/plugins/system/falangdriver/falang_database.php:330CopySHOW TABLES
2.5ms24.51KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_configuration
551μs24.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin
219μs1.53KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'acychecker' LIMIT 1
562μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'acymailer' LIMIT 1
468μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'amazon' LIMIT 1
280μs3.95KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'article' LIMIT 1
291μs1.47KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'birthday' LIMIT 1
378μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'brevo' LIMIT 1
318μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'createuser' LIMIT 1
125μs1.47KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value`
FROM jos_usergroups AS `groups`
243μs1.08KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'elasticemail' LIMIT 1
410μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'forward' LIMIT 1
389μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'mailgun' LIMIT 1
324μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'module' LIMIT 1
314μs1.47KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'online' LIMIT 1
394μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'override' LIMIT 1
358μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'phpmail' LIMIT 1
424μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'postmark' LIMIT 1
460μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'qmail' LIMIT 1
374μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'rseventspro' LIMIT 1
344μs1.47KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'segment' LIMIT 1
508μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'sendgrid' LIMIT 1
949μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'sendinblue' LIMIT 1
631μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'luecredentials' LIMIT 1
473μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'lueintegration' LIMIT 1
337μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'luetransactional' LIMIT 1
460μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'luelist' LIMIT 1
628μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'lueusers' LIMIT 1
382μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'luesender' LIMIT 1
597μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'luecampaign' LIMIT 1
224μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'luewebhooks' LIMIT 1
479μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'sendmail' LIMIT 1
677μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'smtp' LIMIT 1
426μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'statistics' LIMIT 1
551μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'subscriber' LIMIT 1
566μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'subscription' LIMIT 1
989μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'surveys' LIMIT 1
710μs12.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'time' LIMIT 1
568μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'user' LIMIT 1
528μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'virtuemart' LIMIT 1
577μs1.47KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_plugin WHERE folder_name = 'managetext' LIMIT 1
434μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM jos_template_styles AS s
WHERE s.client_id = 0 AND s.template = 'g5_vermilion'
ORDER BY s.id
368μs912B/plugins/system/falangdriver/falang_database.php:330CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_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,:preparedArray53,:preparedArray54,:preparedArray55,:preparedArray56)
2.63ms8.19KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0
5.42ms213.48KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `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`,(
SELECT COUNT(`i`.`id`)
FROM `jos_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1 AND `i`.`language` IN (:preparedArray3,:preparedArray4)) AS `numitems`
FROM `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray1,:preparedArray2)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
1.28ms4.03KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
646μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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`
FROM `jos_content` AS `a`
LEFT JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `jos_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `jos_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` = :categoryId AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray5,:preparedArray6)
ORDER BY c.lft, CASE WHEN a.publish_up IS NULL THEN a.created ELSE a.publish_up END DESC , a.created
1.01ms7KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1619,1541) AND `reference_table`= 'content'
440μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (172) AND `reference_table`= 'categories'
484μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (172) AND `reference_table`= 'categories'
492μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.*
FROM `jos_contentitem_tag_map` AS `m`
INNER JOIN `jos_tags` AS `t` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :contentType AND `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1,:preparedArray2) AND `t`.`access` IN (:preparedArray3,:preparedArray4)
456μs4.03KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT COUNT(*)
FROM `jos_content` AS `a`
LEFT JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `jos_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `jos_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` = :categoryId AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray5,:preparedArray6)
618μs6.09KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS `m`
INNER JOIN `jos_tags` 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)
570μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `jos_modules` AS `m`
LEFT JOIN `jos_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `jos_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) AND `m`.`language` IN (:preparedArray3,:preparedArray4)
ORDER BY `m`.`position`,`m`.`ordering`
2.75ms51.09KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (317,328,332,333,337,353,356,108,373,374,414,419,421,422,424,435,436,438,439,449,450,451,452,453,454,457,458,459,460,461,463,465,466,467,468,472,474,475,476,477,478,501,502,503,504,416,411,294,94,338,87,97,282,164,349,160,297,324,296) AND `reference_table`= 'modules'
1.52ms688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `membership_id`,`params`
FROM `jos_rsmembership_membership_shared`
WHERE `type` = 'module' AND `published` = '1'
333μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT `extra_value_id`,`params`
FROM `jos_rsmembership_extra_value_shared`
WHERE `type` = 'module' AND `published` = '1'
404μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT r.*
FROM jos_rereplacer AS r
WHERE r.published = 1 AND (r.area = 'articles')
ORDER BY r.ordering, r.id
390μs1.48KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
1.02ms4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
585μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT 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 jos_fields AS a
LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language
LEFT JOIN jos_users AS uc ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access
LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `jos_fields_categories` AS fc ON fc.field_id = a.id
WHERE
(
(`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) 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.13ms4.81KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT LOWER(REPLACE(a.title, " ", ""))
FROM jos_viewlevels as a
WHERE a.id IN ('1','7')
385μs552B/plugins/system/falangdriver/falang_database.php:330CopySELECT LOWER(REPLACE(u.title, " ", ""))
FROM jos_usergroups as u
WHERE u.id IN ('1')
152μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
992μs4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
577μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
1.26ms4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
570μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
937μs4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
594μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
1.26ms4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
937μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
1.8ms4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
691μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
953μs4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
612μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
1.12ms4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
584μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
968μs4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
639μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT 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 jos_fields AS a
LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language
LEFT JOIN jos_users AS uc ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access
LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id
LEFT JOIN jos_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.09ms4.06KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT article.id,'https://pwllhelisailingclub.co.uk/index.php/club-sections/events?id=172&view=category\n[143] RegularLabs.Plugin.System.ArticlesAnywhere.Helpers.DB.getResults\n[ 80] RegularLabs.Plugin.System.ArticlesAnywhere.Database.getResults\n[ 95] RegularLabs.Plugin.System.ArticlesAnywhere.Helpers.DB.__callStatic' as 'query_comment'
FROM `jos_content` AS `article`
WHERE `article`.`catid` = 172 AND `article`.`state` = 1
443μs608B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1541,1619) AND `reference_table`= 'content'
319μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
991μs4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
557μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT 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 jos_fields AS a
LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language
LEFT JOIN jos_users AS uc ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access
LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `jos_fields_categories` AS fc ON fc.field_id = a.id
WHERE
(
(`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) 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.12ms4.81KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
1.11ms4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
712μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
1.08ms4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
673μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
1.09ms4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
609μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
1.14ms4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
661μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
1.05ms4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
774μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
746μs4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
479μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
1.02ms4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
530μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
825μs4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
386μs8.67KB/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
636μs4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
313μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
563μs4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
335μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
612μs4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
331μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
577μs4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
338μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT 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 jos_fields AS a
LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language
LEFT JOIN jos_users AS uc ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access
LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id
LEFT JOIN jos_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.03ms4.09KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT r.*
FROM jos_rereplacer AS r
WHERE r.published = 1 AND (r.area = 'component')
ORDER BY r.ordering, r.id
222μs1.48KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `language`,`id`
FROM `jos_menu`
WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0
643μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (3350) AND `reference_table`= 'menu'
260μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
665μs4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
385μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
572μs4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
357μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
608μs4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
348μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
585μs4KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,83,172,166) AND `reference_table`= 'categories'
333μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
FROM `jos_categories` AS `c`
INNER JOIN `jos_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context
INNER JOIN `jos_associations` AS `a2` ON `a`.`key` = `a2`.`key`
INNER JOIN `jos_categories` AS `c2` ON `a2`.`id` = `c2`.`id` AND c2.extension = :extension1
WHERE `c`.`id` = :id AND `c`.`extension` = :extension3
257μs1.42KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `a`.`menutype`,`a`.`title`
FROM `jos_menu_types` AS `a`
WHERE `a`.`client_id` = 0
170μs640B/plugins/system/falangdriver/falang_database.php:330CopySELECT m.id, m.alias, m.path AS route, m.level, m.parent_id
FROM jos_menu AS m
WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0
ORDER BY m.lft
1.12ms3.23KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (3350,1185,6937,7430,6501,5588,544,1186,1807,5068,2174,1188,1335,1808,2541,492,1283,477,970,527,530,1728,923,1383,1384,668,3483,6491,4473,7171,7172,1281,3154,4575,4572,6529,4574,4734,4573,6892,1152,2519,2515,2516,3404,5318,474,511,6528,2536,2540,512,1966,2538,2539,475,7704,517,1236,1329,520,1574,1577,1578,1575,1579,1580,1235,543,728,667,473,1148,6527,4576,3289,4570,4689,4571,4569,1581,2535,2060,1788,1469,1790,1787,1153,1154,1149,1528,864,4031,4568,510,472,4561,5817,6526,7235,484,7706,7705,2518,7707,499,501,500,1727,3931,498,3160,3801,5002,5041,5003,3183,6473,7236,4560,6474,7237,497,1809,3541,495,1172,1906,486,1907,5121,5818,5871,7630,6387) AND `reference_table`= 'menu'
2.25ms688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `owner`,`id`
FROM `jos_rseventspro_events`
WHERE `id` IN (
SELECT `ide`
FROM `jos_rseventspro_taxonomy`
WHERE `type` = 'groups')
208μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `jos_rseventspro_config`
347μs3.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `e`.`id` FROM `jos_rseventspro_events` AS `e` LEFT JOIN `jos_rseventspro_locations` AS `l` ON `l`.`id` = `e`.`location` LEFT JOIN `jos_rseventspro_tickets` AS `tickets` ON `tickets`.`ide` = `e`.`id` WHERE 1 AND (`e`.`completed` = '1' AND `e`.`published` IN (1,3) AND ( (`e`.`end` <> '0000-00-00 00:00:00' AND `e`.`start` >= '2025-01-01 00:00:00' AND `e`.`end` <= '2025-01-31 23:59:59') OR (`e`.`end` <> '0000-00-00 00:00:00' AND `e`.`start` >= '2025-01-01 00:00:00' AND `e`.`start` <= '2025-01-31 23:59:59' AND `e`.`end` >= '2025-01-31 23:59:59') OR (`e`.`end` <> '0000-00-00 00:00:00' AND `e`.`start` <= '2025-01-01 00:00:00' AND `e`.`end` >= '2025-01-01 00:00:00' AND `e`.`end` <= '2025-01-31 23:59:59') OR (`e`.`end` <> '0000-00-00 00:00:00' AND `e`.`start` <= '2025-01-01 00:00:00' AND `e`.`end` >= '2025-01-31 23:59:59') OR (`e`.`end` = '0000-00-00 00:00:00' AND `e`.`start` >= '2025-01-01 00:00:00' AND `e`.`start` <= '2025-01-31 23:59:59') ) ) GROUP BY `e`.`id` ORDER BY `e`.`start` ASC LIMIT 12
474μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `owner`,`id`
FROM `jos_rseventspro_events`
WHERE `id` IN (
SELECT `ide`
FROM `jos_rseventspro_taxonomy`
WHERE `type` = 'groups')
177μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT `e`.`id` FROM `jos_rseventspro_events` AS `e` LEFT JOIN `jos_rseventspro_locations` AS `l` ON `l`.`id` = `e`.`location` LEFT JOIN `jos_rseventspro_tickets` AS `tickets` ON `tickets`.`ide` = `e`.`id` WHERE 1 AND (`e`.`completed` = '1' AND `e`.`published` IN (1,3) AND ( (`e`.`end` <> '0000-00-00 00:00:00' AND `e`.`start` >= '2025-02-01 00:00:00' AND `e`.`end` <= '2025-02-28 23:59:59') OR (`e`.`end` <> '0000-00-00 00:00:00' AND `e`.`start` >= '2025-02-01 00:00:00' AND `e`.`start` <= '2025-02-28 23:59:59' AND `e`.`end` >= '2025-02-28 23:59:59') OR (`e`.`end` <> '0000-00-00 00:00:00' AND `e`.`start` <= '2025-02-01 00:00:00' AND `e`.`end` >= '2025-02-01 00:00:00' AND `e`.`end` <= '2025-02-28 23:59:59') OR (`e`.`end` <> '0000-00-00 00:00:00' AND `e`.`start` <= '2025-02-01 00:00:00' AND `e`.`end` >= '2025-02-28 23:59:59') OR (`e`.`end` = '0000-00-00 00:00:00' AND `e`.`start` >= '2025-02-01 00:00:00' AND `e`.`start` <= '2025-02-28 23:59:59') ) ) GROUP BY `e`.`id` ORDER BY `e`.`start` ASC
462μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `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`
FROM `jos_content` AS `a`
LEFT JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `jos_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `jos_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`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`.`created_by_alias` IN (:preparedArray6) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`created` IS NOT NULL AND `a`.`created` >= DATE_ADD('2025-01-31 23:58:26', INTERVAL -30 DAY) AND `a`.`language` IN (:preparedArray7,:preparedArray8)
ORDER BY a.created ASC
947μs7.03KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT 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 `jos_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
550μs1.37KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_list WHERE type = 'standard'
552μs2.08KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_field
480μs18.39KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM jos_acym_form WHERE active = 1 AND type != 'shortcode'
436μs912B/plugins/system/falangdriver/falang_database.php:330CopySELECT r.*
FROM jos_rereplacer AS r
WHERE r.published = 1 AND (r.area = 'head')
ORDER BY r.ordering, r.id
490μs1.48KB/plugins/system/falangdriver/falang_database.php:330CopySELECT r.*
FROM jos_rereplacer AS r
WHERE r.published = 1 AND (r.area = 'body')
ORDER BY r.ordering, r.id
580μs1.48KB/plugins/system/falangdriver/falang_database.php:330CopySELECT r.*
FROM jos_rereplacer AS r
WHERE r.published = 1 AND (r.area = 'everywhere')
ORDER BY r.ordering, r.id
475μs1.48KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `value` FROM jos_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"
954μs552B/plugins/system/falangdriver/falang_database.php:330CopySHOW TABLES
2.74ms24.51KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `alias`,`id`
FROM `jos_content`
WHERE id = '463'
485μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (463) AND `reference_table`= 'content'
504μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
600μs3.98KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,78,108) AND `reference_table`= 'categories'
401μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
456μs3.98KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,78,108) AND `reference_table`= 'categories'
333μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
435μs3.98KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,78,108) AND `reference_table`= 'categories'
430μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
530μs3.98KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `jos_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,78,108) AND `reference_table`= 'categories'
395μs688B/plugins/system/falangdriver/falang_database.php:325Copy