Work at EarMaster
We don't have any open positions at the moment, but we'd like to hear from you if you think you can help us reach our goal to make music education easier, better, and smarter.
We don't have any open positions at the moment, but we'd like to hear from you if you think you can help us reach our goal to make music education easier, better, and smarter.
© EarMaster 2025. All rights reserved
Joomla! Version | 5.3.2 |
PHP Version | 8.3.12 |
Identity | guest |
Response | 200 |
Template | astroid_template_two |
Database |
|
1 x beforeRenderRawModule mod_falang (FaLang Language Switcher) (2.12MB) (29.41%) | 26.39ms |
1 x afterInitialise (3.92MB) (20.94%) | 18.79ms |
1 x afterRenderRawModule mod_falang (FaLang Language Switcher) (576.8KB) (12.67%) | 11.37ms |
1 x afterRenderComponent com_content (603.66KB) (10.4%) | 9.33ms |
1 x afterRender (1.76MB) (10.28%) | 9.23ms |
1 x afterRoute (2.21MB) (4.74%) | 4.25ms |
1 x afterLoad (83.65KB) (1.82%) | 1.63ms |
1 x afterRenderModule mod_custom (Footer) (14.56KB) (0.9%) | 804μs |
1 x Before Access::getAssetRules (id:8 name:com_content) (56.84KB) (0.85%) | 765μs |
1 x After Access::preloadComponents (all components) (136.69KB) (0.37%) | 335μs |
1 x Before Access::preloadComponents (all components) (54.17KB) (0.35%) | 316μs |
1 x After Access::preloadPermissions (com_content) (120.2KB) (0.29%) | 257μs |
1 x beforeRenderComponent com_content (37.26KB) (0.24%) | 218μs |
1 x afterDispatch (11.95KB) (0.24%) | 216μs |
1 x afterRenderRawModule mod_custom (Links to Privacy and Terms) (3.95KB) (0.17%) | 153μs |
1 x afterRenderModule mod_falang (FaLang Language Switcher) (5.8KB) (0.12%) | 104μs |
1 x Before Access::getAssetRules (id:1 name:root.1) (5.17KB) (0.05%) | 48μs |
1 x afterRenderModule mod_custom (Links to Privacy and Terms) (2.78KB) (0.05%) | 44μs |
1 x After Access::getAssetRules (id:262 name:com_content.article.70) (8.3KB) (0.03%) | 27μs |
1 x beforeRenderRawModule mod_custom (Footer) (744B) (0.03%) | 27μs |
1 x afterRenderRawModule mod_custom (Footer) (928B) (0.02%) | 16μs |
1 x After Access::getAssetRules (id:1 name:root.1) (6.48KB) (0.01%) | 10μs |
1 x beforeRenderRawModule mod_custom (Links to Privacy and Terms) (3.5KB) (0.01%) | 10μs |
1 x Before Access::getAssetRules (id:262 name:com_content.article.70) (6.65KB) (0.01%) | 6μs |
1 x Before Access::preloadPermissions (com_content) (424B) (0.01%) | 5μs |
1 x After Access::getAssetRules (id:8 name:com_content) (1.28KB) (0.01%) | 5μs |
1 x beforeRenderModule mod_falang (FaLang Language Switcher) (736B) (0%) | 3μs |
1 x beforeRenderModule mod_custom (Links to Privacy and Terms) (736B) (0%) | 2μs |
1 x beforeRenderModule mod_custom (Footer) (704B) (0%) | 1μs |
select distinct reference_table from v12ai_falang_content
58μs1016B/plugins/system/falangdriver/falang_database.php:224CopySELECT `params`
FROM `v12ai_extensions`
WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'
63μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `v12ai_admintools_ipautoban`
37μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT `ip`
FROM `v12ai_admintools_ipblock`
37μs776B/plugins/system/falangdriver/falang_database.php:330CopySELECT `source`,`dest`,`keepurlparams`
FROM `v12ai_admintools_redirects`
WHERE `published` = 1
ORDER BY `ordering` ASC
40μs960B/plugins/system/falangdriver/falang_database.php:330CopySELECT `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 `v12ai_menu` AS `m`
LEFT JOIN `v12ai_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`
1.14ms1.23MBParams/plugins/system/falangdriver/falang_database.php:133CopySELECT `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 `v12ai_menu` AS `m`
LEFT JOIN `v12ai_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`
799μs1.23MBParams/plugins/system/falangdriver/falang_database.php:133CopySELECT `option`,`view`,`task`,`query`,`query_type`,`query_content`,`verb`,`application`
FROM `v12ai_admintools_wafblacklists`
WHERE `enabled` = 1
39μs976B/plugins/system/falangdriver/falang_database.php:330CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `v12ai_template_styles` AS `s`
LEFT JOIN `v12ai_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
76μs1.47KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `v12ai_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)
176μs7.94KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `v12ai_assets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0
131μs5.48KBParams/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `v12ai_content`
190μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopyUPDATE `v12ai_content`
SET `hits` = (`hits` + 1)
WHERE `id` = '70'
104μs48B/plugins/system/falangdriver/falang_database.php:133CopySELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`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`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count`
FROM `v12ai_content` AS `a`
INNER JOIN `v12ai_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `v12ai_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `v12ai_users` AS `u` ON `u`.`id` = `a`.`created_by`
LEFT JOIN `v12ai_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `v12ai_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE
(
(`a`.`id` = :pk AND `c`.`published` > 0 AND `a`.`language` IN (:preparedArray1,:preparedArray2)) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray3,:preparedArray4)
164μs6.19KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT joomlatablename,tablepkID FROM `v12ai_falang_tableinfo`
45μs1KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM v12ai_languages ORDER BY ordering
44μs1.64KB/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `v12ai_languages`
151μs2.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `v12ai_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (70) AND `reference_table`= 'content'
74μ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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
127μs3.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
103μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `m`.`tag_id`,`t`.*
FROM `v12ai_contentitem_tag_map` AS `m`
INNER JOIN `v12ai_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)
90μs3.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
149μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT 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 v12ai_fields AS a
LEFT JOIN `v12ai_languages` AS l ON l.lang_code = a.language
LEFT JOIN v12ai_users AS uc ON uc.id=a.checked_out
LEFT JOIN v12ai_viewlevels AS ag ON ag.id = a.access
LEFT JOIN v12ai_users AS ua ON ua.id = a.created_user_id
LEFT JOIN v12ai_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `v12ai_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)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) 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
269μs4.75KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `params` FROM `v12ai_categories` WHERE `id`=14
41μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `id`
FROM `v12ai_rstbox`
WHERE `published` = 1 AND `testmode` = 0
57μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `language`,`id`
FROM `v12ai_menu`
WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0
93μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `v12ai_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (101) AND `reference_table`= 'menu'
57μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `alias`,`catid`
FROM v12ai_content
WHERE `id` = :key
33μs1.37KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `alias`,`catid`
FROM v12ai_content
WHERE `id` = :key
25μs1.37KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid`
FROM `v12ai_content` AS `c`
INNER JOIN `v12ai_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context
INNER JOIN `v12ai_associations` AS `a2` ON `a`.`key` = `a2`.`key`
INNER JOIN `v12ai_content` AS `c2` ON `a2`.`id` = `c2`.`id`
INNER JOIN `v12ai_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2
WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-GB' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-08-13 09:27:55') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-08-13 09:27:55') AND c2.state = 1
80μs1.47KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `v12ai_modules` AS `m`
LEFT JOIN `v12ai_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `v12ai_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`
294μs130.34KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `v12ai_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (113,116,121,125,127,132,133,134,135,136,138,139,140,150,151,157,158,159,164,165,166,168,177,207,112,17,123,110,124) AND `reference_table`= 'modules'
155μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT *
FROM `v12ai_categories`
WHERE `extension` = 'com_content' AND `published` = '1' AND `access` IN (1,5) AND `language` IN ('en-GB', '*') AND `parent_id` IN (16)
ORDER BY `lft` ASC
79μs5.48KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.*,`b`.`alias` AS `category_alias`,`b`.`title` AS `category_title`
FROM `v12ai_content` AS `a`
LEFT JOIN `v12ai_categories` AS `b` ON (`a`.`catid` = `b`.`id`)
WHERE
(
(`b`.`extension` = 'com_content' AND `a`.`state` = '1' AND `a`.`catid` IN (16)) 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 ('en-GB','*') AND `a`.`access` IN (1,5)
ORDER BY `a`.`publish_up` DESC,`a`.`created` DESC LIMIT 100
139μs100.14KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `v12ai_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (178,79,78,77,76,75,22,362,20,19,17) AND `reference_table`= 'content'
87μs688B/plugins/system/falangdriver/falang_database.php:325CopySHOW FULL COLUMNS FROM `v12ai_users`
160μs1.58KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `v12ai_users`
WHERE `id` = :userid
50μs3.16KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `g`.`id`,`g`.`title`
FROM `v12ai_usergroups` AS `g`
INNER JOIN `v12ai_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id`
WHERE `m`.`user_id` = :muserid
49μs1.37KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
117μs3.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
98μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `m`.`tag_id`,`t`.*
FROM `v12ai_contentitem_tag_map` AS `m`
INNER JOIN `v12ai_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)
83μs3.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
102μs3.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
91μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `m`.`tag_id`,`t`.*
FROM `v12ai_contentitem_tag_map` AS `m`
INNER JOIN `v12ai_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)
78μs3.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
102μs3.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
102μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `m`.`tag_id`,`t`.*
FROM `v12ai_contentitem_tag_map` AS `m`
INNER JOIN `v12ai_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)
80μs3.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
107μs3.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
96μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `m`.`tag_id`,`t`.*
FROM `v12ai_contentitem_tag_map` AS `m`
INNER JOIN `v12ai_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)
77μs3.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
96μs3.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
90μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `m`.`tag_id`,`t`.*
FROM `v12ai_contentitem_tag_map` AS `m`
INNER JOIN `v12ai_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)
79μs3.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
100μs3.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
92μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `m`.`tag_id`,`t`.*
FROM `v12ai_contentitem_tag_map` AS `m`
INNER JOIN `v12ai_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)
76μs3.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
95μs3.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
89μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `m`.`tag_id`,`t`.*
FROM `v12ai_contentitem_tag_map` AS `m`
INNER JOIN `v12ai_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)
77μs3.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
102μs3.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
93μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `m`.`tag_id`,`t`.*
FROM `v12ai_contentitem_tag_map` AS `m`
INNER JOIN `v12ai_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)
74μs3.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
97μs3.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
89μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `m`.`tag_id`,`t`.*
FROM `v12ai_contentitem_tag_map` AS `m`
INNER JOIN `v12ai_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)
79μs14.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
94μs3.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
100μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `m`.`tag_id`,`t`.*
FROM `v12ai_contentitem_tag_map` AS `m`
INNER JOIN `v12ai_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)
75μs3.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
94μs3.97KBParams/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 `v12ai_categories` AS `s`
INNER JOIN `v12ai_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`
92μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `m`.`tag_id`,`t`.*
FROM `v12ai_contentitem_tag_map` AS `m`
INNER JOIN `v12ai_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)
75μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `c2`.`language`,`c2`.`id`
FROM `v12ai_menu` AS `c`
INNER JOIN `v12ai_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context
INNER JOIN `v12ai_associations` AS `a2` ON `a`.`key` = `a2`.`key`
INNER JOIN `v12ai_menu` AS `c2` ON `a2`.`id` = `c2`.`id`
WHERE `c`.`id` = :id
53μs1.38KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`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`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count`
FROM `v12ai_content` AS `a`
INNER JOIN `v12ai_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `v12ai_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `v12ai_users` AS `u` ON `u`.`id` = `a`.`created_by`
LEFT JOIN `v12ai_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `v12ai_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE
(
(`a`.`id` = :pk AND `c`.`published` > 0) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)
103μs6.12KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `v12ai_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (70) AND `reference_table`= 'content'
60μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT alias
FROM v12ai_content
WHERE id = 70
26μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`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`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count`
FROM `v12ai_content` AS `a`
INNER JOIN `v12ai_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `v12ai_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `v12ai_users` AS `u` ON `u`.`id` = `a`.`created_by`
LEFT JOIN `v12ai_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `v12ai_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE
(
(`a`.`id` = :pk AND `c`.`published` > 0) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)
88μs6.12KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `v12ai_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (70) AND `reference_table`= 'content'
52μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT fc.value
FROM v12ai_falang_content fc
WHERE fc.reference_id = 70 AND fc.language_id = 3 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'
58μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `alias`
FROM `v12ai_content`
WHERE id = '70'
24μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM v12ai_falang_content fc
WHERE fc.reference_id = 70 AND fc.language_id = 3 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'
51μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM v12ai_falang_content fc
WHERE fc.reference_id = 14 AND fc.language_id = 3 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'categories'
69μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM v12ai_falang_content fc
WHERE fc.reference_id = 405 AND fc.language_id = 3 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
141μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT m.path
FROM v12ai_menu m
WHERE m.id = 405
67μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM v12ai_falang_content fc
WHERE fc.reference_id = 405 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
117μs520B/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `v12ai_menu`
320μs1.7KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `v12ai_menu`
WHERE `id` = '405'
101μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `v12ai_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (405) AND `reference_table`= 'menu'
53μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT p.*, jfc.value as jfcvalue
FROM v12ai_menu AS n, v12ai_menu AS p
LEFT JOIN v12ai_falang_content as jfc ON jfc.reference_table='menu' AND jfc.reference_id=p.id AND jfc.language_id='1' and jfc.reference_field='alias'
WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 405 AND p.client_id = 0
ORDER BY p.lft
100μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`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`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count`
FROM `v12ai_content` AS `a`
INNER JOIN `v12ai_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `v12ai_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `v12ai_users` AS `u` ON `u`.`id` = `a`.`created_by`
LEFT JOIN `v12ai_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `v12ai_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE
(
(`a`.`id` = :pk AND `c`.`published` > 0) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)
132μs6.12KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `v12ai_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (70) AND `reference_table`= 'content'
127μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT fc.value
FROM v12ai_falang_content fc
WHERE fc.reference_id = 70 AND fc.language_id = 2 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'
65μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `alias`
FROM `v12ai_content`
WHERE id = '70'
27μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM v12ai_falang_content fc
WHERE fc.reference_id = 70 AND fc.language_id = 2 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'
65μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM v12ai_falang_content fc
WHERE fc.reference_id = 14 AND fc.language_id = 2 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'categories'
49μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM v12ai_falang_content fc
WHERE fc.reference_id = 405 AND fc.language_id = 2 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
66μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT m.path
FROM v12ai_menu m
WHERE m.id = 405
27μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM v12ai_falang_content fc
WHERE fc.reference_id = 405 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
53μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `v12ai_menu`
WHERE `id` = '405'
45μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `v12ai_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (405) AND `reference_table`= 'menu'
47μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT p.*, jfc.value as jfcvalue
FROM v12ai_menu AS n, v12ai_menu AS p
LEFT JOIN v12ai_falang_content as jfc ON jfc.reference_table='menu' AND jfc.reference_id=p.id AND jfc.language_id='1' and jfc.reference_field='alias'
WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 405 AND p.client_id = 0
ORDER BY p.lft
95μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`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`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count`
FROM `v12ai_content` AS `a`
INNER JOIN `v12ai_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `v12ai_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `v12ai_users` AS `u` ON `u`.`id` = `a`.`created_by`
LEFT JOIN `v12ai_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `v12ai_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE
(
(`a`.`id` = :pk AND `c`.`published` > 0) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)
98μs6.12KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `v12ai_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (70) AND `reference_table`= 'content'
50μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT fc.value
FROM v12ai_falang_content fc
WHERE fc.reference_id = 70 AND fc.language_id = 4 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'
56μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `alias`
FROM `v12ai_content`
WHERE id = '70'
25μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM v12ai_falang_content fc
WHERE fc.reference_id = 70 AND fc.language_id = 4 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'
48μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM v12ai_falang_content fc
WHERE fc.reference_id = 14 AND fc.language_id = 4 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'categories'
49μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM v12ai_falang_content fc
WHERE fc.reference_id = 405 AND fc.language_id = 4 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
49μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT m.path
FROM v12ai_menu m
WHERE m.id = 405
24μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM v12ai_falang_content fc
WHERE fc.reference_id = 405 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
44μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `v12ai_menu`
WHERE `id` = '405'
43μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `v12ai_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (405) AND `reference_table`= 'menu'
60μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT p.*, jfc.value as jfcvalue
FROM v12ai_menu AS n, v12ai_menu AS p
LEFT JOIN v12ai_falang_content as jfc ON jfc.reference_table='menu' AND jfc.reference_id=p.id AND jfc.language_id='1' and jfc.reference_field='alias'
WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 405 AND p.client_id = 0
ORDER BY p.lft
104μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT m.*
FROM v12ai_modules AS m
LEFT JOIN v12ai_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
WHERE m.client_id = 0 AND m.id = 119 AND m.access IN (1,5) AND m.published = 1 AND e.enabled = 1
ORDER BY m.ordering
61μs2.39KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM v12ai_hikashop_config
97μs24.63KB/plugins/system/falangdriver/falang_database.php:330CopySET sql_mode=(SELECT REPLACE(REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''), 'STRICT_TRANS_TABLES', ''));
22μs0B/plugins/system/falangdriver/falang_database.php:133CopySELECT a.id FROM v12ai_menu AS a INNER JOIN `v12ai_menu_types` as b on a.menutype = b.menutype WHERE a.type='component' AND a.published=1 AND b.title IS NOT NULL AND a.access IN (1,5) AND a.client_id=0 AND a.link='index.php?option=com_hikashop&view=checkout&layout=show' AND a.language IN ('*', '', 'en-GB')
220μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id FROM v12ai_menu AS a INNER JOIN `v12ai_menu_types` as b on a.menutype = b.menutype WHERE a.type='component' AND a.published=1 AND b.title IS NOT NULL AND a.access IN (1,5) AND a.client_id=0 AND a.link LIKE 'index.php?option=com_hikashop&view=%' AND a.language IN ('*', '', 'en-GB')
212μs600B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `v12ai_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (616,617,618,619,620) AND `reference_table`= 'menu'
71μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT 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 `v12ai_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
46μs1.37KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `v12ai_schemaorg`
WHERE `itemId` = :itemId AND `context` = :context
41μs1.55KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`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`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count`
FROM `v12ai_content` AS `a`
INNER JOIN `v12ai_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `v12ai_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `v12ai_users` AS `u` ON `u`.`id` = `a`.`created_by`
LEFT JOIN `v12ai_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `v12ai_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE
(
(`a`.`id` = :pk AND `c`.`published` > 0 AND `a`.`language` IN (:preparedArray1,:preparedArray2)) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray3,:preparedArray4)
114μs6.23KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `v12ai_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (70) AND `reference_table`= 'content'
56μs688B/plugins/system/falangdriver/falang_database.php:325Copy