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) (32.96%) | 828ms |
1 x afterInitialise (3.45MB) (16.3%) | 410ms |
1 x afterDispatch (124.6KB) (15.88%) | 399ms |
1 x Before Access::preloadComponents (all components) (2.79MB) (5.59%) | 140ms |
1 x afterRenderRawModule mod_sppagebuilder (countries flags for main) (3.72MB) (4.43%) | 111ms |
1 x afterLoad (355.64KB) (4.19%) | 105ms |
1 x afterRender (720.26KB) (3.33%) | 83.79ms |
1 x afterRenderRawModule mod_sppagebuilder (Top Resorts for main) (1.21MB) (3.22%) | 80.87ms |
1 x afterRenderRawModule mod_falang (FaLang Language Switcher) (728.59KB) (2.88%) | 72.35ms |
1 x afterRoute (1.42MB) (2.86%) | 71.89ms |
1 x beforeRenderRawModule mod_menu (Main Menu) (709.89KB) (1.99%) | 49.97ms |
1 x afterRenderRawModule mod_news_pro_gk5 (тест статьи джумла) (578.72KB) (1.73%) | 43.51ms |
1 x afterRenderRawModule mod_articles_latest (LATEST NEWS) (407.58KB) (1.56%) | 39.29ms |
1 x afterRenderRawModule mod_menu (Main Menu) (248.98KB) (0.58%) | 14.51ms |
1 x afterRenderRawModule mod_acym (STAY UP TO DATE) (43.48KB) (0.42%) | 10.67ms |
1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (8.84KB) (0.28%) | 6.99ms |
1 x afterRenderRawModule mod_menu (for Main-prototip-menu) (54.52KB) (0.21%) | 5.24ms |
1 x afterRenderRawModule mod_sp_weather (Weather) (30.65KB) (0.15%) | 3.85ms |
1 x afterRenderRawModule mod_menu (Bottom Menu) (20.91KB) (0.14%) | 3.51ms |
1 x afterRenderRawModule mod_menu (для меню Ru) (5.33KB) (0.12%) | 3.08ms |
1 x Before Access::getAssetRules (id:1 name:root.1) (12.66KB) (0.12%) | 3.04ms |
1 x beforeRenderRawModule mod_news_pro_gk5 (тест статьи джумла) (97.69KB) (0.12%) | 3.00ms |
1 x afterRenderRawModule mod_custom (Copyright) (68.84KB) (0.08%) | 1.97ms |
1 x After Access::preloadComponents (all components) (117.06KB) (0.07%) | 1.87ms |
1 x afterRenderModule mod_menu (Main Menu) (248B) (0.06%) | 1.60ms |
1 x afterRenderModule mod_sppagebuilder (Top Resorts for main) (146.47KB) (0.06%) | 1.45ms |
1 x beforeRenderComponent com_solidres (68.99KB) (0.06%) | 1.40ms |
1 x afterRenderModule mod_sppagebuilder (countries flags for main) (42.47KB) (0.04%) | 1.04ms |
1 x afterRenderModule mod_articles_latest (LATEST NEWS) (3.25KB) (0.04%) | 973μs |
1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.38KB) (0.03%) | 841μs |
1 x afterRenderModule mod_menu (Bottom Menu) (2.88KB) (0.03%) | 813μs |
1 x afterRenderModule mod_falang (FaLang Language Switcher) (6.77KB) (0.03%) | 805μs |
1 x afterRenderModule mod_custom (Copyright) (2.83KB) (0.03%) | 801μs |
1 x afterRenderModule mod_acym (STAY UP TO DATE) (4.95KB) (0.03%) | 733μs |
1 x After Access::getAssetRules (id:124 name:com_solidres) (11.85KB) (0.03%) | 704μs |
1 x afterRenderModule mod_custom (Contact Details) (3.2KB) (0.03%) | 681μs |
1 x afterRenderModule mod_menu (for Main-prototip-menu) (4.38KB) (0.03%) | 657μs |
1 x afterRenderModule mod_sp_weather (Weather) (3.66KB) (0.03%) | 636μs |
1 x afterRenderModule mod_custom (RESERVATION HOTLINE) (2.83KB) (0.02%) | 575μs |
1 x beforeRenderRawModule mod_custom (Copyright) (88.71KB) (0.02%) | 481μs |
1 x afterRenderModule mod_menu (для меню Ru) (3.69KB) (0.02%) | 435μs |
1 x afterRenderModule mod_custom (Social Icons) (2.95KB) (0.02%) | 410μs |
1 x afterRenderModule mod_news_pro_gk5 (тест статьи джумла) (5.08KB) (0.02%) | 401μs |
1 x afterRenderModule mod_custom (Map Icon) (2.69KB) (0.01%) | 375μs |
1 x beforeRenderRawModule mod_custom (Contact Details) (2.49KB) (0.01%) | 205μs |
1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (264B) (0.01%) | 177μs |
1 x beforeRenderRawModule mod_sppagebuilder (countries flags for main) (600B) (0.01%) | 160μs |
1 x beforeRenderRawModule mod_acym (STAY UP TO DATE) (1.52KB) (0.01%) | 158μs |
1 x beforeRenderRawModule mod_custom (RESERVATION HOTLINE) (824B) (0.01%) | 157μs |
1 x beforeRenderRawModule mod_menu (для меню Ru) (1.46KB) (0.01%) | 151μs |
1 x beforeRenderRawModule mod_custom (Social Icons) (424B) (0.01%) | 149μs |
1 x beforeRenderRawModule mod_falang (FaLang Language Switcher) (480B) (0.01%) | 147μs |
1 x beforeRenderRawModule mod_menu (Bottom Menu) (1.95KB) (0.01%) | 131μs |
1 x beforeRenderRawModule mod_menu (for Main-prototip-menu) (552B) (0%) | 125μs |
1 x afterRenderRawModule mod_custom (RESERVATION HOTLINE) (928B) (0%) | 123μs |
1 x afterRenderRawModule mod_custom (Contact Details) (832B) (0%) | 121μs |
1 x beforeRenderRawModule mod_articles_latest (LATEST NEWS) (2.82KB) (0%) | 113μs |
1 x afterRenderRawModule mod_custom (Map Icon) (928B) (0%) | 89μs |
1 x beforeRenderRawModule mod_sp_weather (Weather) (3.84KB) (0%) | 67μs |
1 x afterRenderRawModule mod_custom (Social Icons) (896B) (0%) | 66μs |
1 x beforeRenderRawModule mod_custom (Map Icon) (3.44KB) (0%) | 41μs |
1 x Before Access::getAssetRules (id:124 name:com_solidres) (1.32KB) (0%) | 38μs |
1 x beforeRenderRawModule mod_sppagebuilder (Top Resorts for main) (880B) (0%) | 34μs |
1 x After Access::getAssetRules (id:1 name:root.1) (6.02KB) (0%) | 33μs |
1 x beforeRenderModule mod_falang (FaLang Language Switcher) (736B) (0%) | 19μs |
1 x beforeRenderModule mod_menu (for Main-prototip-menu) (720B) (0%) | 19μs |
1 x beforeRenderModule mod_menu (Bottom Menu) (720B) (0%) | 17μs |
1 x beforeRenderModule mod_custom (Copyright) (720B) (0%) | 16μs |
1 x beforeRenderModule mod_articles_latest (LATEST NEWS) (704B) (0%) | 16μs |
1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%) | 14μs |
1 x beforeRenderModule mod_news_pro_gk5 (тест статьи джумла) (752B) (0%) | 14μs |
1 x beforeRenderModule mod_acym (STAY UP TO DATE) (720B) (0%) | 12μs |
1 x beforeRenderModule mod_sppagebuilder (Top Resorts for main) (736B) (0%) | 12μs |
1 x beforeRenderModule mod_menu (для меню Ru) (720B) (0%) | 11μs |
1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%) | 11μs |
1 x beforeRenderModule mod_sp_weather (Weather) (720B) (0%) | 11μs |
1 x beforeRenderModule mod_sppagebuilder (countries flags for main) (736B) (0%) | 9μs |
1 x beforeRenderModule mod_custom (Contact Details) (720B) (0%) | 4μs |
1 x beforeRenderModule mod_custom (Map Icon) (720B) (0%) | 3μs |
1 x beforeRenderModule mod_custom (Social Icons) (720B) (0%) | 2μs |
1 x beforeRenderModule mod_custom (RESERVATION HOTLINE) (720B) (0%) | 2μs |
select distinct reference_table from ma37e_falang_content
225μs1.02KB/plugins/system/falangdriver/falang_database.php:224CopySELECT `params`
FROM `ma37e_extensions`
WHERE `type` = 'component' AND `element` = 'com_rsseo'
282μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_rsseo_redirects`
WHERE `published` = 1
192μ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'
151ms576B/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'
306μs840B/plugins/system/falangdriver/falang_database.php:330CopySELECT `url`
FROM `ma37e_rsseo_pages`
WHERE `sef` = 'ru/hotels/montenegro-hotels-1'
302μ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`
1.19ms60.05KBParams/plugins/system/falangdriver/falang_database.php:133CopySELECT joomlatablename,tablepkID FROM `ma37e_falang_tableinfo`
204μs1.06KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_languages`
223μ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'
443μ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'
205μ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'
174μ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'
141μ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'
139μ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'
143μ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'
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 (1370) AND `reference_table`= 'menu'
122μ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'
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 (1378) AND `reference_table`= 'menu'
136μ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'
121μ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'
441μ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'
114μ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'
115μ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'
169μ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'
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 (1335) AND `reference_table`= 'menu'
141μ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'
311μ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'
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 (1340) AND `reference_table`= 'menu'
91μ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'
77μ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'
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 (102) AND `reference_table`= 'menu'
137μ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'
376μ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'
209μ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'
204μ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'
197μ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'
234μ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'
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 (1381) AND `reference_table`= 'menu'
154μ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'
160μ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'
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 (1385) 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 (1384) AND `reference_table`= 'menu'
146μ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'
165μ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'
88μ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'
107μ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'
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 (1397) 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 (1408) AND `reference_table`= 'menu'
108μ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'
159μ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'
103μs688B/plugins/system/falangdriver/falang_database.php:325CopySHOW FULL TABLES WHERE table_type="BASE TABLE"
2.07ms4.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_plugin
166μs1.5KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_configuration
194μs2.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_plugin
228μs1.5KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value`
FROM ma37e_usergroups AS `groups`
269μ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
633μ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)
931μs7.81KBParams/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_currencies`
1.75ms1.39KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_currencies`
WHERE `id` = '2'
636μs896B/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_categories`
3.33ms1.7KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_categories`
WHERE `id` = '14'
1.83ms3KB/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)
371μ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
1.02ms1.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'
636μs11.83KB/plugins/system/falangdriver/falang_database.php:325CopySHOW FULL COLUMNS FROM `ma37e_sr_reservation_assets`
3.95ms2.14KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '12'
624μ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'
527μ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)
1.06ms1.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)
251μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_countries`
1.07ms1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '189'
181μs1.47KB/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_geo_states`
828μs1.36KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_currencies`
WHERE `id` = '1'
294μ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
1.25ms3.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'
658μ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'
304μs688B/plugins/system/falangdriver/falang_database.php:325CopySHOW FULL COLUMNS FROM `ma37e_sr_customers`
1.91ms1.58KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_customers`
WHERE `id` = '31'
1.28ms2.5KB/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_users`
1.21ms1.58KB/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_customer_groups`
1.32ms1.31KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_users`
WHERE `id` = :userid
1.28ms3.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
611μs1.38KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '12'
203μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_currencies`
WHERE `id` = 1
437μs896B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_currencies`
WHERE `id` = 2
150μ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
393μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '24'
137μ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
435μs3.05KB/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_tariffs`
1.33ms1.7KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '52'
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 = 52
ORDER BY t.w_day ASC
3.34ms1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '91'
517μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT occupancy_adult, occupancy_child, occupancy_child_age_range
FROM `ma37e_sr_room_types`
WHERE id = '24'
230μ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
486μ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
287μ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
269μ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
220μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 24
142μ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
178μ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'
402μ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.%'
174μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '25'
128μ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
627μs3.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '55'
204μ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
317μs1.66KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '94'
211μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT occupancy_adult, occupancy_child, occupancy_child_age_range
FROM `ma37e_sr_room_types`
WHERE id = '25'
160μ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
467μ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
225μ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
185μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 25
145μ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
157μ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'
388μ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.%'
180μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 12
157μ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
165μ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'
279μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 12
453μs568B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 12
156μ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.%'
1.07ms1KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '14'
303μ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'
603μ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)
351μ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)
229μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '3'
342μs1.47KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_geo_states`
WHERE `id` = '523'
2.67ms832B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_currencies`
WHERE `id` = '2'
367μ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
1.02ms11.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'
244μ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'
174μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '14'
141μ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
341μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '30'
105μ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
554μs3.02KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 30
117μ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.%'
220μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 14
299μ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
186μ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'
415μs704B/plugins/system/falangdriver/falang_database.php:325CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 14
132μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 14
132μ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.%'
383μs960B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '15'
319μ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'
304μ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)
193μ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)
184μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_geo_states`
WHERE `id` = '523'
180μ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
786μs3.02KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '15'
135μ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
334μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 15
223μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 15
151μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 15
153μ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.%'
515μs960B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '8'
750μ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'
513μ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)
331μ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)
238μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '224'
325μs1.47KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_geo_states`
WHERE `id` = '11'
227μ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
2.01ms3.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'
617μ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'
377μs720B/plugins/system/falangdriver/falang_database.php:325CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '8'
162μ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
711μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '15'
126μ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
266μs3.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '12'
291μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT occupancy_adult, occupancy_child, occupancy_child_age_range
FROM `ma37e_sr_room_types`
WHERE id = '15'
224μ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
321μ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
900μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '84'
409μ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
461μ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
326μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 15
153μ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
217μ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'
475μ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.%'
210μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '16'
128μ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
1.44ms3.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '8'
319μ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
354μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '83'
184μ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
161μs1.66KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 16
93μ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
116μ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'
308μ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.%'
196μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '17'
84μ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
392μs3.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '42'
905μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT occupancy_adult, occupancy_child, occupancy_child_age_range
FROM `ma37e_sr_room_types`
WHERE id = '17'
532μ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
256μ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
189μs1.66KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '82'
199μ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
222μ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
202μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 17
173μ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
158μ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'
395μ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.%'
200μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '18'
97μ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
398μs3.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '6'
247μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT occupancy_adult, occupancy_child, occupancy_child_age_range
FROM `ma37e_sr_room_types`
WHERE id = '18'
142μ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
377μ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
357μ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
237μ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
269μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '7'
206μ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
327μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 18
191μ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
179μ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'
578μ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.%'
201μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '19'
199μ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
646μs3.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '13'
446μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT occupancy_adult, occupancy_child, occupancy_child_age_range
FROM `ma37e_sr_room_types`
WHERE id = '19'
195μ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
437μ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
288μ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
360μ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
265μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '85'
243μ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
307μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 19
798μ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
269μ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'
630μ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.%'
281μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 8
148μ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
161μ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'
321μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 8
137μs568B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 8
128μ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.%'
418μs960B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '11'
373μ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'
459μ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)
1.7ms1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '106'
233μ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
2.51ms3.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'
590μ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'
258μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '11'
136μ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
8.56ms2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '26'
315μ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
532μs3.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '58'
230μ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
311μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '88'
212μs3KB/plugins/system/falangdriver/falang_database.php:330CopySELECT occupancy_adult, occupancy_child, occupancy_child_age_range
FROM `ma37e_sr_room_types`
WHERE id = '26'
348μ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
444μ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
447μ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
600μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 26
221μ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.%'
220μs16.64KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '27'
122μ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
458μs3.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '81'
188μ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
641μs1.77KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_tariffs`
WHERE `id` = '90'
381μ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
274μs1.66KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 27
154μ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.%'
219μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 11
162μ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
160μ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'
1.35ms688B/plugins/system/falangdriver/falang_database.php:325CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 11
420μs568B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 11
117μ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.%'
423μs1KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '16'
438μ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'
640μ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)
319μ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)
256μs1.34KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_geo_states`
WHERE `id` = '523'
154μ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
664μ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'
726μ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'
362μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '16'
254μ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
502μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '31'
183μ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
705μs3.02KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 31
397μs584B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.title, a.description, a.icon
FROM `ma37e_sr_facilities` AS `a`
WHERE a.id IN (40,32,37,23)
ORDER BY a.ordering ASC
310μ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'
461μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT field_key, field_value
FROM `ma37e_sr_room_type_fields`
WHERE room_type_id = 31 AND field_key LIKE 'roomtype_custom_fields.%'
19.54ms656B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_room_types` AS `a`
WHERE a.id = '32'
486μ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
628μs3.02KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_room_type_xref`
WHERE room_type_id = 32
2.15ms616B/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
352μ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'
420μ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.%'
221μs656B/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 16
186μ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
165μ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
146μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 16
327μ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.%'
704μ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
523μ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'
362μs848B/plugins/system/falangdriver/falang_database.php:325CopySELECT *
FROM `ma37e_categories`
WHERE `id` = '14'
176μ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)
161μ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
1.87ms688B/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
945μ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'
351μs688B/plugins/system/falangdriver/falang_database.php:325CopySHOW FULL COLUMNS FROM `ma37e_sr_feedbacks`
1.61ms1.52KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '32'
496μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_reservations`
1.97ms2.52KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '38'
1ms9.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'a811bf5f1ea7bcb657bcd4fa271b010c' AND `published` = '1'
301μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '4709df96ef5a4a9497162e53063f8a49' AND `published` = '1'
139μ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'
906μs688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '197'
215μ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
221μ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'
318μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '22096093480019112b06fa635b5db9f3' AND `published` = '1'
459μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '264e092573c4c3f6a9fa5989a39a6a0a' AND `published` = '1'
106μ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
252μ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
251μ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
144μ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
166μ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
305μ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
118μ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
110μ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
101μ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
342μ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
230μ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
393μ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
207μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '31'
240μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '37'
841μ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'
1.1ms688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '213'
317μ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
183μ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'
260μ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
703μ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
209μ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
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 = 31 AND a.field_id = 12
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 = 31 AND a.field_id = 13
408μ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
204μ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
459μ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
211μ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
185μ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
183μ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
670μs9.58KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.field
FROM `ma37e_sr_feedback_conditions` AS `a`
WHERE a.scope = 0
777μ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)
722μ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)
7.43ms608B/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)
9.37ms608B/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)
948μ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)
1.76ms608B/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)
848μ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)
1.51ms608B/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
665μ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
410μ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
440μ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
458μ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)
794μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Comfort' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 9 AND (a3.reservation_asset_id = 14 OR a2.item_id = 14)
589μ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)
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 = 14 OR a2.item_id = 14)
369μ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)
362μ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)
330μ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)
354μ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
255μ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
305μ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
511μ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)
525μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Comfort' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 9 AND (a3.reservation_asset_id = 15 OR a2.item_id = 15)
569μ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)
475μ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)
372μ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)
382μ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)
376μ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)
350μ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
279μ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
334μ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'
264μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '24'
224μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '25'
731μ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'
2.6ms688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '235'
317μ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
289μ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'
358μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'ca79ccbea056ae394b5eb00e9d6494be' AND `published` = '1'
262μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '920a0b750fc02dda174038270dea9b65' AND `published` = '1'
160μ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
524μ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
515μ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
179μ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
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 = 24 AND a.field_id = 12
163μ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
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 = 14
167μ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
385μ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
212μ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
159μ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
182μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '23'
225μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '26'
13.57ms9.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'
949μs688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '196'
253μ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
222μ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'
290μ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
293μ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
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 = 23 AND a.field_id = 10
305μ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
171μ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
169μ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
184μ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 = 14
188μ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
351μ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
190μ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
116μ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
109μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '22'
157μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '27'
469μ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'
771μs688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '85'
235μ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
228μ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'
292μ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
231μ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
177μ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
165μ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
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 = 22 AND a.field_id = 12
160μ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
264μ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
166μ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
4.7ms624B/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
607μ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
236μ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
216μ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
3.74ms10.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.alias
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = 8
405μ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'
456μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '29505c56573276defdeb131c96b5c58c' AND `published` = '1'
265μ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)
729μ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)
334μ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)
321μ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)
3.54ms704B/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)
460μ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)
329μ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)
304μ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
318μ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
269μ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
771μ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'
286μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '30'
244μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '36'
3.5ms9.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'
675μs688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '162'
609μ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
384μ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'
355μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '67f637cf5519ed06fd2fe0175587671f' AND `published` = '1'
326μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'd0b52c6397c66026e00207cb7f13e47f' AND `published` = '1'
415μ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
381μ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
169μ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
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 = 30 AND a.field_id = 11
162μ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
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 = 30 AND a.field_id = 13
166μ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
168μ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
454μ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
173μ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
180μ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
161μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '29'
292μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '35'
999μ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'
1.05ms688B/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
446μ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'
268μ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 = 29 AND a.field_id = 8
234μ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 = 9
137μ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
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 = 29 AND a.field_id = 11
146μ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
139μ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
160μ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
143μ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
325μ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
216μ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
253μ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
345μ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
657μ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)
2.75ms608B/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)
747μ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)
580μ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)
562μ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)
488μ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)
363μ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)
347μ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
306μ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
228μ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
519μ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
573μ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)
780μ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)
377μ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)
365μ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)
325μ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)
314μ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)
341μ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)
333μ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
262μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'd9f7580fa0f697d40bfc14a77ac4cf2a' AND `published` = '1'
290μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '21343396d308bf38e8b26175a411e950' AND `published` = '1'
346μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '4eabb91af189e193b65d3ccbd06c2f06' AND `published` = '1'
137μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.alias
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = 12
268μ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'
302μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '14a4ca47e2a790562ac052a8ad621865' AND `published` = '1'
206μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '9bb49cbae8aaad1eefc5c508505bbc01' AND `published` = '1'
151μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '7db9007e319126d8112e5a406da09e73' AND `published` = '1'
138μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '6938729821ecd379150fd94ebc975a74' AND `published` = '1'
193μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '6fad21454afee0cf7b39bd6c7c20b725' AND `published` = '1'
197μs32.51KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '952178fe0b9fd3586ec465f8e59fc5c4' AND `published` = '1'
131μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.alias
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = 15
186μ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'
178μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '51985ae18745e5f10eb5aaee67a05fb9' AND `published` = '1'
136μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '314807599088a6b364e4f84c1a5f90e6' AND `published` = '1'
128μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'cc41870b9d8bc667fdb1812ec850b38d' AND `published` = '1'
131μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '4e5ebeb18e29e7751348a885bd160540' AND `published` = '1'
147μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '8b83049662581380c1e29e1722108243' AND `published` = '1'
140μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '736b0533a5afe2803dc2f048a1a46064' AND `published` = '1'
120μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.alias
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = 11
141μ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'
186μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'f7dfeef825eae7abdce1f92b29038391' AND `published` = '1'
150μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'ac83cfa5e48350f3444e9d14944a5d89' AND `published` = '1'
132μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'fcde53e193bdb979b620abd41696a890' AND `published` = '1'
127μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'e2f20ace9c218c308d8aa1c8bfe88696' AND `published` = '1'
144μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '1b0f2ee302bf636f36617e367fac0380' AND `published` = '1'
135μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '5331721f6549999d5232481bd9a67708' AND `published` = '1'
145μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '4324b54d68376ec730d87c65c5da1a22' AND `published` = '1'
178μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '9cffb3d4fac2ef8edc4616a3fec083fa' AND `published` = '1'
148μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `language`,`id`
FROM `ma37e_menu`
WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0
588μ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 (1395) AND `reference_table`= 'menu'
288μ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
527μ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'
184ms536B/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')
192ms536B/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.23ms1.44KB/plugins/system/falangdriver/falang_database.php:330CopyUPDATE `ma37e_rsseo_pages`
SET `hits` = `hits` + 1
WHERE `id` = '1641'
325μs48B/plugins/system/falangdriver/falang_database.php:133CopySELECT `id`,`date`
FROM `ma37e_rsseo_visitors`
WHERE `session_id` = '605001251e3400a6932fa3dce07ad3c0'
ORDER BY `date` DESC
268μs528B/plugins/system/falangdriver/falang_database.php:330CopyINSERT INTO `ma37e_rsseo_visitors`
SET `session_id` = '605001251e3400a6932fa3dce07ad3c0'
, `date` = '2025-06-12 05:15:43'
, `ip` = '216.73.216.97'
, `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'
154μs0B/plugins/system/falangdriver/falang_database.php:133CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '2e23bf8ee97513cc6b144cbc429013d9' AND `published` = '1'
391μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '0383457d6e8203aa05dafba524e5a5da' AND `published` = '1'
406μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '2a63a9953c4c0c9d384dc6af1bc76ed8' AND `published` = '1'
143μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '346335dffa61b517f9de8ea4730f56ab' AND `published` = '1'
156μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'f2fb8e9594868259894aebc3068e22d7' AND `published` = '1'
112μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '80e93d39f095cd4aaab6a341f7b7670d' AND `published` = '1'
1.85ms536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '953f609d0cc5afdfafa5168c8d3f35d4' AND `published` = '1'
262μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'bded01ca982ee142ee716074895a13a1' AND `published` = '1'
142μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '5f78df90e883c8d76e3fbc84f7c6b6dd' AND `published` = '1'
145μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '9a0e4be468ef5960fe6c99236517a9a6' AND `published` = '1'
141μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'f12ced187eab3f6d857043e67ba826d5' AND `published` = '1'
216μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '44b415bce6eae74ee05e63be9807cdbd' AND `published` = '1'
215μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '5d0e2f7fec5e61a4f52e13cd1b9992cd' AND `published` = '1'
158μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'b358333ee539fded20e4193c07de3167' AND `published` = '1'
133μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '2117e72cf483d65a5f2fcd2f4a0e1436' AND `published` = '1'
144μ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`
2.05ms62.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'
679μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'b5d63bb853588615ab3621978150a51d' AND `published` = '1'
359μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '6b8f33511a5de7542331e1a08f363a19' AND `published` = '1'
185μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '51ca59d644a83829cd4398b02f1995ce' AND `published` = '1'
151μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '6a62bc7b1cc4c59a04d2fb4a4e65e0ee' AND `published` = '1'
127μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'ab1511bd9f131fc0a4a6a6f598e193bb' AND `published` = '1'
143μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '8b3d68822997769eecd791fb1880b5bf' AND `published` = '1'
140μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '1f72c7aedba930b7e385658e5aac5d05' AND `published` = '1'
131μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'c385e8469bd1e1923ab6cca55c9c9af4' AND `published` = '1'
131μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'a2b987997bf3906aebbb89ae124d18e6' AND `published` = '1'
206μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_rsseo_data`
188μs576B/plugins/system/falangdriver/falang_database.php:330Copyselect enabled from ma37e_extensions where type="component" and element = "com_content"
609μ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
522μ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-12 05:15:44' )
AND ( ISNULL(content.publish_down) OR content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2025-06-12 05:15:44' )
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;
392μ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'
319μ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
308μ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'
212μ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.11ms3.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`
902μ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'
599μ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'
180μ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`
546μ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`
547μs3.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'
312μ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'
169μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '58d7d58171e09ad0496d8aee326e7990' AND `published` = '1'
191μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'a99883f5dbb12c320ece7069ea2529bf' AND `published` = '1'
170μ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`
614μ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`
416μ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'
218μ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'
170μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '9ee3ad58303c3ac32d224d5feb7b5825' AND `published` = '1'
190μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '679366fc2de5f7b6165e816da22a4923' AND `published` = '1'
144μ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`
654μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug`
FROM `ma37e_categories` AS `s`
INNER JOIN `ma37e_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
637μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT 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'
507μ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'
237μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'e4aa3c2b0392e4a4554a7084d0c7e3cb' AND `published` = '1'
1.06ms520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'a9f3f0d507c7ba08e188abad4fde029a' AND `published` = '1'
222μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_list WHERE `type` = 'standard'
301μs1.67KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_field WHERE `id` IN(2) ORDER BY `ordering` ASC
165μs1.66KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '9a4e1d61742dbfeb9574f149109193e3' AND `published` = '1'
226μ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.31ms23.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'
638μ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`
465μ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`
634μs3.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'
434μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '97a10a30b1f5a51f2180038aef5975c7' AND `published` = '1'
198μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '7b3d2517f0c1ab908aaf53e2316998ed' AND `published` = '1'
141μ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`
926μ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`
907μ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'
552μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '2c08c35b5132cbb67f264291691b337f' AND `published` = '1'
447μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'f6e17b46f2439676f9269752263ebb93' AND `published` = '1'
217μ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`
1.05ms3.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.01ms3.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'
305μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'a6dc6558a3e15589d4f9a8406cedcf61' AND `published` = '1'
193μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'c60e7f7ac6a27ac8045146ec5531571d' AND `published` = '1'
193μ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`
626μ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.09ms3.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'
400μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '54c58ca5243dca0a16f0a5c2d2cfc3fb' AND `published` = '1'
190μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'e1e8b02972a3a5ac26eb9a84cc96b02d' AND `published` = '1'
221μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '0b27745a2b146677f97846a54d45c507' AND `published` = '1'
370μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sppagebuilder`
WHERE `extension` = 'mod_sppagebuilder' AND `extension_view` = 'module' AND `view_id` = '229'
763μs139KB/plugins/system/falangdriver/falang_database.php:330CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
341μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT enabled
FROM `ma37e_extensions`
WHERE `name` = 'com_easystore'
369μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `template`
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `home` = 1
305μ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
1.42ms848B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id,a.title
FROM `ma37e_tags` AS `a`
WHERE `id` = '2' AND `published` = 1
229μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.enabled
FROM `ma37e_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'
319μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.enabled
FROM `ma37e_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'
322μ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
370μs848B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id,a.title
FROM `ma37e_tags` AS `a`
WHERE `id` = '2' AND `published` = 1
75μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.enabled
FROM `ma37e_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'
232μ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
473μ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
621μ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
273μ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
141μ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
622μ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
403μ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
833μ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
188μ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')
366μ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'
361μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `id`,`name`
FROM `ma37e_acym_list`
WHERE `active` = '1'
ORDER BY name DESC
163μs608B/plugins/system/falangdriver/falang_database.php:330CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
820μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
245μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT `a`.`name`,`a`.`css_path`
FROM `ma37e_sppagebuilder_assets` AS `a`
WHERE `a`.`published` = 1
166μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
175μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
185μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT `template`
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `home` = 1
224μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sppagebuilder`
WHERE `extension` = 'mod_sppagebuilder' AND `extension_view` = 'module' AND `view_id` = '230'
1.24ms355KB/plugins/system/falangdriver/falang_database.php:330CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
425μ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
197μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
2.2ms592B/plugins/system/falangdriver/falang_database.php:330CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
3.53ms592B/plugins/system/falangdriver/falang_database.php:330CopySELECT `a`.`name`,`a`.`css_path`
FROM `ma37e_sppagebuilder_assets` AS `a`
WHERE `a`.`published` = 1
479μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
424μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `ma37e_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
349μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT `template`
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `home` = 1
579μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '5e20a82e0b1fcc0ba8dc4437a5228ba9' AND `published` = '1'
404μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'e7b776204e81ef06dfb380da3513488b' AND `published` = '1'
172μ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'
448μs520B/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_menu`
4.15ms1.7KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1344'
340μ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'
375μ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
634μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT m.path
FROM ma37e_menu m
WHERE m.id = 1344
113μ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'
182μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1344'
158μ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
608μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'bd628c6105d37be5f380f22794ac1b70' AND `published` = '1'
224μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'deb5f792769d5cb1e4b59fc4e1ee74fb' AND `published` = '1'
220μ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'
510μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1344'
317μ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'
584μ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
885μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT m.path
FROM ma37e_menu m
WHERE m.id = 1344
180μ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'
272μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1344'
536μ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'
415μ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
939μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '477901119a29b1239161406ab225e6fb' AND `published` = '1'
185μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'a3e60dad8226dc2b91a9cae098af086c' AND `published` = '1'
163μ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'
260μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1344'
264μ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'
241μ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
580μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT m.path
FROM ma37e_menu m
WHERE m.id = 1344
96μ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'
149μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1344'
197μ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'
172μ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
570μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'd62ed013eacfaa1105ebcd2cdd088b31' AND `published` = '1'
214μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '860e5a525da4980dcec02cec3cc57394' AND `published` = '1'
155μ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'
230μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1344'
287μ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'
154μ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
814μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT m.path
FROM ma37e_menu m
WHERE m.id = 1344
149μ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'
230μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1344'
324μ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'
390μ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
760μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '5f67fe10f381a307df1f8f8096345d40' AND `published` = '1'
315μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '7009889bcf3dec7ceb4cc442049bb71a' AND `published` = '1'
308μ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'
268μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1344'
277μ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='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
665μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT m.path
FROM ma37e_menu m
WHERE m.id = 1344
120μ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'
176μ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'
171μ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
518μs3.03KB/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'a62748eeea02d28e0480f06b72a8dd82' AND `published` = '1'
448μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'e3eb6b495e478ec7bb857abb409c41ba' AND `published` = '1'
220μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '9809bb3e65fc0cb7c4bfc39ce0dae324' AND `published` = '1'
170μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '926020332386a044ae16dfc28e61b645' AND `published` = '1'
166μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_list WHERE type = 'standard'
500μs1.67KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_field
179μs1.69KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_form WHERE active = 1 AND type != 'shortcode'
167μ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
384μs1.37KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `value` FROM ma37e_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"
823μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT data_key, data_value
FROM `ma37e_sr_config_data`
WHERE scope_id = 0
3.85ms592B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_rsseo_keywords`
ORDER BY CHAR_LENGTH(keyword) DESC
222μ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
2.12ms656B/plugins/system/falangdriver/falang_database.php:330Copy