rruga Anastas Dursaku 60 Show map
Lagja 1, Rruga Taulantia, Durres, Albania Show map
Plazh, Rruga Pavaresia, Durrës Show map
Please register or log in to view more.
RESERVATION HOTLINE:
+1-222-34-56-789Infinity Joomla Template © 2016-2024. All Rights Reserved. Designed by Solidres.com
Joomla! Version | 5.3.2 |
PHP Version | 8.2.27 |
Identity | guest |
Response | 200 |
Template | infinity |
Database |
|
1 x afterInitialise (3.46MB) (25.96%) | 298ms |
1 x afterDispatch (133.58KB) (24.74%) | 284ms |
1 x afterRenderComponent com_solidres (8.07MB) (19.81%) | 227ms |
1 x Before Access::preloadComponents (all components) (2.07MB) (8.82%) | 101ms |
1 x afterLoad (355.71KB) (2.76%) | 31.62ms |
1 x afterRender (294.45KB) (2.72%) | 31.14ms |
1 x afterRoute (1.31MB) (2.36%) | 27.11ms |
1 x afterRenderRawModule mod_news_pro_gk5 (тест статьи джумла) (669.46KB) (2.14%) | 24.55ms |
1 x afterRenderRawModule mod_falang (FaLang Language Switcher) (621.22KB) (2.03%) | 23.24ms |
1 x afterRenderRawModule mod_maximenuck (тест1) (454.98KB) (1.71%) | 19.56ms |
1 x afterRenderRawModule mod_articles_latest (LATEST NEWS) (293.65KB) (1.33%) | 15.23ms |
1 x beforeRenderRawModule mod_menu (Main Menu) (310.27KB) (1.11%) | 12.73ms |
1 x Before Access::preloadPermissions (com_dpcalendar) (266.85KB) (1.08%) | 12.36ms |
1 x afterRenderRawModule mod_menu (Main Menu) (314.17KB) (0.71%) | 8.19ms |
1 x afterRenderRawModule mod_acym (STAY UP TO DATE) (105.85KB) (0.59%) | 6.74ms |
1 x afterRenderRawModule mod_maximenuck (тест2) (30.23KB) (0.25%) | 2.91ms |
1 x afterRenderRawModule mod_image_show_gk4 (тест слайдер1) (19.15KB) (0.21%) | 2.39ms |
1 x afterRenderRawModule mod_sp_weather (Weather) (29.88KB) (0.18%) | 2.03ms |
1 x After Access::preloadComponents (all components) (104.73KB) (0.18%) | 2.02ms |
1 x Before Access::getAssetRules (id:1 name:root.1) (14.54KB) (0.17%) | 1.98ms |
1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (14.41KB) (0.17%) | 1.89ms |
1 x afterRenderModule mod_menu (Main Menu) (184B) (0.11%) | 1.29ms |
1 x beforeRenderRawModule mod_news_pro_gk5 (тест статьи джумла) (73.41KB) (0.11%) | 1.24ms |
1 x beforeRenderComponent com_solidres (66.52KB) (0.07%) | 858μs |
1 x afterRenderRawModule mod_custom (Copyright) (4.63KB) (0.07%) | 782μs |
1 x afterRenderRawModule mod_menu (Bottom Menu) (20.91KB) (0.06%) | 719μs |
1 x After Access::getAssetRules (id:124 name:com_solidres) (13.1KB) (0.06%) | 653μs |
1 x After Access::preloadPermissions (com_dpcalendar) (12.91KB) (0.05%) | 612μs |
1 x afterRenderModule mod_maximenuck (тест1) (10.34KB) (0.03%) | 311μs |
1 x afterRenderModule mod_news_pro_gk5 (тест статьи джумла) (5.58KB) (0.03%) | 299μs |
1 x afterRenderModule mod_articles_latest (LATEST NEWS) (3.25KB) (0.03%) | 296μs |
1 x beforeRenderRawModule mod_custom (Copyright) (34.26KB) (0.03%) | 287μs |
1 x afterRenderModule mod_acym (STAY UP TO DATE) (4.86KB) (0.02%) | 266μs |
1 x afterRenderModule mod_maximenuck (тест2) (10.34KB) (0.02%) | 256μs |
1 x afterRenderModule mod_falang (FaLang Language Switcher) (5.67KB) (0.02%) | 235μs |
1 x afterRenderModule mod_sp_weather (Weather) (3.56KB) (0.02%) | 188μs |
1 x afterRenderModule mod_custom (Copyright) (2.73KB) (0.02%) | 186μs |
1 x afterRenderModule mod_image_show_gk4 (тест слайдер1) (3.59KB) (0.01%) | 158μs |
1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.19KB) (0.01%) | 153μs |
1 x afterRenderModule mod_custom (Contact Details) (3.11KB) (0.01%) | 135μs |
1 x afterRenderModule mod_menu (Bottom Menu) (2.88KB) (0.01%) | 126μs |
1 x beforeRenderRawModule mod_image_show_gk4 (тест слайдер1) (55.06KB) (0.01%) | 122μs |
1 x afterRenderModule mod_custom (RESERVATION HOTLINE) (2.73KB) (0.01%) | 121μs |
1 x afterRenderModule mod_custom (Map Icon) (2.59KB) (0.01%) | 108μs |
1 x beforeRenderRawModule mod_falang (FaLang Language Switcher) (24.48KB) (0.01%) | 107μs |
1 x afterRenderModule mod_custom (Social Icons) (2.86KB) (0.01%) | 101μs |
1 x beforeRenderRawModule mod_maximenuck (тест2) (24.05KB) (0.01%) | 92μs |
1 x beforeRenderRawModule mod_custom (RESERVATION HOTLINE) (824B) (0.01%) | 87μs |
1 x beforeRenderRawModule mod_articles_latest (LATEST NEWS) (2.82KB) (0.01%) | 79μs |
1 x beforeRenderRawModule mod_maximenuck (тест1) (26.23KB) (0.01%) | 61μs |
1 x beforeRenderRawModule mod_acym (STAY UP TO DATE) (1.52KB) (0%) | 49μs |
1 x afterRenderRawModule mod_custom (RESERVATION HOTLINE) (1KB) (0%) | 44μs |
1 x beforeRenderRawModule mod_custom (Social Icons) (424B) (0%) | 40μs |
1 x beforeRenderRawModule mod_custom (Contact Details) (2.18KB) (0%) | 37μs |
1 x afterRenderRawModule mod_custom (Map Icon) (1KB) (0%) | 37μs |
1 x beforeRenderRawModule mod_menu (Bottom Menu) (1.63KB) (0%) | 36μs |
1 x beforeRenderRawModule mod_sp_weather (Weather) (3.84KB) (0%) | 33μs |
1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (264B) (0%) | 30μs |
1 x afterRenderRawModule mod_custom (Contact Details) (928B) (0%) | 25μs |
1 x Before Access::getAssetRules (id:124 name:com_solidres) (1.35KB) (0%) | 25μs |
1 x beforeRenderRawModule mod_custom (Map Icon) (27.69KB) (0%) | 24μs |
1 x afterRenderRawModule mod_custom (Social Icons) (2.22KB) (0%) | 23μs |
1 x After Access::getAssetRules (id:332 name:com_dpcalendar.category.27) (6.03KB) (0%) | 21μs |
1 x Before Access::getAssetRules (id:332 name:com_dpcalendar.category.27) (440B) (0%) | 14μs |
1 x After Access::getAssetRules (id:1 name:root.1) (1.28KB) (0%) | 8μs |
1 x beforeRenderModule mod_falang (FaLang Language Switcher) (736B) (0%) | 7μs |
1 x beforeRenderModule mod_news_pro_gk5 (тест статьи джумла) (752B) (0%) | 7μs |
1 x beforeRenderModule mod_maximenuck (тест1) (720B) (0%) | 7μs |
1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%) | 6μs |
1 x beforeRenderModule mod_acym (STAY UP TO DATE) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_articles_latest (LATEST NEWS) (704B) (0%) | 6μs |
1 x beforeRenderModule mod_maximenuck (тест2) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_sp_weather (Weather) (720B) (0%) | 4μs |
1 x beforeRenderModule mod_menu (Bottom Menu) (720B) (0%) | 4μs |
1 x beforeRenderModule mod_image_show_gk4 (тест слайдер1) (736B) (0%) | 4μs |
1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%) | 3μs |
1 x beforeRenderModule mod_custom (Copyright) (720B) (0%) | 3μs |
1 x beforeRenderModule mod_custom (RESERVATION HOTLINE) (720B) (0%) | 2μs |
1 x beforeRenderModule mod_custom (Social Icons) (720B) (0%) | 2μs |
1 x beforeRenderModule mod_custom (Contact Details) (720B) (0%) | 2μs |
1 x beforeRenderModule mod_custom (Map Icon) (720B) (0%) | 2μs |
select distinct reference_table from ma37e_falang_content
158μs1.02KB/plugins/system/falangdriver/falang_database.php:224CopySELECT `params`
FROM `ma37e_extensions`
WHERE `type` = 'component' AND `element` = 'com_rsseo'
303μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_rsseo_redirects`
WHERE `published` = 1
92μs816B/plugins/system/falangdriver/falang_database.php:330CopySELECT `url`,`sef`
FROM `ma37e_rsseo_pages`
WHERE `short` = 'hotels-test?country_id=3&default_search_ordering=0&mode=list'
135ms576B/plugins/system/falangdriver/falang_database.php:330CopySELECT `url`
FROM `ma37e_rsseo_pages`
WHERE `sef` = 'hotels-test?country_id=3&default_search_ordering=0&mode=list'
342μs840B/plugins/system/falangdriver/falang_database.php:330CopySELECT `url`
FROM `ma37e_rsseo_pages`
WHERE `sef` = 'hotels-test'
238μs520B/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 `ma37e_menu` AS `m`
LEFT JOIN `ma37e_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`
913μs60.17KBParams/plugins/system/falangdriver/falang_database.php:133CopySHOW FULL TABLES WHERE table_type="BASE TABLE"
1.88ms4.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT joomlatablename,tablepkID FROM `ma37e_falang_tableinfo`
163μs1.69KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_plugin
119μs1.5KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_configuration
178μs2.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_plugin
120μs1.5KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value`
FROM ma37e_usergroups AS `groups`
372μs1.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `ma37e_template_styles` AS `s`
LEFT JOIN `ma37e_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
573μs188.92KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
258μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `ma37e_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)
647μs7.81KBParams/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_currencies`
727μs2.64KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_currencies`
WHERE `id` = '2'
169μs896B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id,cat.title AS category_name,parent.title AS parent_category_title, parent.id AS parent_category_id,
parent.created_user_id AS parent_category_uid, parent.level AS parent_category_level,COUNT(rt.id) AS number_of_roomtype,cou.name AS country_name,geostate.name AS geostate_name,uc.name AS editor,ag.title AS access_level
FROM `ma37e_sr_reservation_assets` AS a
LEFT JOIN `ma37e_categories` AS cat ON cat.id = a.category_id
LEFT JOIN `ma37e_categories` AS parent ON parent.id = cat.parent_id
LEFT JOIN `ma37e_sr_room_types` AS rt ON rt.reservation_asset_id = a.id
LEFT JOIN `ma37e_sr_countries` AS cou ON cou.id = a.country_id
LEFT JOIN `ma37e_sr_geo_states` AS geostate ON geostate.id = a.geo_state_id
LEFT JOIN `ma37e_users` AS uc ON uc.id=a.checked_out
LEFT JOIN `ma37e_viewlevels` AS ag ON ag.id = a.access
WHERE a.state = 1 AND a.country_id = 3
GROUP BY cat.title,parent.title,cou.name,geostate.name,uc.name,ag.title,a.id
ORDER BY a.rating asc
483μs1.5KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_languages`
117μs1.67KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (17,18,14,15,16) AND `reference_table`= 'sr_reservation_assets'
185μs688B/plugins/system/falangdriver/falang_database.php:325CopySHOW FULL COLUMNS FROM `ma37e_sr_reservation_assets`
1.08ms2.14KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '17'
377μs21.88KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (17) AND `reference_table`= 'sr_reservation_assets'
349μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `t`.`id`
FROM `ma37e_tags` AS `t`
INNER JOIN `ma37e_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
112μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `t`.`id`
FROM `ma37e_tags` AS `t`
INNER JOIN `ma37e_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
81μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_countries`
653μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '3'
123μs1.47KB/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_geo_states`
437μs1.36KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_geo_states`
WHERE `id` = '523'
71μs832B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_currencies`
WHERE `id` = '2'
68μs896B/plugins/system/falangdriver/falang_database.php:330CopySELECT r.*, asset.name AS reservationasset,(SELECT COUNT(id) FROM ma37e_sr_rooms AS room WHERE room.room_type_id = r.id ) as number_of_room, (SELECT COUNT(id) FROM ma37e_sr_tariffs as tariff
WHERE tariff.room_type_id = r.id
AND tariff.valid_from <> '0000-00-0 00:00:00' AND tariff.valid_from <> '0000-00-0 00:00:00' ) as number_of_tariff,uc.name AS editor,f.field_value as channel_room_id
FROM `ma37e_sr_room_types` AS r
LEFT JOIN `ma37e_users` AS uc ON uc.id= r.checked_out
LEFT JOIN `ma37e_sr_reservation_assets` AS asset ON asset.id = r.reservation_asset_id
LEFT JOIN `ma37e_sr_room_type_fields` AS f ON f.room_type_id = r.id AND f.field_key = 'beds24.roomId'
WHERE r.state = 1 AND r.reservation_asset_id = 17
GROUP BY asset.name,uc.name,r.id
ORDER BY r.ordering ASC
394μs3.08KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (33,35) AND `reference_table`= 'sr_room_types'
157μs3.17KB/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (33,35) AND `reference_table`= 'sr_reservation_assets'
152μs688B/plugins/system/falangdriver/falang_database.php:325CopySHOW FULL COLUMNS FROM `ma37e_sr_customers`
462μs1.58KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_customers`
WHERE `id` = '36'
87μs2.5KB/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_users`
481μs1.58KB/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_customer_groups`
304μs1.31KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_users`
WHERE `id` = :userid
162μs3.16KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `g`.`id`,`g`.`title`
FROM `ma37e_usergroups` AS `g`
INNER JOIN `ma37e_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id`
WHERE `m`.`user_id` = :muserid
196μs1.38KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '17'
126μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_currencies`
WHERE `id` = 2
198μs896B/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT a.*, asset.name as reservationasset
FROM `ma37e_sr_discounts` AS a
LEFT JOIN `ma37e_sr_reservation_assets` AS asset ON asset.id = a.reservation_asset_id
WHERE a.scope = 0 AND a.state = 1 AND a.reservation_asset_id = 17 AND a.type IN (0,2,3,8,9)
ORDER BY a.title ASC
468μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.title, a.state, a.percentage, a.value, a.user_groups, a.scope, a.created, a.created_by, a.type
FROM `ma37e_sr_commission_rates` AS `a`
WHERE a.state = 1 AND a.scope = 0 AND a.type = 1
ORDER BY a.id desc
156μs1.33KB/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT ug.id
FROM `ma37e_usergroups` AS `ug`
INNER JOIN `ma37e_user_usergroup_map` AS `um` ON ug.id = um.group_id
INNER JOIN `ma37e_sr_customers` AS `a` ON a.user_id = um.user_id
WHERE a.id = 36
294μs552B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '33'
70μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT t.*, cgroup.name as customer_group_name
FROM `ma37e_sr_tariffs` AS t
LEFT JOIN `ma37e_sr_customer_groups` as cgroup ON cgroup.id = t.customer_group_id
WHERE t.room_type_id = 33 AND t.customer_group_id IS NULL AND t.state = 1 AND t.valid_from != '0000-00-00' AND t.valid_to != '0000-00-00' AND t.valid_to > CURDATE()
ORDER BY t.ordering asc
243μs3.09KB/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_tariffs`
532μs1.7KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '115'
97μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT t.id, t.tariff_id, ROUND(t.price, 0) AS price, ROUND(t.price_extras, 0) AS price_extras, ROUND(t.price_unoccupied, 0) AS price_unoccupied, t.w_day, t.guest_type, t.from_age, t.to_age, t.date, t.min_los, t.max_los, t.d_interval, t.limit_checkin, t.week_from, t.week_to
FROM `ma37e_sr_tariff_details` AS t
WHERE t.tariff_id = 115
ORDER BY t.date ASC
354μs4.64KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '116'
124μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT t.id, t.tariff_id, ROUND(t.price, 0) AS price, ROUND(t.price_extras, 0) AS price_extras, ROUND(t.price_unoccupied, 0) AS price_unoccupied, t.w_day, t.guest_type, t.from_age, t.to_age, t.date, t.min_los, t.max_los, t.d_interval, t.limit_checkin, t.week_from, t.week_to
FROM `ma37e_sr_tariff_details` AS t
WHERE t.tariff_id = 116
ORDER BY t.date ASC
417μs4.64KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '117'
121μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT t.id, t.tariff_id, ROUND(t.price, 0) AS price, ROUND(t.price_extras, 0) AS price_extras, ROUND(t.price_unoccupied, 0) AS price_unoccupied, t.w_day, t.guest_type, t.from_age, t.to_age, t.date, t.min_los, t.max_los, t.d_interval, t.limit_checkin, t.week_from, t.week_to
FROM `ma37e_sr_tariff_details` AS t
WHERE t.tariff_id = 117
ORDER BY t.date ASC
366μs4.64KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '118'
99μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT t.id, t.tariff_id, ROUND(t.price, 0) AS price, ROUND(t.price_extras, 0) AS price_extras, ROUND(t.price_unoccupied, 0) AS price_unoccupied, t.w_day, t.guest_type, t.from_age, t.to_age, t.date, t.min_los, t.max_los, t.d_interval, t.limit_checkin, t.week_from, t.week_to
FROM `ma37e_sr_tariff_details` AS t
WHERE t.tariff_id = 118
ORDER BY t.date ASC
520μs4.64KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '119'
93μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT t.id, t.tariff_id, ROUND(t.price, 0) AS price, ROUND(t.price_extras, 0) AS price_extras, ROUND(t.price_unoccupied, 0) AS price_unoccupied, t.w_day, t.guest_type, t.from_age, t.to_age, t.date, t.min_los, t.max_los, t.d_interval, t.limit_checkin, t.week_from, t.week_to
FROM `ma37e_sr_tariff_details` AS t
WHERE t.tariff_id = 119
ORDER BY t.date ASC
225μs2.89KB/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 33 AND (field_key LIKE 'myallocator.%' OR field_key LIKE 'beds24.%')
162μs640B/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 33
265μs2.51KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.title, a.description, a.icon
FROM `ma37e_sr_facilities` AS `a`
WHERE a.id IN (670,476,486,683,676,682,680,677,686,691,678,681,693,689,687,692,685,679,688,684,690,520,513,538,539,540,541,695,542,543,544,545,546,547,548,566,549,550,551,568,552,537,553,554,555,556,694,557,558,559,560,561,562,563,567,564,565,579,598,599,600,602,603,604,605,606,607,608,609,610,611,601,612,613,614,615,616,617,618,619,620,621,664,639,638,641,642,668,643,644,667,645,646,647,648,649,650,651,662,640,652,653,654,665,656,661,666,655,657,658,659,660)
ORDER BY a.ordering ASC
363μs2.67KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (476,486,513,520,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,579,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,664,665,666,667,668,670,676,677,678,679,680,681,682,683,684,685,686,687,688,689,690,691,692,693,694,695) AND `reference_table`= 'sr_facilities'
1.1ms688B/plugins/system/falangdriver/falang_database.php:325CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 33 AND field_key LIKE 'roomtype_custom_fields.%'
94μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '35'
49μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT t.*, cgroup.name as customer_group_name
FROM `ma37e_sr_tariffs` AS t
LEFT JOIN `ma37e_sr_customer_groups` as cgroup ON cgroup.id = t.customer_group_id
WHERE t.room_type_id = 35 AND t.customer_group_id IS NULL AND t.state = 1 AND t.valid_from != '0000-00-00' AND t.valid_to != '0000-00-00' AND t.valid_to > CURDATE()
ORDER BY t.ordering asc
199μs14.08KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '121'
67μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT t.id, t.tariff_id, ROUND(t.price, 0) AS price, ROUND(t.price_extras, 0) AS price_extras, ROUND(t.price_unoccupied, 0) AS price_unoccupied, t.w_day, t.guest_type, t.from_age, t.to_age, t.date, t.min_los, t.max_los, t.d_interval, t.limit_checkin, t.week_from, t.week_to
FROM `ma37e_sr_tariff_details` AS t
WHERE t.tariff_id = 121
ORDER BY t.date ASC
317μs4.64KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '122'
86μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT t.id, t.tariff_id, ROUND(t.price, 0) AS price, ROUND(t.price_extras, 0) AS price_extras, ROUND(t.price_unoccupied, 0) AS price_unoccupied, t.w_day, t.guest_type, t.from_age, t.to_age, t.date, t.min_los, t.max_los, t.d_interval, t.limit_checkin, t.week_from, t.week_to
FROM `ma37e_sr_tariff_details` AS t
WHERE t.tariff_id = 122
ORDER BY t.date ASC
443μs4.64KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '123'
131μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT t.id, t.tariff_id, ROUND(t.price, 0) AS price, ROUND(t.price_extras, 0) AS price_extras, ROUND(t.price_unoccupied, 0) AS price_unoccupied, t.w_day, t.guest_type, t.from_age, t.to_age, t.date, t.min_los, t.max_los, t.d_interval, t.limit_checkin, t.week_from, t.week_to
FROM `ma37e_sr_tariff_details` AS t
WHERE t.tariff_id = 123
ORDER BY t.date ASC
456μs4.64KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '125'
207μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT t.id, t.tariff_id, ROUND(t.price, 0) AS price, ROUND(t.price_extras, 0) AS price_extras, ROUND(t.price_unoccupied, 0) AS price_unoccupied, t.w_day, t.guest_type, t.from_age, t.to_age, t.date, t.min_los, t.max_los, t.d_interval, t.limit_checkin, t.week_from, t.week_to
FROM `ma37e_sr_tariff_details` AS t
WHERE t.tariff_id = 125
ORDER BY t.date ASC
284μs2.89KB/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 35 AND (field_key LIKE 'myallocator.%' OR field_key LIKE 'beds24.%')
172μs640B/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 35
217μs2.51KB/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 35 AND field_key LIKE 'roomtype_custom_fields.%'
260μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT data_key, data_value
FROM `ma37e_sr_config_data`
WHERE scope_id = 17
777μs2.31KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 17
276μs3.51KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.title, a.description, a.icon
FROM `ma37e_sr_facilities` AS `a`
WHERE a.id IN (70,88,451,457,460,395,67,119,148,151,154,150,152,146,155,145,142,147,157,158,143,141,144,149,153,156,170,168,172,173,171,161,166,175,176,179,178,189,183,180,190,192,188,193,185,194,186,195,187,191,182,184,177,181,210,207,212,204,211,214,206,218,220,205,219,221,209,203,215,213,217,216,237,238,235,234,231,236,233,242,247,239,245,243,258,272,270,244,275,273,274,256,252,250,254,259,262,264,281,271,268,257,253,251,255,260,261,280,269,276,266,277,240,263,246,249,241,248,265,278,279,267,297,305,307,328,324,317,303,308,313,312,319,318,315,323,314,309,329,302,300,298,327,301,322,321,310,316,320,325,326,311,299,304,306,339,338,337,340,341,342,348,366,357,367,362,350,353,361,351,359,354,358,355,352,364,356,365,368,349,363,360,369,385,382,383,384,381,386,380,396)
ORDER BY a.ordering ASC
442μs3.67KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (67,70,88,119,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,161,166,168,170,171,172,173,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,203,204,205,206,207,209,210,211,212,213,214,215,216,217,218,219,220,221,231,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,337,338,339,340,341,342,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,380,381,382,383,384,385,386,395,396,451,457,460) AND `reference_table`= 'sr_facilities'
1.23ms688B/plugins/system/falangdriver/falang_database.php:325CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 17
58μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 17
40μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_reservation_asset_fields`
WHERE reservation_asset_id = 17 AND field_key LIKE 'reservationasset_extra_fields.%'
299μs960B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '18'
162μs21.88KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (18) AND `reference_table`= 'sr_reservation_assets'
133μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `t`.`id`
FROM `ma37e_tags` AS `t`
INNER JOIN `ma37e_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
125μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `t`.`id`
FROM `ma37e_tags` AS `t`
INNER JOIN `ma37e_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
82μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_geo_states`
WHERE `id` = '523'
64μs832B/plugins/system/falangdriver/falang_database.php:330CopySELECT r.*, asset.name AS reservationasset,(SELECT COUNT(id) FROM ma37e_sr_rooms AS room WHERE room.room_type_id = r.id ) as number_of_room, (SELECT COUNT(id) FROM ma37e_sr_tariffs as tariff
WHERE tariff.room_type_id = r.id
AND tariff.valid_from <> '0000-00-0 00:00:00' AND tariff.valid_from <> '0000-00-0 00:00:00' ) as number_of_tariff,uc.name AS editor,f.field_value as channel_room_id
FROM `ma37e_sr_room_types` AS r
LEFT JOIN `ma37e_users` AS uc ON uc.id= r.checked_out
LEFT JOIN `ma37e_sr_reservation_assets` AS asset ON asset.id = r.reservation_asset_id
LEFT JOIN `ma37e_sr_room_type_fields` AS f ON f.room_type_id = r.id AND f.field_key = 'beds24.roomId'
WHERE r.state = 1 AND r.reservation_asset_id = 18
GROUP BY asset.name,uc.name,r.id
ORDER BY r.ordering ASC
320μs3.06KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (34) AND `reference_table`= 'sr_room_types'
102μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (34) AND `reference_table`= 'sr_reservation_assets'
100μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT *
FROM `ma37e_sr_customers`
WHERE `id` = '43'
83μs2.5KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_users`
WHERE `id` = :userid
96μs3.16KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `g`.`id`,`g`.`title`
FROM `ma37e_usergroups` AS `g`
INNER JOIN `ma37e_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id`
WHERE `m`.`user_id` = :muserid
169μs1.38KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '18'
87μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT a.*, asset.name as reservationasset
FROM `ma37e_sr_discounts` AS a
LEFT JOIN `ma37e_sr_reservation_assets` AS asset ON asset.id = a.reservation_asset_id
WHERE a.scope = 0 AND a.state = 1 AND a.reservation_asset_id = 18 AND a.type IN (0,2,3,8,9)
ORDER BY a.title ASC
149μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.title, a.state, a.percentage, a.value, a.user_groups, a.scope, a.created, a.created_by, a.type
FROM `ma37e_sr_commission_rates` AS `a`
WHERE a.state = 1 AND a.scope = 0 AND a.type = 1
ORDER BY a.id desc
79μs1.33KB/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT ug.id
FROM `ma37e_usergroups` AS `ug`
INNER JOIN `ma37e_user_usergroup_map` AS `um` ON ug.id = um.group_id
INNER JOIN `ma37e_sr_customers` AS `a` ON a.user_id = um.user_id
WHERE a.id = 43
104μs552B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '34'
44μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT t.*, cgroup.name as customer_group_name
FROM `ma37e_sr_tariffs` AS t
LEFT JOIN `ma37e_sr_customer_groups` as cgroup ON cgroup.id = t.customer_group_id
WHERE t.room_type_id = 34 AND t.customer_group_id IS NULL AND t.state = 1 AND t.valid_from != '0000-00-00' AND t.valid_to != '0000-00-00' AND t.valid_to > CURDATE()
ORDER BY t.ordering asc
222μs3.09KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '110'
90μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT t.id, t.tariff_id, ROUND(t.price, 0) AS price, ROUND(t.price_extras, 0) AS price_extras, ROUND(t.price_unoccupied, 0) AS price_unoccupied, t.w_day, t.guest_type, t.from_age, t.to_age, t.date, t.min_los, t.max_los, t.d_interval, t.limit_checkin, t.week_from, t.week_to
FROM `ma37e_sr_tariff_details` AS t
WHERE t.tariff_id = 110
ORDER BY t.date ASC
923μs4.64KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '111'
340μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT t.id, t.tariff_id, ROUND(t.price, 0) AS price, ROUND(t.price_extras, 0) AS price_extras, ROUND(t.price_unoccupied, 0) AS price_unoccupied, t.w_day, t.guest_type, t.from_age, t.to_age, t.date, t.min_los, t.max_los, t.d_interval, t.limit_checkin, t.week_from, t.week_to
FROM `ma37e_sr_tariff_details` AS t
WHERE t.tariff_id = 111
ORDER BY t.date ASC
610μs4.64KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '112'
170μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT t.id, t.tariff_id, ROUND(t.price, 0) AS price, ROUND(t.price_extras, 0) AS price_extras, ROUND(t.price_unoccupied, 0) AS price_unoccupied, t.w_day, t.guest_type, t.from_age, t.to_age, t.date, t.min_los, t.max_los, t.d_interval, t.limit_checkin, t.week_from, t.week_to
FROM `ma37e_sr_tariff_details` AS t
WHERE t.tariff_id = 112
ORDER BY t.date ASC
548μs4.64KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '113'
111μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT t.id, t.tariff_id, ROUND(t.price, 0) AS price, ROUND(t.price_extras, 0) AS price_extras, ROUND(t.price_unoccupied, 0) AS price_unoccupied, t.w_day, t.guest_type, t.from_age, t.to_age, t.date, t.min_los, t.max_los, t.d_interval, t.limit_checkin, t.week_from, t.week_to
FROM `ma37e_sr_tariff_details` AS t
WHERE t.tariff_id = 113
ORDER BY t.date ASC
441μs4.64KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '114'
97μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT t.id, t.tariff_id, ROUND(t.price, 0) AS price, ROUND(t.price_extras, 0) AS price_extras, ROUND(t.price_unoccupied, 0) AS price_unoccupied, t.w_day, t.guest_type, t.from_age, t.to_age, t.date, t.min_los, t.max_los, t.d_interval, t.limit_checkin, t.week_from, t.week_to
FROM `ma37e_sr_tariff_details` AS t
WHERE t.tariff_id = 114
ORDER BY t.date ASC
228μs2.89KB/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 34 AND (field_key LIKE 'myallocator.%' OR field_key LIKE 'beds24.%')
161μs640B/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 34
85μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 34 AND field_key LIKE 'roomtype_custom_fields.%'
120μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT data_key, data_value
FROM `ma37e_sr_config_data`
WHERE scope_id = 18
744μs1.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 18
289μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 18
483μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 18
128μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_reservation_asset_fields`
WHERE reservation_asset_id = 18 AND field_key LIKE 'reservationasset_extra_fields.%'
570μs960B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '14'
418μs21.88KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (14) AND `reference_table`= 'sr_reservation_assets'
215μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `t`.`id`
FROM `ma37e_tags` AS `t`
INNER JOIN `ma37e_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
240μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `t`.`id`
FROM `ma37e_tags` AS `t`
INNER JOIN `ma37e_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
100μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_geo_states`
WHERE `id` = '523'
81μs832B/plugins/system/falangdriver/falang_database.php:330CopySELECT r.*, asset.name AS reservationasset,(SELECT COUNT(id) FROM ma37e_sr_rooms AS room WHERE room.room_type_id = r.id ) as number_of_room, (SELECT COUNT(id) FROM ma37e_sr_tariffs as tariff
WHERE tariff.room_type_id = r.id
AND tariff.valid_from <> '0000-00-0 00:00:00' AND tariff.valid_from <> '0000-00-0 00:00:00' ) as number_of_tariff,uc.name AS editor,f.field_value as channel_room_id
FROM `ma37e_sr_room_types` AS r
LEFT JOIN `ma37e_users` AS uc ON uc.id= r.checked_out
LEFT JOIN `ma37e_sr_reservation_assets` AS asset ON asset.id = r.reservation_asset_id
LEFT JOIN `ma37e_sr_room_type_fields` AS f ON f.room_type_id = r.id AND f.field_key = 'beds24.roomId'
WHERE r.state = 1 AND r.reservation_asset_id = 14
GROUP BY asset.name,uc.name,r.id
ORDER BY r.ordering ASC
389μs3.06KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (30) AND `reference_table`= 'sr_room_types'
163μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (30) AND `reference_table`= 'sr_reservation_assets'
95μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '14'
69μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT a.*, asset.name as reservationasset
FROM `ma37e_sr_discounts` AS a
LEFT JOIN `ma37e_sr_reservation_assets` AS asset ON asset.id = a.reservation_asset_id
WHERE a.scope = 0 AND a.state = 1 AND a.reservation_asset_id = 14 AND a.type IN (0,2,3,8,9)
ORDER BY a.title ASC
190μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.title, a.state, a.percentage, a.value, a.user_groups, a.scope, a.created, a.created_by, a.type
FROM `ma37e_sr_commission_rates` AS `a`
WHERE a.state = 1 AND a.scope = 0 AND a.type = 1
ORDER BY a.id desc
107μs9.33KB/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT ug.id
FROM `ma37e_usergroups` AS `ug`
INNER JOIN `ma37e_user_usergroup_map` AS `um` ON ug.id = um.group_id
INNER JOIN `ma37e_sr_customers` AS `a` ON a.user_id = um.user_id
WHERE a.id = 0
72μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '30'
55μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT t.*, cgroup.name as customer_group_name
FROM `ma37e_sr_tariffs` AS t
LEFT JOIN `ma37e_sr_customer_groups` as cgroup ON cgroup.id = t.customer_group_id
WHERE t.room_type_id = 30 AND t.customer_group_id IS NULL AND t.state = 1 AND t.valid_from != '0000-00-00' AND t.valid_to != '0000-00-00' AND t.valid_to > CURDATE()
ORDER BY t.ordering asc
131μs3.02KB/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 30 AND (field_key LIKE 'myallocator.%' OR field_key LIKE 'beds24.%')
97μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 30
47μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 30 AND field_key LIKE 'roomtype_custom_fields.%'
70μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT data_key, data_value
FROM `ma37e_sr_config_data`
WHERE scope_id = 14
562μs2.31KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 14
72μs680B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.title, a.description, a.icon
FROM `ma37e_sr_facilities` AS `a`
WHERE a.id IN (70,75,87,66,119,148,151,150,146,149)
ORDER BY a.ordering ASC
93μs848B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (66,70,75,87,119,146,148,149,150,151) AND `reference_table`= 'sr_facilities'
151μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 14
51μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 14
52μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_reservation_asset_fields`
WHERE reservation_asset_id = 14 AND field_key LIKE 'reservationasset_extra_fields.%'
195μs960B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '15'
115μs21.88KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (15) AND `reference_table`= 'sr_reservation_assets'
96μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `t`.`id`
FROM `ma37e_tags` AS `t`
INNER JOIN `ma37e_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
106μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `t`.`id`
FROM `ma37e_tags` AS `t`
INNER JOIN `ma37e_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
136μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_geo_states`
WHERE `id` = '523'
57μs832B/plugins/system/falangdriver/falang_database.php:330CopySELECT r.*, asset.name AS reservationasset,(SELECT COUNT(id) FROM ma37e_sr_rooms AS room WHERE room.room_type_id = r.id ) as number_of_room, (SELECT COUNT(id) FROM ma37e_sr_tariffs as tariff
WHERE tariff.room_type_id = r.id
AND tariff.valid_from <> '0000-00-0 00:00:00' AND tariff.valid_from <> '0000-00-0 00:00:00' ) as number_of_tariff,uc.name AS editor,f.field_value as channel_room_id
FROM `ma37e_sr_room_types` AS r
LEFT JOIN `ma37e_users` AS uc ON uc.id= r.checked_out
LEFT JOIN `ma37e_sr_reservation_assets` AS asset ON asset.id = r.reservation_asset_id
LEFT JOIN `ma37e_sr_room_type_fields` AS f ON f.room_type_id = r.id AND f.field_key = 'beds24.roomId'
WHERE r.state = 1 AND r.reservation_asset_id = 15
GROUP BY asset.name,uc.name,r.id
ORDER BY r.ordering ASC
230μs3.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '15'
58μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT a.*, asset.name as reservationasset
FROM `ma37e_sr_discounts` AS a
LEFT JOIN `ma37e_sr_reservation_assets` AS asset ON asset.id = a.reservation_asset_id
WHERE a.scope = 0 AND a.state = 1 AND a.reservation_asset_id = 15 AND a.type IN (0,2,3,8,9)
ORDER BY a.title ASC
152μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.title, a.state, a.percentage, a.value, a.user_groups, a.scope, a.created, a.created_by, a.type
FROM `ma37e_sr_commission_rates` AS `a`
WHERE a.state = 1 AND a.scope = 0 AND a.type = 1
ORDER BY a.id desc
92μs1.33KB/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT ug.id
FROM `ma37e_usergroups` AS `ug`
INNER JOIN `ma37e_user_usergroup_map` AS `um` ON ug.id = um.group_id
INNER JOIN `ma37e_sr_customers` AS `a` ON a.user_id = um.user_id
WHERE a.id = 0
68μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT data_key, data_value
FROM `ma37e_sr_config_data`
WHERE scope_id = 15
769μs2.31KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 15
78μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 15
183μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 15
70μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_reservation_asset_fields`
WHERE reservation_asset_id = 15 AND field_key LIKE 'reservationasset_extra_fields.%'
274μs960B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '16'
215μs21.88KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (16) AND `reference_table`= 'sr_reservation_assets'
114μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `t`.`id`
FROM `ma37e_tags` AS `t`
INNER JOIN `ma37e_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
142μs1.34KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `t`.`id`
FROM `ma37e_tags` AS `t`
INNER JOIN `ma37e_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
71μs1.34KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_geo_states`
WHERE `id` = '523'
67μs832B/plugins/system/falangdriver/falang_database.php:330CopySELECT r.*, asset.name AS reservationasset,(SELECT COUNT(id) FROM ma37e_sr_rooms AS room WHERE room.room_type_id = r.id ) as number_of_room, (SELECT COUNT(id) FROM ma37e_sr_tariffs as tariff
WHERE tariff.room_type_id = r.id
AND tariff.valid_from <> '0000-00-0 00:00:00' AND tariff.valid_from <> '0000-00-0 00:00:00' ) as number_of_tariff,uc.name AS editor,f.field_value as channel_room_id
FROM `ma37e_sr_room_types` AS r
LEFT JOIN `ma37e_users` AS uc ON uc.id= r.checked_out
LEFT JOIN `ma37e_sr_reservation_assets` AS asset ON asset.id = r.reservation_asset_id
LEFT JOIN `ma37e_sr_room_type_fields` AS f ON f.room_type_id = r.id AND f.field_key = 'beds24.roomId'
WHERE r.state = 1 AND r.reservation_asset_id = 16
GROUP BY asset.name,uc.name,r.id
ORDER BY r.ordering ASC
377μs3.08KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (31,32) AND `reference_table`= 'sr_room_types'
153μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (31,32) AND `reference_table`= 'sr_reservation_assets'
89μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT *
FROM `ma37e_sr_customers`
WHERE `id` = '42'
81μs2.5KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_users`
WHERE `id` = :userid
68μs3.16KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `g`.`id`,`g`.`title`
FROM `ma37e_usergroups` AS `g`
INNER JOIN `ma37e_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id`
WHERE `m`.`user_id` = :muserid
98μs1.38KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '16'
41μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT a.*, asset.name as reservationasset
FROM `ma37e_sr_discounts` AS a
LEFT JOIN `ma37e_sr_reservation_assets` AS asset ON asset.id = a.reservation_asset_id
WHERE a.scope = 0 AND a.state = 1 AND a.reservation_asset_id = 16 AND a.type IN (0,2,3,8,9)
ORDER BY a.title ASC
108μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.title, a.state, a.percentage, a.value, a.user_groups, a.scope, a.created, a.created_by, a.type
FROM `ma37e_sr_commission_rates` AS `a`
WHERE a.state = 1 AND a.scope = 0 AND a.type = 1
ORDER BY a.id desc
79μs1.33KB/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT ug.id
FROM `ma37e_usergroups` AS `ug`
INNER JOIN `ma37e_user_usergroup_map` AS `um` ON ug.id = um.group_id
INNER JOIN `ma37e_sr_customers` AS `a` ON a.user_id = um.user_id
WHERE a.id = 42
98μs552B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '31'
67μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT t.*, cgroup.name as customer_group_name
FROM `ma37e_sr_tariffs` AS t
LEFT JOIN `ma37e_sr_customer_groups` as cgroup ON cgroup.id = t.customer_group_id
WHERE t.room_type_id = 31 AND t.customer_group_id IS NULL AND t.state = 1 AND t.valid_from != '0000-00-00' AND t.valid_to != '0000-00-00' AND t.valid_to > CURDATE()
ORDER BY t.ordering asc
130μs3.02KB/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 31 AND (field_key LIKE 'myallocator.%' OR field_key LIKE 'beds24.%')
93μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 31
65μs584B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.title, a.description, a.icon
FROM `ma37e_sr_facilities` AS `a`
WHERE a.id IN (40,32,37,23)
ORDER BY a.ordering ASC
71μs752B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (23,32,37,40) AND `reference_table`= 'sr_facilities'
101μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 31 AND field_key LIKE 'roomtype_custom_fields.%'
76μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '32'
43μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT t.*, cgroup.name as customer_group_name
FROM `ma37e_sr_tariffs` AS t
LEFT JOIN `ma37e_sr_customer_groups` as cgroup ON cgroup.id = t.customer_group_id
WHERE t.room_type_id = 32 AND t.customer_group_id IS NULL AND t.state = 1 AND t.valid_from != '0000-00-00' AND t.valid_to != '0000-00-00' AND t.valid_to > CURDATE()
ORDER BY t.ordering asc
128μs3.02KB/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 32 AND (field_key LIKE 'myallocator.%' OR field_key LIKE 'beds24.%')
120μs640B/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 32
55μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 32 AND field_key LIKE 'roomtype_custom_fields.%'
85μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT data_key, data_value
FROM `ma37e_sr_config_data`
WHERE scope_id = 16
673μs2.31KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 16
113μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 16
84μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 16
70μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_reservation_asset_fields`
WHERE reservation_asset_id = 16 AND field_key LIKE 'reservationasset_extra_fields.%'
261μs960B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id,cat.title AS category_name,parent.title AS parent_category_title, parent.id AS parent_category_id,
parent.created_user_id AS parent_category_uid, parent.level AS parent_category_level,COUNT(rt.id) AS number_of_roomtype,cou.name AS country_name,geostate.name AS geostate_name,uc.name AS editor,ag.title AS access_level
FROM `ma37e_sr_reservation_assets` AS a
LEFT JOIN `ma37e_categories` AS cat ON cat.id = a.category_id
LEFT JOIN `ma37e_categories` AS parent ON parent.id = cat.parent_id
LEFT JOIN `ma37e_sr_room_types` AS rt ON rt.reservation_asset_id = a.id
LEFT JOIN `ma37e_sr_countries` AS cou ON cou.id = a.country_id
LEFT JOIN `ma37e_sr_geo_states` AS geostate ON geostate.id = a.geo_state_id
LEFT JOIN `ma37e_users` AS uc ON uc.id=a.checked_out
LEFT JOIN `ma37e_viewlevels` AS ag ON ag.id = a.access
WHERE a.state = 1 AND a.country_id = 3
GROUP BY cat.title,parent.title,cou.name,geostate.name,uc.name,ag.title,a.id
ORDER BY a.rating asc
403μs1.5KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (17,18,14,15,16) AND `reference_table`= 'sr_reservation_assets'
194μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT r.id, r.name, r.scope
FROM `ma37e_sr_feedback_attributes` AS `r`
WHERE r.scope = 0
ORDER BY r.id desc
81μs688B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a3.name AS target_name
FROM `ma37e_sr_feedbacks` AS `a`
LEFT JOIN `ma37e_sr_reservations` AS `a2` ON a2.id = a.reservation_id
LEFT JOIN `ma37e_sr_reservation_assets` AS `a3` ON a3.id = a2.reservation_asset_id
WHERE (a.reservation_id > 0 OR a.item_id > 0) AND a.scope = 0 AND (a3.id = 17 OR a.item_id = 17) AND a.state = 1
GROUP BY a.id
ORDER BY a.id DESC LIMIT 3
246μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.*
FROM `ma37e_sr_reservations` AS `a`
WHERE a.reservation_asset_id = 17 AND a.state = 0
143μs9.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.field
FROM `ma37e_sr_feedback_conditions` AS `a`
WHERE a.scope = 0
68μs704B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Cleanliness' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 8 AND (a3.reservation_asset_id = 17 OR a2.item_id = 17)
282μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Comfort' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 9 AND (a3.reservation_asset_id = 17 OR a2.item_id = 17)
279μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Location' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 10 AND (a3.reservation_asset_id = 17 OR a2.item_id = 17)
259μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Facilities' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 11 AND (a3.reservation_asset_id = 17 OR a2.item_id = 17)
226μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Staff' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 12 AND (a3.reservation_asset_id = 17 OR a2.item_id = 17)
221μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Value for money' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 13 AND (a3.reservation_asset_id = 17 OR a2.item_id = 17)
183μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Free WiFi' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 14 AND (a3.reservation_asset_id = 17 OR a2.item_id = 17)
213μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT count(a.field_id)
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.scope = 0 AND a2.state = 1 AND (a3.reservation_asset_id = 17 OR a2.item_id = 17)
GROUP BY a.field_id
122μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a3.name AS target_name
FROM `ma37e_sr_feedbacks` AS `a`
LEFT JOIN `ma37e_sr_reservations` AS `a2` ON a2.id = a.reservation_id
LEFT JOIN `ma37e_sr_reservation_assets` AS `a3` ON a3.id = a2.reservation_asset_id
WHERE (a.reservation_id > 0 OR a.item_id > 0) AND a.scope = 0 AND (a3.id = 18 OR a.item_id = 18) AND a.state = 1
GROUP BY a.id
ORDER BY a.id DESC LIMIT 3
228μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (65) AND `reference_table`= 'sr_reservation_assets'
114μs688B/plugins/system/falangdriver/falang_database.php:325CopySHOW FULL COLUMNS FROM `ma37e_sr_feedbacks`
459μs1.52KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '65'
83μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_reservations`
730μs2.52KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '42'
275μs9.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '1208440150bfce74e162752c49817cb0' AND `published` = '1'
224μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'd2b0c14188dfaea6ad951378c59dbc65' AND `published` = '1'
138μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.context, a.value, a.storage
FROM `ma37e_sr_customfield_values` AS `a`
WHERE `context` = 'com_solidres.customer.42'
467μs944B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.title
FROM `ma37e_sr_customfields` AS `a`
WHERE a.state = 1 AND (a.access IS NULL OR a.access < 1 OR a.access IN (1,5))
171μs1.44KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.name
FROM `ma37e_sr_countries` AS `a`
WHERE a.id = 3
69μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.name
FROM `ma37e_sr_geo_states` AS `a`
WHERE a.id = 0
37μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `name` = 'Albania'
230μs1.47KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.name, a.email AS owner_email, a.params, a2.code AS reservation_code
FROM `ma37e_sr_reservation_assets` AS `a`
LEFT JOIN `ma37e_sr_reservations` AS `a2` ON a2.reservation_asset_id = a.id
WHERE a2.id = 42
96μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (18) AND `reference_table`= 'sr_reservation_assets'
105μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '52f08b1290452e48f79fb979d6aa6dae' AND `published` = '1'
126μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'dd14b4aa631bb7ef19f5689b9fa06c7c' AND `published` = '1'
68μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.field
FROM `ma37e_sr_feedback_conditions` AS `a`
WHERE a.scope = 0
ORDER BY a.ordering ASC
72μs704B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
WHERE a.feedback_id = 65 AND a.field_id = 8
117μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
WHERE a.feedback_id = 65 AND a.field_id = 9
94μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
WHERE a.feedback_id = 65 AND a.field_id = 10
92μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
WHERE a.feedback_id = 65 AND a.field_id = 11
123μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
WHERE a.feedback_id = 65 AND a.field_id = 12
70μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
WHERE a.feedback_id = 65 AND a.field_id = 13
62μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
WHERE a.feedback_id = 65 AND a.field_id = 14
73μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT a.id, a.name
FROM `ma37e_sr_feedback_attributes` AS `a`
INNER JOIN `ma37e_sr_feedback_attribute_values` AS `a2` ON a2.attribute_id = a.id
INNER JOIN `ma37e_sr_feedback_attribute_xref` AS `a3` ON a3.feedback_attribute_value_id = a2.id
WHERE a3.feedback_id = 65 AND a.scope = 0
128μs624B/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT a.id, a.name
FROM `ma37e_sr_feedback_attribute_values` AS `a`
INNER JOIN `ma37e_sr_feedback_attribute_xref` AS `a2` ON a2.feedback_attribute_value_id = a.id
WHERE a.attribute_id = 11 AND a2.feedback_id = 65
74μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT a.id, a.name
FROM `ma37e_sr_feedback_attribute_values` AS `a`
INNER JOIN `ma37e_sr_feedback_attribute_xref` AS `a2` ON a2.feedback_attribute_value_id = a.id
WHERE a.attribute_id = 12 AND a2.feedback_id = 65
78μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT a.id, a.name
FROM `ma37e_sr_feedback_attribute_values` AS `a`
INNER JOIN `ma37e_sr_feedback_attribute_xref` AS `a2` ON a2.feedback_attribute_value_id = a.id
WHERE a.attribute_id = 13 AND a2.feedback_id = 65
88μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.*
FROM `ma37e_sr_reservations` AS `a`
WHERE a.reservation_asset_id = 18 AND a.state = 0
163μs9.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Cleanliness' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 8 AND (a3.reservation_asset_id = 18 OR a2.item_id = 18)
719μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Comfort' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 9 AND (a3.reservation_asset_id = 18 OR a2.item_id = 18)
675μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Location' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 10 AND (a3.reservation_asset_id = 18 OR a2.item_id = 18)
412μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Facilities' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 11 AND (a3.reservation_asset_id = 18 OR a2.item_id = 18)
374μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Staff' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 12 AND (a3.reservation_asset_id = 18 OR a2.item_id = 18)
388μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Value for money' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 13 AND (a3.reservation_asset_id = 18 OR a2.item_id = 18)
377μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Free WiFi' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 14 AND (a3.reservation_asset_id = 18 OR a2.item_id = 18)
377μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT count(a.field_id)
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.scope = 0 AND a2.state = 1 AND (a3.reservation_asset_id = 18 OR a2.item_id = 18)
GROUP BY a.field_id
202μs648B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a3.name AS target_name
FROM `ma37e_sr_feedbacks` AS `a`
LEFT JOIN `ma37e_sr_reservations` AS `a2` ON a2.id = a.reservation_id
LEFT JOIN `ma37e_sr_reservation_assets` AS `a3` ON a3.id = a2.reservation_asset_id
WHERE (a.reservation_id > 0 OR a.item_id > 0) AND a.scope = 0 AND (a3.id = 18 OR a.item_id = 18) AND a.state = 1
GROUP BY a.id
285μs592B/plugins/system/falangdriver/falang_database.php:133CopySELECT a.id, a3.name AS target_name
FROM `ma37e_sr_feedbacks` AS `a`
LEFT JOIN `ma37e_sr_reservations` AS `a2` ON a2.id = a.reservation_id
LEFT JOIN `ma37e_sr_reservation_assets` AS `a3` ON a3.id = a2.reservation_asset_id
WHERE (a.reservation_id > 0 OR a.item_id > 0) AND a.scope = 0 AND (a3.id = 14 OR a.item_id = 14) AND a.state = 1
GROUP BY a.id
ORDER BY a.id DESC LIMIT 3
403μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.*
FROM `ma37e_sr_reservations` AS `a`
WHERE a.reservation_asset_id = 14 AND a.state = 0
267μs9.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Cleanliness' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 8 AND (a3.reservation_asset_id = 14 OR a2.item_id = 14)
525μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Comfort' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 9 AND (a3.reservation_asset_id = 14 OR a2.item_id = 14)
339μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Location' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 10 AND (a3.reservation_asset_id = 14 OR a2.item_id = 14)
299μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Facilities' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 11 AND (a3.reservation_asset_id = 14 OR a2.item_id = 14)
322μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Staff' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 12 AND (a3.reservation_asset_id = 14 OR a2.item_id = 14)
286μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Value for money' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 13 AND (a3.reservation_asset_id = 14 OR a2.item_id = 14)
225μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Free WiFi' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 14 AND (a3.reservation_asset_id = 14 OR a2.item_id = 14)
207μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT count(a.field_id)
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.scope = 0 AND a2.state = 1 AND (a3.reservation_asset_id = 14 OR a2.item_id = 14)
GROUP BY a.field_id
157μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a3.name AS target_name
FROM `ma37e_sr_feedbacks` AS `a`
LEFT JOIN `ma37e_sr_reservations` AS `a2` ON a2.id = a.reservation_id
LEFT JOIN `ma37e_sr_reservation_assets` AS `a3` ON a3.id = a2.reservation_asset_id
WHERE (a.reservation_id > 0 OR a.item_id > 0) AND a.scope = 0 AND (a3.id = 15 OR a.item_id = 15) AND a.state = 1
GROUP BY a.id
ORDER BY a.id DESC LIMIT 3
187μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.*
FROM `ma37e_sr_reservations` AS `a`
WHERE a.reservation_asset_id = 15 AND a.state = 0
227μs9.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Cleanliness' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 8 AND (a3.reservation_asset_id = 15 OR a2.item_id = 15)
350μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Comfort' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 9 AND (a3.reservation_asset_id = 15 OR a2.item_id = 15)
307μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Location' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 10 AND (a3.reservation_asset_id = 15 OR a2.item_id = 15)
290μs16.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Facilities' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 11 AND (a3.reservation_asset_id = 15 OR a2.item_id = 15)
238μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Staff' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 12 AND (a3.reservation_asset_id = 15 OR a2.item_id = 15)
360μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Value for money' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 13 AND (a3.reservation_asset_id = 15 OR a2.item_id = 15)
313μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Free WiFi' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 14 AND (a3.reservation_asset_id = 15 OR a2.item_id = 15)
288μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT count(a.field_id)
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.scope = 0 AND a2.state = 1 AND (a3.reservation_asset_id = 15 OR a2.item_id = 15)
GROUP BY a.field_id
140μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a3.name AS target_name
FROM `ma37e_sr_feedbacks` AS `a`
LEFT JOIN `ma37e_sr_reservations` AS `a2` ON a2.id = a.reservation_id
LEFT JOIN `ma37e_sr_reservation_assets` AS `a3` ON a3.id = a2.reservation_asset_id
WHERE (a.reservation_id > 0 OR a.item_id > 0) AND a.scope = 0 AND (a3.id = 16 OR a.item_id = 16) AND a.state = 1
GROUP BY a.id
ORDER BY a.id DESC LIMIT 3
170μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.*
FROM `ma37e_sr_reservations` AS `a`
WHERE a.reservation_asset_id = 16 AND a.state = 0
226μs9.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Cleanliness' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 8 AND (a3.reservation_asset_id = 16 OR a2.item_id = 16)
440μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Comfort' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 9 AND (a3.reservation_asset_id = 16 OR a2.item_id = 16)
268μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Location' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 10 AND (a3.reservation_asset_id = 16 OR a2.item_id = 16)
323μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Facilities' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 11 AND (a3.reservation_asset_id = 16 OR a2.item_id = 16)
283μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Staff' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 12 AND (a3.reservation_asset_id = 16 OR a2.item_id = 16)
279μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Value for money' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 13 AND (a3.reservation_asset_id = 16 OR a2.item_id = 16)
377μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Free WiFi' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 14 AND (a3.reservation_asset_id = 16 OR a2.item_id = 16)
285μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT count(a.field_id)
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.scope = 0 AND a2.state = 1 AND (a3.reservation_asset_id = 16 OR a2.item_id = 16)
GROUP BY a.field_id
189μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '276af090d64a74af5921370edc92d496' AND `published` = '1'
181μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'c03601b8f84f554a69f443a2954778aa' AND `published` = '1'
143μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'd7ece6494e9a51ab52039e988900e084' AND `published` = '1'
73μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `id`
FROM `ma37e_sr_room_types`
WHERE `state` = 1 AND `reservation_asset_id` = :assetId
162μs1.33KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (33,35) AND `reference_table`= 'sr_room_types'
121μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '2da66c9d2918a007231ebf1a096b8662' AND `published` = '1'
102μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'e629842122d6578ef715ba9b44cc1716' AND `published` = '1'
96μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '024b20cfdcde3c760d1b411a5cc6ea3b' AND `published` = '1'
85μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `id`
FROM `ma37e_sr_room_types`
WHERE `state` = 1 AND `reservation_asset_id` = :assetId
154μs1.31KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (34) AND `reference_table`= 'sr_room_types'
119μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'cd114380581b4facecb2fe8d44cf19e3' AND `published` = '1'
101μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '913573b99926c2f28ee8a7f52847db32' AND `published` = '1'
74μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '36c62810fa35859d1107b444b5fc143a' AND `published` = '1'
68μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'c76c0cded0de82c00dfc7d366c774094' AND `published` = '1'
205μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '203dd95ff0ee2386b0779390f9637005' AND `published` = '1'
117μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'b1b696546f04b1571f082cbe63ace483' AND `published` = '1'
67μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `alias`
FROM `ma37e_sr_reservation_assets`
WHERE `id` = :id
185μs1.31KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '0aac547892fcbc804c3ce92da26e9655' AND `published` = '1'
76μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '93603572459d97a09bb8f82bf632e26c' AND `published` = '1'
61μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'a29f57201dcb56e057a927b79811bd14' AND `published` = '1'
58μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '6dfd38b3189a83f901691b86b821c0b0' AND `published` = '1'
94μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '5e406f891a53bb105f4180349335ba6e' AND `published` = '1'
73μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '846600c3c32a3c0c01f38b129755086f' AND `published` = '1'
72μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'c8fdc0cdf4fc85f7bbb19361a5f1f0da' AND `published` = '1'
77μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `language`,`id`
FROM `ma37e_menu`
WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0
403μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1395) AND `reference_table`= 'menu'
213μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `c2`.`language`,`c2`.`id`
FROM `ma37e_menu` AS `c`
INNER JOIN `ma37e_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context
INNER JOIN `ma37e_associations` AS `a2` ON `a`.`key` = `a2`.`key`
INNER JOIN `ma37e_menu` AS `c2` ON `a2`.`id` = `c2`.`id`
WHERE `c`.`id` = :id
173μs1.41KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1367,1386) AND `reference_table`= 'menu'
133μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `url` = 'hotels-test?country_id=3&default_search_ordering=0&mode=list' AND `published` = '1'
132ms536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `id`
FROM `ma37e_rsseo_pages`
WHERE (`url` = 'hotels-test?country_id=3&default_search_ordering=0&mode=list' OR `sef` = 'hotels-test?country_id=3&default_search_ordering=0&mode=list')
135ms536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `id`,`title`,`description`,`keywords`,`level`,`crawled`,`modified`,`canonical`,`customhead`,`robots`,`custom`
FROM `ma37e_rsseo_pages`
WHERE `published` = 1 AND (`url` = 'hotels-test?country_id=3&default_search_ordering=0&mode=list' OR `sef` = 'hotels-test?country_id=3&default_search_ordering=0&mode=list') LIMIT 1
5.65ms1.44KB/plugins/system/falangdriver/falang_database.php:330CopyUPDATE `ma37e_rsseo_pages`
SET `hits` = `hits` + 1
WHERE `id` = '8024'
156μs48B/plugins/system/falangdriver/falang_database.php:133CopySELECT `id`,`date`
FROM `ma37e_rsseo_visitors`
WHERE `session_id` = '7617f0923a8998e22cf2d86789bbd91c'
ORDER BY `date` DESC
215μs528B/plugins/system/falangdriver/falang_database.php:330CopyINSERT INTO `ma37e_rsseo_visitors`
SET `session_id` = '7617f0923a8998e22cf2d86789bbd91c'
, `date` = '2025-07-28 04:18:34'
, `ip` = '216.73.216.193'
, `user_id` = '0'
, `agent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
, `referer` = ''
, `page` = 'hotels-test?country_id=3&default_search_ordering=0&mode=list'
77μs0B/plugins/system/falangdriver/falang_database.php:133CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `ma37e_modules` AS `m`
LEFT JOIN `ma37e_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `ma37e_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`
1.07ms58.22KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (233,186,214,215,109,104,134,101,159,161,91,17,222,223,108,235,150,142,236,87,96) AND `reference_table`= 'modules'
348μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'bc652c82cd8c0ef0dc61c2d0a1c12185' AND `published` = '1'
239μ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 `ma37e_categories` AS `s`
INNER JOIN `ma37e_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`
521μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `ma37e_assets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0
310μs1.55KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '29d915e447143925446d04f4c88d5078' AND `published` = '1'
141μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '5233459b8c92f4bf88327aa144fb3053' AND `published` = '1'
127μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'd56b699830e77ba53855679cb1d252da' AND `published` = '1'
115μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '3cc76b08e7b1946c15d35b6f74631f9a' AND `published` = '1'
119μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'e5899f586a7bce3b644f8fa9672a1b4d' AND `published` = '1'
85μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '79dc90e40984f2afe5cff8bb39a20baf' AND `published` = '1'
80μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '33597b7e7042b8276d6e894e8d3472bf' AND `published` = '1'
75μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'fad994de42ac93de63e143e769d11233' AND `published` = '1'
64μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'a2c8b94f599785951d6bc8622b5187f1' AND `published` = '1'
60μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '2439f85ef38d1eeecb6956f19cd1835d' AND `published` = '1'
75μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'd41d8cd98f00b204e9800998ecf8427e' AND `published` = '1'
84μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_rsseo_data`
48μs576B/plugins/system/falangdriver/falang_database.php:330Copyselect enabled from ma37e_extensions where type="component" and element = "com_content"
208μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT
c.id AS CID
FROM
ma37e_categories AS c
LEFT JOIN
ma37e_content AS content
ON
c.id = content.catid
WHERE
1=1
AND ( c.id = 18 OR c.id = 19)
AND
c.extension = 'com_content' AND
c.published = 1
164μs616B/plugins/system/falangdriver/falang_database.php:330CopySELECT
content.id AS iid
FROM
ma37e_content AS content
WHERE
content.state = 1
AND content.access IN (1,5)
AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2025-07-28 04:18:35' )
AND ( ISNULL(content.publish_down) OR content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2025-07-28 04:18:35' )
AND ( content.catid = 18 OR content.catid = 19 )
AND content.language in ('en-GB','*')
AND content.featured = 0
ORDER BY
content.created DESC
LIMIT
0,5;
219μs600B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (40,28,29,30,31) AND `reference_table`= 'content'
153μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT
content.id AS iid,
content.alias AS title,
content.fulltext AS text,
content.created AS date,
content.publish_up AS date_publish,
content.hits AS hits,
content.images AS images,
content.featured AS frontpage,
content.access AS access,
content.language AS lang,
categories.title AS catname,
users.email AS author_email,
content.created_by_alias AS author_alias,
users.name AS author_username,
content_rating.rating_sum AS rating_sum,
content_rating.rating_count AS rating_count,
CASE WHEN CHAR_LENGTH(content.alias)
THEN CONCAT_WS(":", content.id, content.alias)
ELSE content.id END as id,
CASE WHEN CHAR_LENGTH(categories.alias)
THEN CONCAT_WS(":", categories.id, categories.alias)
ELSE categories.id END as cid
FROM
ma37e_content AS content
LEFT JOIN
ma37e_categories AS categories
ON categories.id = content.catid
LEFT JOIN
ma37e_users AS users
ON users.id = content.created_by
LEFT JOIN
ma37e_content_rating AS content_rating
ON content_rating.content_id = content.id
LEFT JOIN
ma37e_content_frontpage AS content_frontpage
ON content_frontpage.content_id = content.id
WHERE
1=1
AND ( content.id = 40 OR content.id = 28 OR content.id = 29 OR content.id = 30 OR content.id = 31)
ORDER BY
content.created DESC
210μs2.47KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (40,28,29,30,31) AND `reference_table`= 'content'
121μ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 `ma37e_categories` AS `s`
INNER JOIN `ma37e_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`
325μ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 `ma37e_categories` AS `s`
INNER JOIN `ma37e_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`
264μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'fed8a89902fe105f4d3438b623f4cff2' AND `published` = '1'
140μ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 `ma37e_categories` AS `s`
INNER JOIN `ma37e_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`
281μ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 `ma37e_categories` AS `s`
INNER JOIN `ma37e_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`
282μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '3c7c0cd3b60b59e645a0ac65aaae0dd6' AND `published` = '1'
89μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '3a7b6c0ba2fb7287bc7f3445cd2e44d1' AND `published` = '1'
77μ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 `ma37e_categories` AS `s`
INNER JOIN `ma37e_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`
344μ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 `ma37e_categories` AS `s`
INNER JOIN `ma37e_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`
263μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '9d931a7d122f749f745fa14e12476d51' AND `published` = '1'
111μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'd8ef4692ddba7236e75e551173162a20' AND `published` = '1'
93μ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 `ma37e_categories` AS `s`
INNER JOIN `ma37e_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`
364μ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 `ma37e_categories` AS `s`
INNER JOIN `ma37e_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`
637μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '2b5ccc8fc81f8189aff686a43dc4547a' AND `published` = '1'
222μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '3f3671345fd620c424f975b75cc0c3c5' AND `published` = '1'
376μ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 `ma37e_categories` AS `s`
INNER JOIN `ma37e_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`
536μ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 `ma37e_categories` AS `s`
INNER JOIN `ma37e_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`
338μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '475990b0201693d3019b9779354dfb84' AND `published` = '1'
166μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'b7b94a5250451407e4580b4fe39f0b5a' AND `published` = '1'
124μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_list WHERE `type` = 'standard'
225μs1.67KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_field WHERE `id` IN(2) ORDER BY `ordering` ASC
99μs1.66KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '15b23a9a60ad2af4c8c90d23ed57a59b' AND `published` = '1'
158μ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`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count`
FROM `ma37e_content` AS `a`
LEFT JOIN `ma37e_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `ma37e_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `ma37e_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `ma37e_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `ma37e_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `ma37e_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray6,:preparedArray7)
ORDER BY a.created DESC LIMIT 5
633μs23.09KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,2,3,4) AND `reference_table`= 'content'
163μ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 `ma37e_categories` AS `s`
INNER JOIN `ma37e_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`
317μ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 `ma37e_categories` AS `s`
INNER JOIN `ma37e_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`
330μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '126d24c05055e7f64fa35c6198da933a' AND `published` = '1'
118μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '995cc138fac9087240ce4ba8fac9cc0d' AND `published` = '1'
126μ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 `ma37e_categories` AS `s`
INNER JOIN `ma37e_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`
336μ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 `ma37e_categories` AS `s`
INNER JOIN `ma37e_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`
250μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'e0877ee6f7609fa348963036909f9539' AND `published` = '1'
95μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '1b26423b474126940ba83a3d5ce67b1c' AND `published` = '1'
84μ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 `ma37e_categories` AS `s`
INNER JOIN `ma37e_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`
283μ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 `ma37e_categories` AS `s`
INNER JOIN `ma37e_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`
277μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '7e24cfe08e44f82e7aad50b6eba1363b' AND `published` = '1'
89μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'dc19e6b03b09f52dafd4bae3b5d7a9dd' AND `published` = '1'
115μ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 `ma37e_categories` AS `s`
INNER JOIN `ma37e_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`
329μ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 `ma37e_categories` AS `s`
INNER JOIN `ma37e_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`
286μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'ae911a9abeb2d5901dd46e1283167488' AND `published` = '1'
89μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '9b1204632b4fcbfcb6d9b21895fc11b3' AND `published` = '1'
132μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '9d7f564aa5e716dbae961dd1f0c23d30' AND `published` = '1'
97μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM ma37e_modules
WHERE published=1
ORDER BY id
620μs147.89KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (2,8,12,13,14,15,17,86,87,91,96,97,101,104,107,108,109,114,115,116,117,118,127,128,129,131,134,141,142,143,144,145,146,147,148,150,151,152,154,155,156,157,158,159,161,163,164,165,166,167,168,169,170,171,172,173,174,175,178,179,180,181,183,186,188,190,196,201,202,204,210,211,214,215,218,222,223,224,225,226,232,233,235,236,239,241,242,244) AND `reference_table`= 'modules'
770μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '47bb35200e1ce58eaedd76e7b658c9f2' AND `published` = '1'
129μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '16e6b02eb8a7260db15eb52c57dbafac' AND `published` = '1'
120μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'f7c1352a4798597c6ef9362f93381fb1' AND `published` = '1'
83μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '3d45d11c7464cdab0522d81ab1cc6636' AND `published` = '1'
88μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'efa62f3201cc63218a7c983c753524a5' AND `published` = '1'
96μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '9cd83e3daced2ceebe40ec15881755d2' AND `published` = '1'
83μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '50e6d0d939ebcb104ce7c093c70dcf3e' AND `published` = '1'
75μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'bcd90d43de25e7bcf25c1a762ad462b1' AND `published` = '1'
74μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '5cb1f9632280c0131a6f2b443bf3088d' AND `published` = '1'
113μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '8c513bb016ee3f946392cb44d8fa044d' AND `published` = '1'
103μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'a712c2fb4876c0e2ad14b2a039ca73ec' AND `published` = '1'
85μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '973118c6b495bb7fb83ae70b379221a0' AND `published` = '1'
82μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.params, a.layoutcss, a.customcss FROM ma37e_maximenuck_styles as a WHERE (a.state IN (0, 1)) AND a.id = 2
83μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '39afbfef616f2a790d702b08954360a7' AND `published` = '1'
328μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'dbec8b79757d1c3d9bea266a505eec4b' AND `published` = '1'
128μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1386 AND fc.language_id = 2 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
175μs520B/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_menu`
765μs1.7KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1386'
153μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1386) AND `reference_table`= 'menu'
149μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT p.*, jfc.value as jfcvalue
FROM ma37e_menu AS n, ma37e_menu AS p
LEFT JOIN ma37e_falang_content as jfc ON jfc.reference_table='menu' AND jfc.reference_id=p.id AND jfc.language_id='2' and jfc.reference_field='alias'
WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 1386 AND p.client_id = 0
ORDER BY p.lft
524μs3.02KB/plugins/system/falangdriver/falang_database.php:325CopySELECT m.path
FROM ma37e_menu m
WHERE m.id = 1386
58μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1386 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
88μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1386'
70μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1386) AND `reference_table`= 'menu'
77μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT p.*, jfc.value as jfcvalue
FROM ma37e_menu AS n, ma37e_menu AS p
LEFT JOIN ma37e_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 = 1386 AND p.client_id = 0
ORDER BY p.lft
269μs3.02KB/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '862ac5ff9809ced4907703b54113caae' AND `published` = '1'
82μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1386 AND fc.language_id = 3 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
79μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1386'
59μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1386) AND `reference_table`= 'menu'
79μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT p.*, jfc.value as jfcvalue
FROM ma37e_menu AS n, ma37e_menu AS p
LEFT JOIN ma37e_falang_content as jfc ON jfc.reference_table='menu' AND jfc.reference_id=p.id AND jfc.language_id='3' and jfc.reference_field='alias'
WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 1386 AND p.client_id = 0
ORDER BY p.lft
271μs3.02KB/plugins/system/falangdriver/falang_database.php:325CopySELECT m.path
FROM ma37e_menu m
WHERE m.id = 1386
34μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1386 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
90μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1386'
84μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1386) AND `reference_table`= 'menu'
132μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT p.*, jfc.value as jfcvalue
FROM ma37e_menu AS n, ma37e_menu AS p
LEFT JOIN ma37e_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 = 1386 AND p.client_id = 0
ORDER BY p.lft
370μs3.02KB/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'c49acc836402f4f666c7f15ca7fae062' AND `published` = '1'
112μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1386 AND fc.language_id = 4 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
119μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1386'
86μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1386) AND `reference_table`= 'menu'
91μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT p.*, jfc.value as jfcvalue
FROM ma37e_menu AS n, ma37e_menu AS p
LEFT JOIN ma37e_falang_content as jfc ON jfc.reference_table='menu' AND jfc.reference_id=p.id AND jfc.language_id='4' and jfc.reference_field='alias'
WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 1386 AND p.client_id = 0
ORDER BY p.lft
325μs3.02KB/plugins/system/falangdriver/falang_database.php:325CopySELECT m.path
FROM ma37e_menu m
WHERE m.id = 1386
62μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1386 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
106μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1386'
65μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1386) AND `reference_table`= 'menu'
107μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT p.*, jfc.value as jfcvalue
FROM ma37e_menu AS n, ma37e_menu AS p
LEFT JOIN ma37e_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 = 1386 AND p.client_id = 0
ORDER BY p.lft
307μs3.02KB/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'fa99b2fb061328942b7e9b3afdf8c596' AND `published` = '1'
113μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1386 AND fc.language_id = 5 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
125μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1386'
63μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1386) AND `reference_table`= 'menu'
70μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT p.*, jfc.value as jfcvalue
FROM ma37e_menu AS n, ma37e_menu AS p
LEFT JOIN ma37e_falang_content as jfc ON jfc.reference_table='menu' AND jfc.reference_id=p.id AND jfc.language_id='5' and jfc.reference_field='alias'
WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 1386 AND p.client_id = 0
ORDER BY p.lft
277μs3.02KB/plugins/system/falangdriver/falang_database.php:325CopySELECT m.path
FROM ma37e_menu m
WHERE m.id = 1386
40μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1386 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
137μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1386'
60μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1386) AND `reference_table`= 'menu'
118μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT p.*, jfc.value as jfcvalue
FROM ma37e_menu AS n, ma37e_menu AS p
LEFT JOIN ma37e_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 = 1386 AND p.client_id = 0
ORDER BY p.lft
337μs3.02KB/plugins/system/falangdriver/falang_database.php:325CopySELECT *
FROM ma37e_modules
WHERE published=1
ORDER BY id
456μs147.89KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (2,8,12,13,14,15,17,86,87,91,96,97,101,104,107,108,109,114,115,116,117,118,127,128,129,131,134,141,142,143,144,145,146,147,148,150,151,152,154,155,156,157,158,159,161,163,164,165,166,167,168,169,170,171,172,173,174,175,178,179,180,181,183,186,188,190,196,201,202,204,210,211,214,215,218,222,223,224,225,226,232,233,235,236,239,241,242,244) AND `reference_table`= 'modules'
678μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT a.params, a.layoutcss, a.customcss FROM ma37e_maximenuck_styles as a WHERE (a.state IN (0, 1)) AND a.id = 2
74μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT params
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `home` = 1
193μs64.52KB/plugins/system/falangdriver/falang_database.php:330CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
115μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
86μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_list WHERE type = 'standard'
435μs1.67KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_field
172μs1.69KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_form WHERE active = 1 AND type != 'shortcode'
106μs912B/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 `ma37e_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
236μs1.37KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `value` FROM ma37e_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"
256μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT data_key, data_value
FROM `ma37e_sr_config_data`
WHERE scope_id = 0
663μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_rsseo_keywords`
ORDER BY CHAR_LENGTH(keyword) DESC
63μs1.28KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `id`,`css`,`scripts`
FROM `ma37e_rsseo_pages`
WHERE `published` = 1 AND (`url` = 'hotels-test?country_id=3&default_search_ordering=0&mode=list' OR `sef` = 'hotels-test?country_id=3&default_search_ordering=0&mode=list') LIMIT 1
5.81ms656B/plugins/system/falangdriver/falang_database.php:330Copy