Countries

Albania

Bosnia and Herzegovina

Bulgaria

Croatia

Cyprus

Greece

Italy

Montenegro

North Macedonia

11 Tanglin Road, Orchard Показать карту (1.5 км от центра)
Lagja 1, Rruga Taulantia, Durres, Albania Показать карту
1234 Collins Avenue, Miami Beach Показать карту (99.0 км от центра)
Via Vespasiano 122, Vatican Показать карту (3.0 км от центра)
Plazh, Rruga Pavaresia, Durrës Показать карту
Пожалуйста, зарегистрируйтесь или авторизуйтесь для просмотра.
RESERVATION HOTLINE:
+1-222-34-56-789Infinity Joomla Template © 2016-2024. All Rights Reserved. Designed by Solidres.com
Joomla! Version | 5.3.1 |
PHP Version | 8.2.27 |
Identity | guest |
Response | 200 |
Template | infinity |
Database |
|
1 x afterRenderComponent com_solidres (7.62MB) (25.35%) | 557ms |
1 x afterInitialise (3.45MB) (19.33%) | 424ms |
1 x afterDispatch (124.6KB) (16.59%) | 364ms |
1 x Before Access::preloadComponents (all components) (2.79MB) (6.11%) | 134ms |
1 x beforeRenderRawModule mod_menu (Main Menu) (709.88KB) (5.76%) | 126ms |
1 x afterRenderRawModule mod_sppagebuilder (countries flags for main) (3.72MB) (4.75%) | 104ms |
1 x afterRender (719.32KB) (3.46%) | 75.98ms |
1 x afterRenderRawModule mod_articles_latest (LATEST NEWS) (407.58KB) (3.11%) | 68.19ms |
1 x afterLoad (355.64KB) (2.4%) | 52.69ms |
1 x afterRenderRawModule mod_news_pro_gk5 (тест статьи джумла) (578.72KB) (2.28%) | 50.00ms |
1 x afterRenderRawModule mod_falang (FaLang Language Switcher) (728.59KB) (2.25%) | 49.34ms |
1 x afterRenderRawModule mod_sppagebuilder (Top Resorts for main) (1.21MB) (2.03%) | 44.51ms |
1 x afterRoute (1.42MB) (1.74%) | 38.26ms |
1 x afterRenderRawModule mod_menu (Main Menu) (248.98KB) (1.23%) | 27.04ms |
1 x afterRenderRawModule mod_acym (STAY UP TO DATE) (43.48KB) (0.57%) | 12.51ms |
1 x Before Access::getAssetRules (id:1 name:root.1) (12.66KB) (0.34%) | 7.43ms |
1 x afterRenderRawModule mod_menu (for Main-prototip-menu) (54.52KB) (0.33%) | 7.31ms |
1 x beforeRenderRawModule mod_news_pro_gk5 (тест статьи джумла) (98.69KB) (0.3%) | 6.61ms |
1 x afterRenderRawModule mod_sp_weather (Weather) (30.65KB) (0.24%) | 5.25ms |
1 x afterRenderRawModule mod_custom (Map Icon) (928B) (0.18%) | 3.96ms |
1 x afterRenderRawModule mod_custom (Copyright) (68.84KB) (0.15%) | 3.22ms |
1 x afterRenderRawModule mod_menu (Bottom Menu) (20.91KB) (0.14%) | 3.14ms |
1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (8.84KB) (0.14%) | 3.01ms |
1 x afterRenderModule mod_menu (Main Menu) (248B) (0.12%) | 2.72ms |
1 x afterRenderRawModule mod_menu (для меню Ru) (5.33KB) (0.12%) | 2.64ms |
1 x beforeRenderRawModule mod_custom (Copyright) (88.71KB) (0.09%) | 2.02ms |
1 x After Access::preloadComponents (all components) (117.06KB) (0.09%) | 1.98ms |
1 x afterRenderModule mod_sppagebuilder (Top Resorts for main) (146.47KB) (0.07%) | 1.52ms |
1 x afterRenderModule mod_custom (Map Icon) (2.69KB) (0.06%) | 1.37ms |
1 x beforeRenderComponent com_solidres (68.99KB) (0.06%) | 1.30ms |
1 x afterRenderModule mod_sp_weather (Weather) (3.66KB) (0.05%) | 1.18ms |
1 x afterRenderModule mod_falang (FaLang Language Switcher) (6.77KB) (0.05%) | 1.12ms |
1 x afterRenderModule mod_custom (Copyright) (2.83KB) (0.05%) | 1.09ms |
1 x afterRenderModule mod_acym (STAY UP TO DATE) (4.95KB) (0.05%) | 1.03ms |
1 x After Access::getAssetRules (id:124 name:com_solidres) (11.85KB) (0.04%) | 931μs |
1 x afterRenderModule mod_sppagebuilder (countries flags for main) (42.47KB) (0.03%) | 749μs |
1 x afterRenderModule mod_custom (Social Icons) (2.95KB) (0.03%) | 621μs |
1 x afterRenderModule mod_news_pro_gk5 (тест статьи джумла) (5.08KB) (0.03%) | 567μs |
1 x afterRenderModule mod_menu (for Main-prototip-menu) (4.38KB) (0.02%) | 518μs |
1 x afterRenderModule mod_articles_latest (LATEST NEWS) (3.25KB) (0.02%) | 452μs |
1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.38KB) (0.02%) | 381μs |
1 x afterRenderModule mod_menu (Bottom Menu) (2.88KB) (0.02%) | 379μs |
1 x afterRenderModule mod_custom (RESERVATION HOTLINE) (2.83KB) (0.02%) | 372μs |
1 x afterRenderModule mod_menu (для меню Ru) (3.69KB) (0.02%) | 367μs |
1 x afterRenderModule mod_custom (Contact Details) (3.2KB) (0.01%) | 278μs |
1 x beforeRenderRawModule mod_menu (for Main-prototip-menu) (88B) (0.01%) | 183μs |
1 x beforeRenderRawModule mod_menu (для меню Ru) (2.2KB) (0.01%) | 171μs |
1 x beforeRenderRawModule mod_custom (Social Icons) (424B) (0.01%) | 169μs |
1 x beforeRenderRawModule mod_articles_latest (LATEST NEWS) (2.82KB) (0.01%) | 149μs |
1 x beforeRenderRawModule mod_acym (STAY UP TO DATE) (1.52KB) (0.01%) | 136μs |
1 x beforeRenderRawModule mod_sp_weather (Weather) (3.84KB) (0.01%) | 125μs |
1 x beforeRenderRawModule mod_custom (Contact Details) (2.49KB) (0.01%) | 111μs |
1 x beforeRenderRawModule mod_custom (RESERVATION HOTLINE) (824B) (0%) | 94μs |
1 x afterRenderRawModule mod_custom (Social Icons) (896B) (0%) | 90μs |
1 x beforeRenderRawModule mod_falang (FaLang Language Switcher) (424B) (0%) | 85μs |
1 x After Access::getAssetRules (id:1 name:root.1) (6.02KB) (0%) | 78μs |
1 x afterRenderRawModule mod_custom (Contact Details) (832B) (0%) | 75μs |
1 x beforeRenderRawModule mod_sppagebuilder (countries flags for main) (600B) (0%) | 72μs |
1 x afterRenderRawModule mod_custom (RESERVATION HOTLINE) (928B) (0%) | 71μs |
1 x Before Access::getAssetRules (id:124 name:com_solidres) (1.32KB) (0%) | 69μs |
1 x beforeRenderRawModule mod_menu (Bottom Menu) (1.95KB) (0%) | 68μs |
1 x beforeRenderRawModule mod_sppagebuilder (Top Resorts for main) (880B) (0%) | 35μs |
1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (264B) (0%) | 35μs |
1 x beforeRenderRawModule mod_custom (Map Icon) (3.44KB) (0%) | 33μs |
1 x beforeRenderModule mod_custom (Map Icon) (720B) (0%) | 28μs |
1 x beforeRenderModule mod_news_pro_gk5 (тест статьи джумла) (752B) (0%) | 23μs |
1 x beforeRenderModule mod_falang (FaLang Language Switcher) (736B) (0%) | 18μs |
1 x beforeRenderModule mod_custom (Copyright) (720B) (0%) | 17μs |
1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%) | 16μs |
1 x beforeRenderModule mod_sppagebuilder (Top Resorts for main) (736B) (0%) | 16μs |
1 x beforeRenderModule mod_sp_weather (Weather) (720B) (0%) | 14μs |
1 x beforeRenderModule mod_acym (STAY UP TO DATE) (720B) (0%) | 14μs |
1 x beforeRenderModule mod_articles_latest (LATEST NEWS) (704B) (0%) | 13μs |
1 x beforeRenderModule mod_menu (for Main-prototip-menu) (720B) (0%) | 13μs |
1 x beforeRenderModule mod_sppagebuilder (countries flags for main) (736B) (0%) | 12μs |
1 x beforeRenderModule mod_menu (Bottom Menu) (720B) (0%) | 9μs |
1 x beforeRenderModule mod_custom (Social Icons) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%) | 6μs |
1 x beforeRenderModule mod_menu (для меню Ru) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_custom (Contact Details) (720B) (0%) | 2μs |
1 x beforeRenderModule mod_custom (RESERVATION HOTLINE) (720B) (0%) | 2μs |
select distinct reference_table from ma37e_falang_content
342μs1.02KB/plugins/system/falangdriver/falang_database.php:224CopySELECT `params`
FROM `ma37e_extensions`
WHERE `type` = 'component' AND `element` = 'com_rsseo'
525μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_rsseo_redirects`
WHERE `published` = 1
103μs816B/plugins/system/falangdriver/falang_database.php:330CopySELECT `url`,`sef`
FROM `ma37e_rsseo_pages`
WHERE `short` = 'ru/hotels/montenegro-hotels-1?categories[0]=14&default_search_ordering=0&mode=list'
172ms576B/plugins/system/falangdriver/falang_database.php:330CopySELECT `url`
FROM `ma37e_rsseo_pages`
WHERE `sef` = 'ru/hotels/montenegro-hotels-1?categories%5B0%5D=14&default_search_ordering=0&mode=list'
353μs840B/plugins/system/falangdriver/falang_database.php:330CopySELECT `url`
FROM `ma37e_rsseo_pages`
WHERE `sef` = 'ru/hotels/montenegro-hotels-1'
173μ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`
871μs60.05KBParams/plugins/system/falangdriver/falang_database.php:133CopySELECT joomlatablename,tablepkID FROM `ma37e_falang_tableinfo`
171μs1.06KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_languages`
124μs2.3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1358) AND `reference_table`= 'menu'
214μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1359) AND `reference_table`= 'menu'
161μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1367) AND `reference_table`= 'menu'
125μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1368) AND `reference_table`= 'menu'
140μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1369) AND `reference_table`= 'menu'
140μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1382) AND `reference_table`= 'menu'
189μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1399) AND `reference_table`= 'menu'
640μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1370) AND `reference_table`= 'menu'
158μs1.92KB/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1379) AND `reference_table`= 'menu'
138μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1378) AND `reference_table`= 'menu'
159μs704B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (101) AND `reference_table`= 'menu'
147μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1307) AND `reference_table`= 'menu'
144μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (132) AND `reference_table`= 'menu'
116μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1308) AND `reference_table`= 'menu'
134μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1325) AND `reference_table`= 'menu'
150μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1333) AND `reference_table`= 'menu'
148μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1335) AND `reference_table`= 'menu'
116μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1336) AND `reference_table`= 'menu'
117μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1337) AND `reference_table`= 'menu'
138μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1340) AND `reference_table`= 'menu'
116μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1341) AND `reference_table`= 'menu'
138μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1342) AND `reference_table`= 'menu'
132μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (102) AND `reference_table`= 'menu'
142μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1343) AND `reference_table`= 'menu'
117μs3.17KB/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1344) AND `reference_table`= 'menu'
117μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1345) AND `reference_table`= 'menu'
119μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1346) AND `reference_table`= 'menu'
122μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1357) AND `reference_table`= 'menu'
149μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1380) AND `reference_table`= 'menu'
112μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1381) AND `reference_table`= 'menu'
86μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1334) AND `reference_table`= 'menu'
82μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1383) AND `reference_table`= 'menu'
87μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1385) AND `reference_table`= 'menu'
78μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1384) AND `reference_table`= 'menu'
224μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1386) AND `reference_table`= 'menu'
126μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1395) AND `reference_table`= 'menu'
116μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1396) AND `reference_table`= 'menu'
128μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1398) AND `reference_table`= 'menu'
129μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1397) AND `reference_table`= 'menu'
136μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1408) AND `reference_table`= 'menu'
123μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1409) AND `reference_table`= 'menu'
128μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1306) AND `reference_table`= 'menu'
128μs688B/plugins/system/falangdriver/falang_database.php:325CopySHOW FULL TABLES WHERE table_type="BASE TABLE"
2.27ms4.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_plugin
437μs1.5KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_configuration
192μs2.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_plugin
125μs1.5KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value`
FROM ma37e_usergroups AS `groups`
301μs1.02KB/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
600μs96.88KB/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)
930μs7.81KBParams/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_currencies`
735μs1.39KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_currencies`
WHERE `id` = '2'
324μs896B/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_categories`
1.15ms1.7KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_categories`
WHERE `id` = '14'
569μs3KB/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)
321μs1.32KBParams/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 ((cat.lft >= 25 AND cat.rgt <= 26))
GROUP BY cat.title,parent.title,cou.name,geostate.name,uc.name,ag.title,a.id
ORDER BY a.rating asc
841μs1.52KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (12,14,15,8,11,16) AND `reference_table`= 'sr_reservation_assets'
534μs11.83KB/plugins/system/falangdriver/falang_database.php:325CopySHOW FULL COLUMNS FROM `ma37e_sr_reservation_assets`
1.01ms2.14KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '12'
471μs21.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (12) AND `reference_table`= 'sr_reservation_assets'
548μ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)
224μ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)
214μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_countries`
878μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '189'
414μs1.47KB/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_geo_states`
740μs1.36KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_currencies`
WHERE `id` = '1'
116μ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
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
WHERE r.state = 1 AND r.reservation_asset_id = 12
GROUP BY asset.name,uc.name,r.id
ORDER BY r.ordering ASC
530μs3.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (24,25) AND `reference_table`= 'sr_room_types'
247μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (24,25) AND `reference_table`= 'sr_reservation_assets'
108μs688B/plugins/system/falangdriver/falang_database.php:325CopySHOW FULL COLUMNS FROM `ma37e_sr_customers`
1.08ms1.58KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_customers`
WHERE `id` = '31'
164μs2.5KB/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_users`
932μs1.58KB/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_customer_groups`
694μs1.31KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_users`
WHERE `id` = :userid
202μ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
691μs1.38KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '12'
304μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_currencies`
WHERE `id` = 1
692μs896B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_currencies`
WHERE `id` = 2
130μ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 = 12 AND a.type IN (0,2,3,8,9)
ORDER BY a.title ASC
1.39ms2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '24'
168μ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 = 24 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
430μs3.05KB/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_tariffs`
1.44ms1.7KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '52'
467μ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 = 52
ORDER BY t.w_day ASC
609μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '91'
338μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT occupancy_adult, occupancy_child, occupancy_child_age_range
FROM `ma37e_sr_room_types`
WHERE id = '24'
228μs656B/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 = 91 AND t.guest_type = 'adult1'
ORDER BY t.w_day ASC
322μs1.77KB/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 = 91 AND t.guest_type = 'adult2'
ORDER BY t.w_day ASC
326μs1.77KB/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 = 91 AND t.guest_type = 'child1'
ORDER BY t.w_day ASC
324μs1.77KB/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 = 91 AND t.guest_type = 'child2'
ORDER BY t.w_day ASC
196μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 24
123μ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 (40,32,37,31,30,35,24,23,36)
ORDER BY a.ordering ASC
238μs848B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (23,24,30,31,32,35,36,37,40) AND `reference_table`= 'sr_facilities'
288μs720B/plugins/system/falangdriver/falang_database.php:325CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 24 AND field_key LIKE 'roomtype_custom_fields.%'
340μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '25'
78μ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 = 25 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
400μs3.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '55'
284μ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 = 55
ORDER BY t.w_day ASC
227μs1.66KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '94'
897μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT occupancy_adult, occupancy_child, occupancy_child_age_range
FROM `ma37e_sr_room_types`
WHERE id = '25'
131μs656B/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 = 94 AND t.guest_type = 'adult1'
ORDER BY t.w_day ASC
261μs1.77KB/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 = 94 AND t.guest_type = 'adult2'
ORDER BY t.w_day ASC
192μs1.77KB/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 = 94 AND t.guest_type = 'child1'
ORDER BY t.w_day ASC
541μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 25
104μ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 (26,34,39,28,27,38,25,33,29)
ORDER BY a.ordering ASC
182μs848B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (25,26,27,28,29,33,34,38,39) AND `reference_table`= 'sr_facilities'
347μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 25 AND field_key LIKE 'roomtype_custom_fields.%'
160μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 12
565μs616B/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 (13,21,4,8,16,1)
ORDER BY a.ordering ASC
87μs784B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1,4,8,13,16,21) AND `reference_table`= 'sr_facilities'
182μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 12
116μs568B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 12
58μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_reservation_asset_fields`
WHERE reservation_asset_id = 12 AND field_key LIKE 'reservationasset_extra_fields.%'
321μs1KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '14'
311μs21.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (14) AND `reference_table`= 'sr_reservation_assets'
408μs816B/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)
177μ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)
116μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '3'
159μs1.47KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_geo_states`
WHERE `id` = '523'
271μs832B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_currencies`
WHERE `id` = '2'
157μ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
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
WHERE r.state = 1 AND r.reservation_asset_id = 14
GROUP BY asset.name,uc.name,r.id
ORDER BY r.ordering ASC
561μs11.03KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (30) AND `reference_table`= 'sr_room_types'
252μs704B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (30) AND `reference_table`= 'sr_reservation_assets'
185μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '14'
179μ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
506μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '30'
212μ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
1.25ms3.02KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 30
137μ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.%'
180μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 14
107μ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
765μs848B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (66,70,75,87,119,146,148,149,150,151) AND `reference_table`= 'sr_facilities'
2.2ms704B/plugins/system/falangdriver/falang_database.php:325CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 14
203μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 14
896μ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.%'
689μs960B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '15'
530μs21.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (15) AND `reference_table`= 'sr_reservation_assets'
301μ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)
218μ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)
134μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_geo_states`
WHERE `id` = '523'
133μ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
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
WHERE r.state = 1 AND r.reservation_asset_id = 15
GROUP BY asset.name,uc.name,r.id
ORDER BY r.ordering ASC
501μs3.02KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '15'
117μ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
198μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 15
128μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 15
131μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 15
102μ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.%'
347μs960B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '8'
381μs21.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (8) AND `reference_table`= 'sr_reservation_assets'
475μ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)
424μ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)
170μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '224'
244μs1.47KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_geo_states`
WHERE `id` = '11'
141μ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
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
WHERE r.state = 1 AND r.reservation_asset_id = 8
GROUP BY asset.name,uc.name,r.id
ORDER BY r.ordering ASC
997μs3.09KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (15,16,17,18,19) AND `reference_table`= 'sr_room_types'
600μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (15,16,17,18,19) AND `reference_table`= 'sr_reservation_assets'
682μs720B/plugins/system/falangdriver/falang_database.php:325CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '8'
382μ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 = 8 AND a.type IN (0,2,3,8,9)
ORDER BY a.title ASC
471μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '15'
177μ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 = 15 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
403μs3.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '12'
238μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT occupancy_adult, occupancy_child, occupancy_child_age_range
FROM `ma37e_sr_room_types`
WHERE id = '15'
132μs656B/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 = 12 AND t.guest_type = 'adult1'
ORDER BY t.w_day ASC
226μs1.77KB/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 = 12 AND t.guest_type = 'adult2'
ORDER BY t.w_day ASC
162μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '84'
208μ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 = 84 AND t.guest_type = 'adult1'
ORDER BY t.w_day ASC
221μs1.77KB/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 = 84 AND t.guest_type = 'adult2'
ORDER BY t.w_day ASC
134μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 15
308μs600B/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 (34,38,31,24,23)
ORDER BY a.ordering ASC
134μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (23,24,31,34,38) AND `reference_table`= 'sr_facilities'
424μs720B/plugins/system/falangdriver/falang_database.php:325CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 15 AND field_key LIKE 'roomtype_custom_fields.%'
163μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '16'
83μ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 = 16 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
449μs3.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '8'
160μ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 = 8
ORDER BY t.w_day ASC
199μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '83'
144μ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 = 83
ORDER BY t.w_day ASC
169μs1.66KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 16
144μs648B/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,28,27,37,31,25,35,24)
ORDER BY a.ordering ASC
167μs816B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (24,25,27,28,31,35,37,40) AND `reference_table`= 'sr_facilities'
398μs720B/plugins/system/falangdriver/falang_database.php:325CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 16 AND field_key LIKE 'roomtype_custom_fields.%'
180μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '17'
131μ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 = 17 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
318μs3.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '42'
157μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT occupancy_adult, occupancy_child, occupancy_child_age_range
FROM `ma37e_sr_room_types`
WHERE id = '17'
119μs656B/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 = 42 AND t.guest_type = 'adult1'
ORDER BY t.w_day ASC
213μs1.66KB/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 = 42 AND t.guest_type = 'adult2'
ORDER BY t.w_day ASC
158μs1.66KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '82'
153μ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 = 82 AND t.guest_type = 'adult1'
ORDER BY t.w_day ASC
200μs1.77KB/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 = 82 AND t.guest_type = 'adult2'
ORDER BY t.w_day ASC
175μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 17
146μ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 (32,28,33,29)
ORDER BY a.ordering ASC
145μs752B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (28,29,32,33) AND `reference_table`= 'sr_facilities'
297μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 17 AND field_key LIKE 'roomtype_custom_fields.%'
177μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '18'
116μ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 = 18 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
353μs3.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '6'
241μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT occupancy_adult, occupancy_child, occupancy_child_age_range
FROM `ma37e_sr_room_types`
WHERE id = '18'
80μs656B/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 = 6 AND t.guest_type = 'adult1'
ORDER BY t.w_day ASC
244μs1.77KB/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 = 6 AND t.guest_type = 'adult2'
ORDER BY t.w_day ASC
179μs1.77KB/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 = 6 AND t.guest_type = 'child1'
ORDER BY t.w_day ASC
345μs1.77KB/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 = 6 AND t.guest_type = 'child2'
ORDER BY t.w_day ASC
211μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '7'
392μ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 = 7
ORDER BY t.w_day ASC
516μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 18
427μ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 (26,39,30,36)
ORDER BY a.ordering ASC
159μs752B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (26,30,36,39) AND `reference_table`= 'sr_facilities'
360μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 18 AND field_key LIKE 'roomtype_custom_fields.%'
182μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '19'
140μ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 = 19 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
340μs3.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '13'
181μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT occupancy_adult, occupancy_child, occupancy_child_age_range
FROM `ma37e_sr_room_types`
WHERE id = '19'
159μs656B/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 = 13 AND t.guest_type = 'adult1'
ORDER BY t.w_day ASC
235μs1.77KB/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 = 13 AND t.guest_type = 'adult2'
ORDER BY t.w_day ASC
219μs1.77KB/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 = 13 AND t.guest_type = 'child1'
ORDER BY t.w_day ASC
209μs1.77KB/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 = 13 AND t.guest_type = 'child2'
ORDER BY t.w_day ASC
202μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '85'
160μ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 = 85
ORDER BY t.w_day ASC
201μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 19
147μs600B/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 (37,31,25,35,23)
ORDER BY a.ordering ASC
143μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (23,25,31,35,37) AND `reference_table`= 'sr_facilities'
336μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 19 AND field_key LIKE 'roomtype_custom_fields.%'
183μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 8
146μs616B/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 (3,4,2,11,16,1)
ORDER BY a.ordering ASC
146μs784B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1,2,3,4,11,16) AND `reference_table`= 'sr_facilities'
272μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 8
136μs568B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 8
127μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_reservation_asset_fields`
WHERE reservation_asset_id = 8 AND field_key LIKE 'reservationasset_extra_fields.%'
393μs960B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '11'
409μs21.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (11) AND `reference_table`= 'sr_reservation_assets'
314μ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)
207μ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)
175μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '106'
169μs1.47KB/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
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
WHERE r.state = 1 AND r.reservation_asset_id = 11
GROUP BY asset.name,uc.name,r.id
ORDER BY r.ordering ASC
712μs3.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (26,27) AND `reference_table`= 'sr_room_types'
364μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (26,27) AND `reference_table`= 'sr_reservation_assets'
229μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '11'
154μ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 = 11 AND a.type IN (0,2,3,8,9)
ORDER BY a.title ASC
387μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '26'
135μ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 = 26 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
425μs3.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '58'
360μ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 = 58
ORDER BY t.w_day ASC
294μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '88'
261μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT occupancy_adult, occupancy_child, occupancy_child_age_range
FROM `ma37e_sr_room_types`
WHERE id = '26'
140μs656B/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 = 88 AND t.guest_type = 'adult1'
ORDER BY t.w_day ASC
359μs1.77KB/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 = 88 AND t.guest_type = 'adult2'
ORDER BY t.w_day ASC
236μs1.77KB/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 = 88 AND t.guest_type = 'child1'
ORDER BY t.w_day ASC
180μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 26
140μs680B/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 26 AND field_key LIKE 'roomtype_custom_fields.%'
180μs16.64KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '27'
136μ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 = 27 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
276μs3.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '81'
162μ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 = 81
ORDER BY t.w_day ASC
541μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '90'
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 = 90
ORDER BY t.w_day ASC
189μs1.66KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 27
175μs680B/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 27 AND field_key LIKE 'roomtype_custom_fields.%'
175μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 11
130μs616B/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 (19,14,9,6,17,1)
ORDER BY a.ordering ASC
170μs784B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1,6,9,14,17,19) AND `reference_table`= 'sr_facilities'
341μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 11
268μs568B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 11
128μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_reservation_asset_fields`
WHERE reservation_asset_id = 11 AND field_key LIKE 'reservationasset_extra_fields.%'
379μs1KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '16'
447μs21.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (16) AND `reference_table`= 'sr_reservation_assets'
324μs720B/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)
636μ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)
267μs1.34KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_geo_states`
WHERE `id` = '523'
291μ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
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
WHERE r.state = 1 AND r.reservation_asset_id = 16
GROUP BY asset.name,uc.name,r.id
ORDER BY r.ordering ASC
577μs3.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (31,32) AND `reference_table`= 'sr_room_types'
344μs752B/plugins/system/falangdriver/falang_database.php:325CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (31,32) AND `reference_table`= 'sr_reservation_assets'
289μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '16'
81μ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
374μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '31'
87μ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
194μs3.02KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 31
1.69ms584B/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
190μs752B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (23,32,37,40) AND `reference_table`= 'sr_facilities'
1.36ms688B/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.%'
291μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '32'
149μ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
340μs3.02KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 32
156μs616B/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 (43,40,32,37,23,42)
ORDER BY a.ordering ASC
157μs784B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (23,32,37,40,42,43) AND `reference_table`= 'sr_facilities'
275μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 32 AND field_key LIKE 'roomtype_custom_fields.%'
162μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 16
144μs648B/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 (4,41,22,11,6,15,1)
ORDER BY a.ordering ASC
229μs816B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1,4,6,11,15,22,41) AND `reference_table`= 'sr_facilities'
298μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 16
130μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 16
166μs520B/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.%'
361μ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 ((cat.lft >= 25 AND cat.rgt <= 26))
GROUP BY cat.title,parent.title,cou.name,geostate.name,uc.name,ag.title,a.id
ORDER BY a.rating asc
548μs1.52KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (12,14,15,8,11,16) AND `reference_table`= 'sr_reservation_assets'
447μs848B/plugins/system/falangdriver/falang_database.php:325CopySELECT *
FROM `ma37e_categories`
WHERE `id` = '14'
191μs3KB/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)
175μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT r.id, r.name, r.scope
FROM `ma37e_sr_feedback_attributes` AS `r`
WHERE r.scope = 0
ORDER BY r.id desc
133μ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 = 12 OR a.item_id = 12) AND a.state = 1
ORDER BY a.id DESC LIMIT 3
333μs608B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (32,31) AND `reference_table`= 'sr_reservation_assets'
214μs688B/plugins/system/falangdriver/falang_database.php:325CopySHOW FULL COLUMNS FROM `ma37e_sr_feedbacks`
701μs1.52KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '32'
195μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_reservations`
1.33ms2.52KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '38'
520μs9.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'a811bf5f1ea7bcb657bcd4fa271b010c' AND `published` = '1'
265μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '4709df96ef5a4a9497162e53063f8a49' AND `published` = '1'
208μ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.38'
878μs688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '197'
174μ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 = 38
149μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (12) AND `reference_table`= 'sr_reservation_assets'
191μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '22096093480019112b06fa635b5db9f3' AND `published` = '1'
188μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '264e092573c4c3f6a9fa5989a39a6a0a' AND `published` = '1'
129μ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
131μ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 = 32 AND a.field_id = 8
205μ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 = 32 AND a.field_id = 9
141μ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 = 32 AND a.field_id = 10
168μ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 = 32 AND a.field_id = 11
130μ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 = 32 AND a.field_id = 12
155μ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 = 32 AND a.field_id = 13
155μ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 = 32 AND a.field_id = 14
145μ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 = 32 AND a.scope = 0
219μ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 = 32
156μ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 = 32
155μ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 = 32
145μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '31'
214μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '37'
435μs9.56KB/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.37'
639μs688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '213'
292μ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 = 37
452μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (12) AND `reference_table`= 'sr_reservation_assets'
741μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT 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 = 31 AND a.field_id = 8
552μ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 = 31 AND a.field_id = 9
245μ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 = 31 AND a.field_id = 10
216μ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 = 31 AND a.field_id = 11
159μ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 = 31 AND a.field_id = 12
189μ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 = 31 AND a.field_id = 13
170μ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 = 31 AND a.field_id = 14
173μ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 = 31 AND a.scope = 0
331μ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 = 31
237μ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 = 31
182μ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 = 31
168μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.*
FROM `ma37e_sr_reservations` AS `a`
WHERE a.reservation_asset_id = 12 AND a.state = 0
611μs9.58KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.field
FROM `ma37e_sr_feedback_conditions` AS `a`
WHERE a.scope = 0
708μ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 = 12 OR a2.item_id = 12)
695μs608B/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 = 12 OR a2.item_id = 12)
373μs608B/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 = 12 OR a2.item_id = 12)
420μs608B/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 = 12 OR a2.item_id = 12)
402μs608B/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 = 12 OR a2.item_id = 12)
398μs608B/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 = 12 OR a2.item_id = 12)
301μs608B/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 = 12 OR a2.item_id = 12)
399μs608B/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 = 12 OR a2.item_id = 12)
GROUP BY a.field_id
288μs648B/plugins/system/falangdriver/falang_database.php:330CopySELECT COUNT(*)
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 = 12 OR a.item_id = 12) AND a.state = 1
303μs536B/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 = 14 OR a.item_id = 14) AND a.state = 1
ORDER BY a.id DESC LIMIT 3
694μ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
540μ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)
2.55ms576B/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)
533μ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)
376μ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)
333μ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)
320μ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)
308μ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)
334μ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
227μ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
ORDER BY a.id DESC LIMIT 3
263μ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
400μ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)
648μ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)
533μ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)
384μ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 = 15 OR a2.item_id = 15)
373μ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)
341μ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)
323μ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)
302μ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
256μ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 = 8 OR a.item_id = 8) AND a.state = 1
ORDER BY a.id DESC LIMIT 3
268μs624B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (24,23,22) AND `reference_table`= 'sr_reservation_assets'
226μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '24'
190μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '25'
313μs9.56KB/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.25'
891μs688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '235'
211μ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 = 25
211μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (8) AND `reference_table`= 'sr_reservation_assets'
264μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'ca79ccbea056ae394b5eb00e9d6494be' AND `published` = '1'
189μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '920a0b750fc02dda174038270dea9b65' AND `published` = '1'
144μs520B/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 = 24 AND a.field_id = 8
248μ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 = 24 AND a.field_id = 9
159μ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 = 24 AND a.field_id = 10
161μ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 = 24 AND a.field_id = 11
145μ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 = 24 AND a.field_id = 12
136μ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 = 24 AND a.field_id = 13
157μ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 = 24 AND a.field_id = 14
170μ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 = 24 AND a.scope = 0
879μ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 = 24
392μ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 = 24
176μ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 = 24
162μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '23'
226μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '26'
453μs9.56KB/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.26'
678μs688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '196'
222μ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 = 26
187μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (8) AND `reference_table`= 'sr_reservation_assets'
343μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT 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 = 23 AND a.field_id = 8
349μ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 = 23 AND a.field_id = 9
120μ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 = 23 AND a.field_id = 10
103μ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 = 23 AND a.field_id = 11
798μ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 = 23 AND a.field_id = 12
135μ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 = 23 AND a.field_id = 13
1.09ms536B/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 = 23 AND a.field_id = 14
151μ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 = 23 AND a.scope = 0
290μ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 = 23
278μ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 = 23
135μ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 = 23
127μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '22'
183μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '27'
373μs9.56KB/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.27'
593μs688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '85'
213μ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 = 27
193μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (8) AND `reference_table`= 'sr_reservation_assets'
239μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT 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 = 22 AND a.field_id = 8
198μ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 = 22 AND a.field_id = 9
153μ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 = 22 AND a.field_id = 10
158μ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 = 22 AND a.field_id = 11
141μ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 = 22 AND a.field_id = 12
153μ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 = 22 AND a.field_id = 13
153μ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 = 22 AND a.field_id = 14
134μ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 = 22 AND a.scope = 0
617μ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 = 22
175μ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 = 22
165μ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 = 22
161μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.*
FROM `ma37e_sr_reservations` AS `a`
WHERE a.reservation_asset_id = 8 AND a.state = 0
647μs10.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.alias
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = 8
310μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (8) AND `reference_table`= 'sr_reservation_assets'
291μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '29505c56573276defdeb131c96b5c58c' AND `published` = '1'
208μs536B/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 = 8 OR a2.item_id = 8)
445μs704B/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 = 8 OR a2.item_id = 8)
358μs704B/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 = 8 OR a2.item_id = 8)
632μs704B/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 = 8 OR a2.item_id = 8)
325μs704B/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 = 8 OR a2.item_id = 8)
317μs704B/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 = 8 OR a2.item_id = 8)
345μs704B/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 = 8 OR a2.item_id = 8)
316μs704B/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 = 8 OR a2.item_id = 8)
GROUP BY a.field_id
282μs648B/plugins/system/falangdriver/falang_database.php:330CopySELECT COUNT(*)
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 = 8 OR a.item_id = 8) AND a.state = 1
268μs536B/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 = 11 OR a.item_id = 11) AND a.state = 1
ORDER BY a.id DESC LIMIT 3
230μs608B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (30,29) AND `reference_table`= 'sr_reservation_assets'
205μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '30'
150μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '36'
331μs9.56KB/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.36'
3.65ms688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '162'
417μ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 = 36
238μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (11) AND `reference_table`= 'sr_reservation_assets'
253μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '67f637cf5519ed06fd2fe0175587671f' AND `published` = '1'
172μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'd0b52c6397c66026e00207cb7f13e47f' AND `published` = '1'
135μs520B/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 = 30 AND a.field_id = 8
233μ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 = 30 AND a.field_id = 9
268μ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 = 30 AND a.field_id = 10
195μ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 = 30 AND a.field_id = 11
155μ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 = 30 AND a.field_id = 12
134μ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 = 30 AND a.field_id = 13
158μ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 = 30 AND a.field_id = 14
162μ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 = 30 AND a.scope = 0
311μ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 = 30
182μ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 = 30
145μ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 = 30
142μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '29'
174μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '35'
401μs9.56KB/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.35'
3.14ms688B/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 = 35
324μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (11) AND `reference_table`= 'sr_reservation_assets'
2.93ms688B/plugins/system/falangdriver/falang_database.php:325CopySELECT 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 = 29 AND a.field_id = 8
1.22ms536B/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 = 29 AND a.field_id = 9
222μ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 = 29 AND a.field_id = 10
173μ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 = 29 AND a.field_id = 11
173μ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 = 29 AND a.field_id = 12
202μ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 = 29 AND a.field_id = 13
150μ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 = 29 AND a.field_id = 14
162μ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 = 29 AND a.scope = 0
304μ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 = 29
174μ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 = 29
174μ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 = 29
173μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.*
FROM `ma37e_sr_reservations` AS `a`
WHERE a.reservation_asset_id = 11 AND a.state = 0
553μs9.58KB/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 = 11 OR a2.item_id = 11)
685μs608B/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 = 11 OR a2.item_id = 11)
534μs608B/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 = 11 OR a2.item_id = 11)
303μs608B/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 = 11 OR a2.item_id = 11)
425μs608B/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 = 11 OR a2.item_id = 11)
682μs608B/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 = 11 OR a2.item_id = 11)
391μs608B/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 = 11 OR a2.item_id = 11)
404μs608B/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 = 11 OR a2.item_id = 11)
GROUP BY a.field_id
417μs648B/plugins/system/falangdriver/falang_database.php:330CopySELECT COUNT(*)
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 = 11 OR a.item_id = 11) AND a.state = 1
221μs536B/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
ORDER BY a.id DESC LIMIT 3
245μ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
410μ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)
634μ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)
381μ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)
466μ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)
276μ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)
346μ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)
287μ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)
380μ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
215μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'd9f7580fa0f697d40bfc14a77ac4cf2a' AND `published` = '1'
346μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '21343396d308bf38e8b26175a411e950' AND `published` = '1'
231μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '4eabb91af189e193b65d3ccbd06c2f06' AND `published` = '1'
153μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.alias
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = 12
165μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (12) AND `reference_table`= 'sr_reservation_assets'
246μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '14a4ca47e2a790562ac052a8ad621865' AND `published` = '1'
205μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '9bb49cbae8aaad1eefc5c508505bbc01' AND `published` = '1'
159μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '7db9007e319126d8112e5a406da09e73' AND `published` = '1'
146μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '6938729821ecd379150fd94ebc975a74' AND `published` = '1'
214μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '6fad21454afee0cf7b39bd6c7c20b725' AND `published` = '1'
146μs32.51KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '952178fe0b9fd3586ec465f8e59fc5c4' AND `published` = '1'
148μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.alias
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = 15
175μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (15) AND `reference_table`= 'sr_reservation_assets'
618μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '51985ae18745e5f10eb5aaee67a05fb9' AND `published` = '1'
164μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '314807599088a6b364e4f84c1a5f90e6' AND `published` = '1'
100μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'cc41870b9d8bc667fdb1812ec850b38d' AND `published` = '1'
457μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '4e5ebeb18e29e7751348a885bd160540' AND `published` = '1'
256μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '8b83049662581380c1e29e1722108243' AND `published` = '1'
243μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '736b0533a5afe2803dc2f048a1a46064' AND `published` = '1'
142μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.alias
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = 11
196μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (11) AND `reference_table`= 'sr_reservation_assets'
267μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'f7dfeef825eae7abdce1f92b29038391' AND `published` = '1'
200μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'ac83cfa5e48350f3444e9d14944a5d89' AND `published` = '1'
199μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'fcde53e193bdb979b620abd41696a890' AND `published` = '1'
155μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'e2f20ace9c218c308d8aa1c8bfe88696' AND `published` = '1'
219μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '1b0f2ee302bf636f36617e367fac0380' AND `published` = '1'
167μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '5331721f6549999d5232481bd9a67708' AND `published` = '1'
133μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '4324b54d68376ec730d87c65c5da1a22' AND `published` = '1'
297μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '9cffb3d4fac2ef8edc4616a3fec083fa' AND `published` = '1'
198μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `language`,`id`
FROM `ma37e_menu`
WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0
3.62ms592B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1395) AND `reference_table`= 'menu'
371μ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
413μs1.38KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `url` = 'ru/hotels/montenegro-hotels-1?categories[0]=14&default_search_ordering=0&mode=list' AND `published` = '1'
170ms536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `id`
FROM `ma37e_rsseo_pages`
WHERE (`url` = 'ru/hotels/montenegro-hotels-1?categories[0]=14&default_search_ordering=0&mode=list' OR `sef` = 'hotels/montenegro-hotels-1?categories[0]=14&default_search_ordering=0&mode=list')
170ms536B/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` = 'ru/hotels/montenegro-hotels-1?categories[0]=14&default_search_ordering=0&mode=list' OR `sef` = 'hotels/montenegro-hotels-1?categories[0]=14&default_search_ordering=0&mode=list') LIMIT 1
2.44ms1.44KB/plugins/system/falangdriver/falang_database.php:330CopyUPDATE `ma37e_rsseo_pages`
SET `hits` = `hits` + 1
WHERE `id` = '1641'
257μs48B/plugins/system/falangdriver/falang_database.php:133CopySELECT `id`,`date`
FROM `ma37e_rsseo_visitors`
WHERE `session_id` = 'aedc3f8f507bbb449ec3b69b2437967b'
ORDER BY `date` DESC
256μs528B/plugins/system/falangdriver/falang_database.php:330CopyINSERT INTO `ma37e_rsseo_visitors`
SET `session_id` = 'aedc3f8f507bbb449ec3b69b2437967b'
, `date` = '2025-06-11 03:59:20'
, `ip` = '216.73.216.11'
, `user_id` = '0'
, `agent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
, `referer` = ''
, `page` = 'ru/hotels/montenegro-hotels-1?categories[0]=14&default_search_ordering=0&mode=list'
170μs0B/plugins/system/falangdriver/falang_database.php:133CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '2e23bf8ee97513cc6b144cbc429013d9' AND `published` = '1'
368μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '0383457d6e8203aa05dafba524e5a5da' AND `published` = '1'
403μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '2a63a9953c4c0c9d384dc6af1bc76ed8' AND `published` = '1'
194μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '346335dffa61b517f9de8ea4730f56ab' AND `published` = '1'
137μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'f2fb8e9594868259894aebc3068e22d7' AND `published` = '1'
151μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '80e93d39f095cd4aaab6a341f7b7670d' AND `published` = '1'
181μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '953f609d0cc5afdfafa5168c8d3f35d4' AND `published` = '1'
144μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'bded01ca982ee142ee716074895a13a1' AND `published` = '1'
133μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '5f78df90e883c8d76e3fbc84f7c6b6dd' AND `published` = '1'
150μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '9a0e4be468ef5960fe6c99236517a9a6' AND `published` = '1'
534μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'f12ced187eab3f6d857043e67ba826d5' AND `published` = '1'
222μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '44b415bce6eae74ee05e63be9807cdbd' AND `published` = '1'
180μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '5d0e2f7fec5e61a4f52e13cd1b9992cd' AND `published` = '1'
198μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'b358333ee539fded20e4193c07de3167' AND `published` = '1'
181μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '2117e72cf483d65a5f2fcd2f4a0e1436' AND `published` = '1'
150μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `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.93ms62.22KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (214,215,223,109,104,134,101,159,161,91,17,222,108,212,229,230,150,142,196,87,96) AND `reference_table`= 'modules'
1.03ms688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'b5d63bb853588615ab3621978150a51d' AND `published` = '1'
497μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '6b8f33511a5de7542331e1a08f363a19' AND `published` = '1'
390μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '51ca59d644a83829cd4398b02f1995ce' AND `published` = '1'
262μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '6a62bc7b1cc4c59a04d2fb4a4e65e0ee' AND `published` = '1'
236μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'ab1511bd9f131fc0a4a6a6f598e193bb' AND `published` = '1'
258μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '8b3d68822997769eecd791fb1880b5bf' AND `published` = '1'
209μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '1f72c7aedba930b7e385658e5aac5d05' AND `published` = '1'
208μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'c385e8469bd1e1923ab6cca55c9c9af4' AND `published` = '1'
1.29ms536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'a2b987997bf3906aebbb89ae124d18e6' AND `published` = '1'
453μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_rsseo_data`
297μs576B/plugins/system/falangdriver/falang_database.php:330Copyselect enabled from ma37e_extensions where type="component" and element = "com_content"
522μ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
616μ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-06-11 03:59:22' )
AND ( ISNULL(content.publish_down) OR content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2025-06-11 03:59:22' )
AND ( content.catid = 18 OR content.catid = 19 )
AND content.language in ('ru-RU','*')
AND content.featured = 0
ORDER BY
content.created DESC
LIMIT
0,5;
601μs584B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (40,29,30,31) AND `reference_table`= 'content'
479μ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 = 29 OR content.id = 30 OR content.id = 31)
ORDER BY
content.created DESC
464μs2.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (40,29,30,31) AND `reference_table`= 'content'
371μ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`
1.2ms3.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`
914μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 40 AND fc.language_id = 6 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'
350μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 18 AND fc.language_id = 6 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'categories'
250μs520B/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`
798μ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`
1.59ms3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 29 AND fc.language_id = 6 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'
383μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 18 AND fc.language_id = 6 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'categories'
339μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '58d7d58171e09ad0496d8aee326e7990' AND `published` = '1'
227μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'a99883f5dbb12c320ece7069ea2529bf' AND `published` = '1'
202μ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`
841μ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`
512μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 30 AND fc.language_id = 6 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'
268μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 18 AND fc.language_id = 6 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'categories'
197μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '9ee3ad58303c3ac32d224d5feb7b5825' AND `published` = '1'
188μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '679366fc2de5f7b6165e816da22a4923' AND `published` = '1'
166μ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`
687μ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`
562μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 31 AND fc.language_id = 6 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'
342μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 18 AND fc.language_id = 6 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'categories'
220μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'e4aa3c2b0392e4a4554a7084d0c7e3cb' AND `published` = '1'
214μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'a9f3f0d507c7ba08e188abad4fde029a' AND `published` = '1'
233μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_list WHERE `type` = 'standard'
595μs1.67KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_field WHERE `id` IN(2) ORDER BY `ordering` ASC
284μs1.66KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '9a4e1d61742dbfeb9574f149109193e3' AND `published` = '1'
484μ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
1.76ms23.09KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1,2,3,4) AND `reference_table`= 'content'
671μ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`
7.71ms3.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`
2.68ms3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1 AND fc.language_id = 6 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'
624μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '97a10a30b1f5a51f2180038aef5975c7' AND `published` = '1'
440μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '7b3d2517f0c1ab908aaf53e2316998ed' AND `published` = '1'
279μ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`
665μ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`
646μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 2 AND fc.language_id = 6 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'
308μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '2c08c35b5132cbb67f264291691b337f' AND `published` = '1'
219μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'f6e17b46f2439676f9269752263ebb93' AND `published` = '1'
169μ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`
4.36ms3.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`
819μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 3 AND fc.language_id = 6 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'
355μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'a6dc6558a3e15589d4f9a8406cedcf61' AND `published` = '1'
203μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'c60e7f7ac6a27ac8045146ec5531571d' AND `published` = '1'
169μ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`
779μ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`
1.16ms3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 4 AND fc.language_id = 6 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'
640μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '54c58ca5243dca0a16f0a5c2d2cfc3fb' AND `published` = '1'
4.65ms520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'e1e8b02972a3a5ac26eb9a84cc96b02d' AND `published` = '1'
351μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '0b27745a2b146677f97846a54d45c507' AND `published` = '1'
279μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sppagebuilder`
WHERE `extension` = 'mod_sppagebuilder' AND `extension_view` = 'module' AND `view_id` = '229'
860μs139KB/plugins/system/falangdriver/falang_database.php:330CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
280μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT enabled
FROM `ma37e_extensions`
WHERE `name` = 'com_easystore'
469μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `template`
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `home` = 1
269μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id
FROM (
SELECT id,title,level,published,parent_id,lft,rgt
FROM ma37e_tags
WHERE `published` = '1') AS a
LEFT JOIN `ma37e_tags` AS b ON a.lft > b.lft AND a.rgt < b.rgt
WHERE `a`.`level` != '0'
ORDER BY a.lft ASC
535μs848B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id,a.title
FROM `ma37e_tags` AS `a`
WHERE `id` = '2' AND `published` = 1
261μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.enabled
FROM `ma37e_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'
425μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.enabled
FROM `ma37e_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'
239μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id
FROM (
SELECT id,title,level,published,parent_id,lft,rgt
FROM ma37e_tags
WHERE `published` = '1') AS a
LEFT JOIN `ma37e_tags` AS b ON a.lft > b.lft AND a.rgt < b.rgt
WHERE `a`.`level` != '0'
ORDER BY a.lft ASC
3.04ms848B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id,a.title
FROM `ma37e_tags` AS `a`
WHERE `id` = '2' AND `published` = 1
287μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.enabled
FROM `ma37e_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'
367μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT id,collection_id,value,item_id
FROM `ma37e_sppagebuilder_collection_fields` AS `collection_field`
LEFT JOIN `ma37e_sppagebuilder_collection_item_values` AS `collection_item_value` ON (`collection_item_value`.`field_id` = `collection_field`.`id`)
WHERE `collection_field`.`type` = 'title'
ORDER BY `collection_item_value`.`item_id` ASC
485μs704B/plugins/system/falangdriver/falang_database.php:330CopySELECT id,title,alias
FROM `ma37e_sppagebuilder_collections` AS `collection`
WHERE `collection`.`published` = 1
ORDER BY `collection`.`ordering` ASC
230μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT COUNT(id) as total
FROM `ma37e_sppagebuilder_collection_items` AS `collection_item`
WHERE `collection_item`.`collection_id` = 1
188μs536B/plugins/system/falangdriver/falang_database.php:133CopySELECT COUNT(id) as total
FROM `ma37e_sppagebuilder_collection_items` AS `collection_item`
WHERE `collection_item`.`collection_id` = 1
117μs0B/plugins/system/falangdriver/falang_database.php:330CopySELECT id,collection_id,value,item_id
FROM `ma37e_sppagebuilder_collection_fields` AS `collection_field`
LEFT JOIN `ma37e_sppagebuilder_collection_item_values` AS `collection_item_value` ON (`collection_item_value`.`field_id` = `collection_field`.`id`)
WHERE `collection_field`.`type` = 'title'
ORDER BY `collection_item_value`.`item_id` ASC
254μs704B/plugins/system/falangdriver/falang_database.php:330CopySELECT id,title,alias
FROM `ma37e_sppagebuilder_collections` AS `collection`
WHERE `collection`.`published` = 1
ORDER BY `collection`.`ordering` ASC
146μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT COUNT(id) as total
FROM `ma37e_sppagebuilder_collection_items` AS `collection_item`
WHERE `collection_item`.`collection_id` = 1
243μs536B/plugins/system/falangdriver/falang_database.php:133CopySELECT COUNT(id) as total
FROM `ma37e_sppagebuilder_collection_items` AS `collection_item`
WHERE `collection_item`.`collection_id` = 1
112μs0B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.enabled
FROM `ma37e_extensions` AS `a`
WHERE (`a`.`element` = 'com_acymailing' OR `a`.`element` = 'com_acym')
420μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE e.element = 'com_acymailing' OR e.element = 'com_acym'
206μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `id`,`name`
FROM `ma37e_acym_list`
WHERE `active` = '1'
ORDER BY name DESC
167μs608B/plugins/system/falangdriver/falang_database.php:330CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
429μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
165μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT `a`.`name`,`a`.`css_path`
FROM `ma37e_sppagebuilder_assets` AS `a`
WHERE `a`.`published` = 1
142μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
303μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
139μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT `template`
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `home` = 1
234μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sppagebuilder`
WHERE `extension` = 'mod_sppagebuilder' AND `extension_view` = 'module' AND `view_id` = '230'
838μs355KB/plugins/system/falangdriver/falang_database.php:330CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
321μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT enabled
FROM `ma37e_extensions`
WHERE `name` = 'com_easystore'
315μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `template`
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `home` = 1
164μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
358μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
116μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT `a`.`name`,`a`.`css_path`
FROM `ma37e_sppagebuilder_assets` AS `a`
WHERE `a`.`published` = 1
78μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
119μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
114μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT `template`
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `home` = 1
234μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '5e20a82e0b1fcc0ba8dc4437a5228ba9' AND `published` = '1'
406μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'e7b776204e81ef06dfb380da3513488b' AND `published` = '1'
179μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1344 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
273μs520B/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_menu`
878μs1.7KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1344'
219μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1344) AND `reference_table`= 'menu'
209μ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 = 1344 AND p.client_id = 0
ORDER BY p.lft
535μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT m.path
FROM ma37e_menu m
WHERE m.id = 1344
100μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1344 AND fc.language_id = 6 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
162μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1344'
199μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1344) AND `reference_table`= 'menu'
156μ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='6' and jfc.reference_field='alias'
WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 1344 AND p.client_id = 0
ORDER BY p.lft
509μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'bd628c6105d37be5f380f22794ac1b70' AND `published` = '1'
180μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'deb5f792769d5cb1e4b59fc4e1ee74fb' AND `published` = '1'
156μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1344 AND fc.language_id = 2 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
185μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1344'
165μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1344) AND `reference_table`= 'menu'
164μ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 = 1344 AND p.client_id = 0
ORDER BY p.lft
654μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT m.path
FROM ma37e_menu m
WHERE m.id = 1344
103μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1344 AND fc.language_id = 6 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
181μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1344'
148μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1344) AND `reference_table`= 'menu'
155μ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='6' and jfc.reference_field='alias'
WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 1344 AND p.client_id = 0
ORDER BY p.lft
568μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '477901119a29b1239161406ab225e6fb' AND `published` = '1'
199μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'a3e60dad8226dc2b91a9cae098af086c' AND `published` = '1'
167μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1344 AND fc.language_id = 3 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
291μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1344'
237μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1344) AND `reference_table`= 'menu'
185μ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 = 1344 AND p.client_id = 0
ORDER BY p.lft
777μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT m.path
FROM ma37e_menu m
WHERE m.id = 1344
124μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1344 AND fc.language_id = 6 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
191μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1344'
174μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1344) AND `reference_table`= 'menu'
179μ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='6' and jfc.reference_field='alias'
WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 1344 AND p.client_id = 0
ORDER BY p.lft
789μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'd62ed013eacfaa1105ebcd2cdd088b31' AND `published` = '1'
173μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '860e5a525da4980dcec02cec3cc57394' AND `published` = '1'
158μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1344 AND fc.language_id = 4 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
178μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1344'
162μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1344) AND `reference_table`= 'menu'
169μ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 = 1344 AND p.client_id = 0
ORDER BY p.lft
544μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT m.path
FROM ma37e_menu m
WHERE m.id = 1344
112μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1344 AND fc.language_id = 6 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
180μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1344'
163μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1344) AND `reference_table`= 'menu'
153μ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='6' and jfc.reference_field='alias'
WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 1344 AND p.client_id = 0
ORDER BY p.lft
466μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '5f67fe10f381a307df1f8f8096345d40' AND `published` = '1'
232μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '7009889bcf3dec7ceb4cc442049bb71a' AND `published` = '1'
190μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1344 AND fc.language_id = 5 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
281μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1344'
265μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1344) AND `reference_table`= 'menu'
294μ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 = 1344 AND p.client_id = 0
ORDER BY p.lft
770μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT m.path
FROM ma37e_menu m
WHERE m.id = 1344
208μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1344 AND fc.language_id = 6 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
258μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1344'
241μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=6 AND `published`= 1 AND `reference_id`IN (1344) AND `reference_table`= 'menu'
232μ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='6' and jfc.reference_field='alias'
WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 1344 AND p.client_id = 0
ORDER BY p.lft
747μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'a62748eeea02d28e0480f06b72a8dd82' AND `published` = '1'
408μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'e3eb6b495e478ec7bb857abb409c41ba' AND `published` = '1'
167μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '9809bb3e65fc0cb7c4bfc39ce0dae324' AND `published` = '1'
159μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '926020332386a044ae16dfc28e61b645' AND `published` = '1'
135μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_list WHERE type = 'standard'
2.93ms1.67KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_field
314μs1.69KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_form WHERE active = 1 AND type != 'shortcode'
193μ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
453μs1.37KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `value` FROM ma37e_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"
362μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT data_key, data_value
FROM `ma37e_sr_config_data`
WHERE scope_id = 0
889μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_rsseo_keywords`
ORDER BY CHAR_LENGTH(keyword) DESC
148μs1.28KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `id`,`css`,`scripts`
FROM `ma37e_rsseo_pages`
WHERE `published` = 1 AND (`url` = 'ru/hotels/montenegro-hotels-1?categories[0]=14&default_search_ordering=0&mode=list' OR `sef` = 'hotels/montenegro-hotels-1?categories[0]=14&default_search_ordering=0&mode=list') LIMIT 1
5.3ms656B/plugins/system/falangdriver/falang_database.php:330Copy