Nothing found with current search conditions.
Please register or log in to view more.
RESERVATION HOTLINE:
+1-222-34-56-789Infinity Joomla Template © 2016-2024. All Rights Reserved. Designed by Solidres.com
Joomla! Version | 5.1.2 |
PHP Version | 8.2.27 |
Identity | guest |
Response | 200 |
Template | infinity |
Database |
|
1 x afterRenderRawModule mod_sr_assets (TEST ASSETS) (6.39MB) (35.2%) | 367ms |
1 x afterInitialise (3.44MB) (17.74%) | 185ms |
1 x Before Access::preloadComponents (all components) (2MB) (8.83%) | 91.96ms |
1 x beforeRenderRawModule mod_menu (Main Menu) (1.01MB) (4.91%) | 51.11ms |
1 x afterRenderRawModule mod_falang (FaLang Language Switcher) (591.98KB) (4.64%) | 48.30ms |
1 x afterRenderComponent com_solidres (590.86KB) (3.94%) | 41.01ms |
1 x afterRender (531.95KB) (3.8%) | 39.60ms |
1 x afterLoad (355.48KB) (3.2%) | 33.33ms |
1 x afterDispatch (205.81KB) (2.86%) | 29.83ms |
1 x afterRenderRawModule mod_menu (Main Menu) (827.75KB) (2.12%) | 22.10ms |
1 x afterRoute (1.25MB) (2.01%) | 20.92ms |
1 x afterRenderRawModule mod_articles_latest (LATEST NEWS) (302.48KB) (1.82%) | 18.95ms |
1 x afterRenderRawModule mod_sr_advancedsearch (Advanced Search) (106.27KB) (0.88%) | 9.21ms |
1 x afterRenderRawModule mod_acym (STAY UP TO DATE) (73.88KB) (0.6%) | 6.29ms |
1 x afterRenderModule mod_sr_assets (TEST ASSETS) (96.95KB) (0.59%) | 6.14ms |
1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (111.84KB) (0.48%) | 4.95ms |
1 x afterRenderModule mod_menu (for Main-prototip-menu) (40.98KB) (0.44%) | 4.59ms |
1 x afterRenderRawModule mod_sr_locations (Location-test) (17.14KB) (0.43%) | 4.44ms |
1 x Before Access::getAssetRules (id:1 name:root.1) (56.01KB) (0.37%) | 3.90ms |
1 x afterRenderRawModule mod_menu (Bottom Menu) (110.35KB) (0.33%) | 3.40ms |
1 x afterRenderRawModule mod_sr_experience_search (Experience Search) (61.38KB) (0.32%) | 3.30ms |
1 x afterRenderModule mod_falang (FaLang Language Switcher) (57.99KB) (0.27%) | 2.85ms |
1 x Before Access::getAssetRules (id:8 name:com_content) (41.23KB) (0.27%) | 2.84ms |
1 x afterRenderRawModule mod_sp_weather (Weather) (30.01KB) (0.23%) | 2.37ms |
1 x afterRenderModule mod_sr_tabs (Booking Tabs) (101.05KB) (0.23%) | 2.37ms |
1 x afterRenderModule mod_sr_locations (Location-test) (74.78KB) (0.22%) | 2.34ms |
1 x afterRenderModule mod_sr_camera (Banner Slideshow) (73.22KB) (0.22%) | 2.25ms |
1 x afterRenderRawModule mod_sr_camera (Banner Slideshow) (2.45KB) (0.21%) | 2.20ms |
1 x afterRenderModule mod_custom (для Countries) (44.98KB) (0.2%) | 2.10ms |
1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (41.75KB) (0.18%) | 1.91ms |
1 x afterRenderModule mod_sp_weather (Weather) (42.94KB) (0.17%) | 1.79ms |
1 x beforeRenderRawModule mod_custom (Copyright) (16.52KB) (0.17%) | 1.73ms |
1 x afterRenderModule mod_custom (Copyright) (73.89KB) (0.17%) | 1.73ms |
1 x afterRenderModule mod_custom (Map Icon) (41.13KB) (0.16%) | 1.71ms |
1 x afterRenderModule mod_custom (RESERVATION HOTLINE) (41.36KB) (0.16%) | 1.67ms |
1 x afterRenderModule mod_acym (STAY UP TO DATE) (75.45KB) (0.15%) | 1.60ms |
1 x afterRenderModule mod_custom (Contact Details) (41.73KB) (0.15%) | 1.59ms |
1 x afterRenderModule mod_articles_latest (LATEST NEWS) (41.88KB) (0.15%) | 1.52ms |
1 x afterRenderModule mod_menu (Bottom Menu) (41.5KB) (0.14%) | 1.49ms |
1 x afterRenderModule mod_custom (Social Icons) (41.48KB) (0.13%) | 1.36ms |
1 x beforeRenderRawModule mod_sr_advancedsearch (Advanced Search) (29.05KB) (0.12%) | 1.29ms |
1 x afterRenderModule mod_menu (Main Menu) (8.15KB) (0.12%) | 1.23ms |
1 x After Access::preloadComponents (all components) (89.49KB) (0.11%) | 1.18ms |
1 x afterRenderRawModule mod_custom (Copyright) (5.27KB) (0.07%) | 726μs |
1 x beforeRenderComponent com_solidres (68.41KB) (0.06%) | 602μs |
1 x After Access::getAssetRules (id:124 name:com_solidres) (13.1KB) (0.05%) | 522μs |
1 x afterRenderModule mod_sr_advancedsearch (Advanced Search) (27.45KB) (0.03%) | 317μs |
1 x afterRenderModule mod_sr_experience_search (Experience Search) (5.74KB) (0.02%) | 164μs |
1 x beforeRenderRawModule mod_sr_locations (Location-test) (3.82KB) (0.01%) | 148μs |
1 x afterRenderRawModule mod_menu (for Main-prototip-menu) (928B) (0.01%) | 132μs |
1 x beforeRenderRawModule mod_menu (for Main-prototip-menu) (6.74KB) (0.01%) | 120μs |
1 x beforeRenderRawModule mod_sr_camera (Banner Slideshow) (6.8KB) (0.01%) | 117μs |
1 x beforeRenderRawModule mod_custom (Contact Details) (2.49KB) (0.01%) | 112μs |
1 x beforeRenderRawModule mod_falang (FaLang Language Switcher) (560B) (0.01%) | 110μs |
1 x beforeRenderRawModule mod_custom (для Countries) (6.79KB) (0.01%) | 109μs |
1 x beforeRenderRawModule mod_sr_assets (TEST ASSETS) (1.57KB) (0.01%) | 96μs |
1 x beforeRenderRawModule mod_menu (Bottom Menu) (1.95KB) (0.01%) | 88μs |
1 x beforeRenderRawModule mod_custom (Map Icon) (2.76KB) (0.01%) | 88μs |
1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (264B) (0.01%) | 87μs |
1 x beforeRenderRawModule mod_sr_tabs (Booking Tabs) (1.71KB) (0.01%) | 82μs |
1 x beforeRenderRawModule mod_acym (STAY UP TO DATE) (1.52KB) (0.01%) | 77μs |
1 x beforeRenderRawModule mod_custom (RESERVATION HOTLINE) (824B) (0.01%) | 77μs |
1 x afterRenderRawModule mod_custom (для Countries) (1.16KB) (0.01%) | 68μs |
1 x beforeRenderRawModule mod_custom (Social Icons) (424B) (0.01%) | 63μs |
1 x beforeRenderRawModule mod_articles_latest (LATEST NEWS) (2.82KB) (0.01%) | 63μs |
1 x afterRenderRawModule mod_custom (RESERVATION HOTLINE) (1KB) (0.01%) | 59μs |
1 x afterRenderRawModule mod_custom (Map Icon) (1KB) (0.01%) | 54μs |
1 x afterRenderRawModule mod_custom (Contact Details) (928B) (0.01%) | 53μs |
1 x beforeRenderRawModule mod_sp_weather (Weather) (3.84KB) (0%) | 44μs |
1 x afterRenderRawModule mod_custom (Social Icons) (992B) (0%) | 42μs |
1 x afterRenderRawModule mod_sr_tabs (Booking Tabs) (24.5KB) (0%) | 36μs |
1 x beforeRenderRawModule mod_sr_experience_search (Experience Search) (1.27KB) (0%) | 35μs |
1 x beforeRenderModule mod_sr_assets (TEST ASSETS) (720B) (0%) | 27μs |
1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0%) | 26μs |
1 x After Access::getAssetRules (id:1 name:root.1) (6.02KB) (0%) | 25μs |
1 x Before Access::getAssetRules (id:124 name:com_solidres) (56B) (0%) | 18μs |
1 x beforeRenderModule mod_sr_advancedsearch (Advanced Search) (736B) (0%) | 10μs |
1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%) | 9μs |
1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%) | 9μs |
1 x beforeRenderModule mod_falang (FaLang Language Switcher) (736B) (0%) | 9μs |
1 x beforeRenderModule mod_articles_latest (LATEST NEWS) (704B) (0%) | 8μs |
1 x beforeRenderModule mod_sr_locations (Location-test) (720B) (0%) | 8μs |
1 x beforeRenderModule mod_sr_camera (Banner Slideshow) (720B) (0%) | 7μs |
1 x beforeRenderModule mod_menu (Bottom Menu) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_acym (STAY UP TO DATE) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_custom (для Countries) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_sr_experience_search (Experience Search) (736B) (0%) | 6μs |
1 x beforeRenderModule mod_sp_weather (Weather) (720B) (0%) | 5μs |
1 x beforeRenderModule mod_custom (Copyright) (720B) (0%) | 4μs |
1 x beforeRenderModule mod_custom (RESERVATION HOTLINE) (720B) (0%) | 3μs |
1 x beforeRenderModule mod_menu (for Main-prototip-menu) (720B) (0%) | 2μs |
1 x beforeRenderModule mod_custom (Social Icons) (720B) (0%) | 2μs |
1 x beforeRenderModule mod_custom (Contact Details) (720B) (0%) | 2μs |
1 x beforeRenderModule mod_sr_tabs (Booking Tabs) (720B) (0%) | 2μs |
1 x beforeRenderModule mod_custom (Map Icon) (720B) (0%) | 2μs |
select distinct reference_table from ma37e_falang_content
165μs1.02KB/plugins/system/falangdriver/falang_database.php:224CopySELECT `params`
FROM `ma37e_extensions`
WHERE `type` = 'component' AND `element` = 'com_rsseo'
281μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_rsseo_redirects`
WHERE `published` = 1
70μs816B/plugins/system/falangdriver/falang_database.php:330CopySELECT `url`,`sef`
FROM `ma37e_rsseo_pages`
WHERE `short` = 'countries?location='
14.02ms576B/plugins/system/falangdriver/falang_database.php:330CopySELECT `url`
FROM `ma37e_rsseo_pages`
WHERE `sef` = 'countries?location=https%3A%2F%2Flets-booking.com%2F'
312μs840B/plugins/system/falangdriver/falang_database.php:330CopySELECT `url`
FROM `ma37e_rsseo_pages`
WHERE `sef` = 'countries'
249μs536B/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`
573μs35.92KBParams/plugins/system/falangdriver/falang_database.php:133CopySHOW TABLES
1.39ms4.51KB/plugins/system/falangdriver/falang_database.php:330CopySELECT joomlatablename,tablepkID FROM `ma37e_falang_tableinfo`
170μs1.69KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_languages ORDER BY ordering
138μs1.67KB/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_languages`
685μs1.52KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_plugin
81μs1.5KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_configuration
140μs2.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_plugin
74μs1.5KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value`
FROM ma37e_usergroups AS `groups`
352μ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
371μs64.89KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
221μs66.16KB/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)
637μs7.81KBParams/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_currencies`
951μs1.39KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_currencies`
WHERE `id` = '2'
298μs896B/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_categories`
957μs1.7KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_categories`
WHERE `id` = '14'
366μ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)
146μ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
LEFT JOIN `ma37e_sr_countries` AS `c` ON c.id = a.country_id
WHERE a.state = 1 AND ((cat.lft >= 25 AND cat.rgt <= 26)) AND (a.city LIKE '%https://lets-booking.com/%' OR c.name LIKE '%https://lets-booking.com/%')
GROUP BY cat.title,parent.title,cou.name,geostate.name,uc.name,ag.title,a.id
ORDER BY a.rating asc
576μs1.42KB/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
LEFT JOIN `ma37e_sr_countries` AS `c` ON c.id = a.country_id
WHERE a.state = 1 AND ((cat.lft >= 25 AND cat.rgt <= 26)) AND (a.city LIKE '%https://lets-booking.com/%' OR c.name LIKE '%https://lets-booking.com/%')
GROUP BY cat.title,parent.title,cou.name,geostate.name,uc.name,ag.title,a.id
ORDER BY a.rating asc
712μs1.42KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_categories`
WHERE `id` = '14'
169μ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)
272μ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
132μs688B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '1cd0cab48605898b56ce5a3d2c5ce2a9' AND `published` = '1'
172μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '90d4a9269846f703e560e12ac1b3b634' AND `published` = '1'
223μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'bb0a9ced4de62c61824e710aa211cf19' AND `published` = '1'
194μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '698918d5a0b1cb9e5718502b987b0244' AND `published` = '1'
258μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `language`,`id`
FROM `ma37e_menu`
WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0
370μs3.08KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1395) AND `reference_table`= 'menu'
131μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '0cb51cafdeef52b1e8d22fb4a294b2c2' AND `published` = '1'
108μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'd902f6d0b135b08eea7359f052eda59c' AND `published` = '1'
134μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `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
216μs1.41KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1308,1325) AND `reference_table`= 'menu'
208μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `url` = 'countries?location=' AND `published` = '1'
13.67ms536B/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` = 'countries?location=' OR `sef` = 'countries?location=') LIMIT 1
3.2ms1.44KB/plugins/system/falangdriver/falang_database.php:330CopyUPDATE `ma37e_rsseo_pages`
SET `hits` = `hits` + 1
WHERE `id` = '3632'
129μs48B/plugins/system/falangdriver/falang_database.php:133CopySELECT `id`,`date`
FROM `ma37e_rsseo_visitors`
WHERE `session_id` = 'd424102eb1ee3e176c3282c7dd92f9a9'
ORDER BY `date` DESC
114μs528B/plugins/system/falangdriver/falang_database.php:330CopyINSERT INTO `ma37e_rsseo_visitors`
SET `session_id` = 'd424102eb1ee3e176c3282c7dd92f9a9'
, `date` = '2025-04-04 16:57:37'
, `ip` = '18.188.38.17'
, `user_id` = '0'
, `agent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
, `referer` = ''
, `page` = 'countries?location='
244μs0B/plugins/system/falangdriver/falang_database.php:133CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
206μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
98μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
73μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
229μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
151μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
98μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '2f93d7f414a2a84be82ee282a3d84ab8' AND `published` = '1'
240μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '47bb35200e1ce58eaedd76e7b658c9f2' AND `published` = '1'
107μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '16e6b02eb8a7260db15eb52c57dbafac' AND `published` = '1'
69μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'f7c1352a4798597c6ef9362f93381fb1' AND `published` = '1'
96μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '3d45d11c7464cdab0522d81ab1cc6636' AND `published` = '1'
85μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'efa62f3201cc63218a7c983c753524a5' AND `published` = '1'
63μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '9cd83e3daced2ceebe40ec15881755d2' AND `published` = '1'
60μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'd82a4e03bb9fbcd10b042d6c0a87522d' AND `published` = '1'
80μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'a850caaa9ba4443bfaf655f7ea2aab72' AND `published` = '1'
99μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'fed8a89902fe105f4d3438b623f4cff2' AND `published` = '1'
73μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '50e6d0d939ebcb104ce7c093c70dcf3e' AND `published` = '1'
73μ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`
968μs18.22KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (215,214,182,109,104,134,101,159,161,91,17,108,196,148,150,142,87,96,187,209,220) AND `reference_table`= 'modules'
399μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
113μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
68μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
66μs75.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
58μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
105μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
102μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
80μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
77μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
73μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
56μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
101μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
64μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
77μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
77μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
69μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
59μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
77μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
62μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
70μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '3cc76b08e7b1946c15d35b6f74631f9a' AND `published` = '1'
169μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'e5899f586a7bce3b644f8fa9672a1b4d' AND `published` = '1'
81μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '79dc90e40984f2afe5cff8bb39a20baf' AND `published` = '1'
83μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'dfee311b94b9e346838ba0e23d88d88e' AND `published` = '1'
69μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'dc31c130209ee636dfdc9a1cc9e52d29' AND `published` = '1'
68μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '532e3d0de7fc70b1b96dc8fdeae773de' AND `published` = '1'
57μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'a73774265bbd286f40b8ad808f72401e' AND `published` = '1'
75μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'a2c8b94f599785951d6bc8622b5187f1' AND `published` = '1'
73μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '2eb78984853e724b361bedd9fd94230d' AND `published` = '1'
62μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '165873b4b9ef12be152bc65f73043b33' AND `published` = '1'
57μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'd41d8cd98f00b204e9800998ecf8427e' AND `published` = '1'
86μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'bcd90d43de25e7bcf25c1a762ad462b1' AND `published` = '1'
102μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
141μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
98μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
98μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
77μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
96μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
98μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
92μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
251μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
81μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
69μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
74μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
84μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
67μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
59μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
65μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
60μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
56μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
62μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
50μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
75μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
70μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
88μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
131μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
63μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
76μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
90μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
61μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
55μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
69μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
78μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
78μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
79μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
78μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
91μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
71μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
57μs72.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
74μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
233μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
95μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
77μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
86μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
67μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
85μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
84μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
91μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
70μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
70μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
73μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_rsseo_data`
80μs576B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
182μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
93μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
75μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
90μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
70μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
75μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
76μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
76μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
162μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
125μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
80μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
69μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_list WHERE `type` = 'standard'
160μs1.67KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_field WHERE `id` IN(2) ORDER BY `ordering` ASC
91μs1.66KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '15b23a9a60ad2af4c8c90d23ed57a59b' AND `published` = '1'
121μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
115μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
80μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
59μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
67μs64.91KB/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
868μs23.09KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,2,3,4) AND `reference_table`= 'content'
198μ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`
427μ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`
320μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '126d24c05055e7f64fa35c6198da933a' AND `published` = '1'
142μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '995cc138fac9087240ce4ba8fac9cc0d' AND `published` = '1'
120μ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`
278μ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`
318μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'e0877ee6f7609fa348963036909f9539' AND `published` = '1'
99μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '1b26423b474126940ba83a3d5ce67b1c' AND `published` = '1'
96μ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`
292μ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`
274μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '7e24cfe08e44f82e7aad50b6eba1363b' AND `published` = '1'
135μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'dc19e6b03b09f52dafd4bae3b5d7a9dd' AND `published` = '1'
96μ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`
362μ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`
370μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'ae911a9abeb2d5901dd46e1283167488' AND `published` = '1'
151μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '9b1204632b4fcbfcb6d9b21895fc11b3' AND `published` = '1'
236μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
156μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
98μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
88μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
80μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
71μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
67μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
63μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
81μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
75μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
96μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
76μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
73μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '9d7f564aa5e716dbae961dd1f0c23d30' AND `published` = '1'
139μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
84μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
66μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
82μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
87μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
74μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
62μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
58μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
60μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
71μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
63μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
157μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
72μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
173μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
79μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
61μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
87μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
473μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
234μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
86μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
77μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
128μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
91μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
78μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
175μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT id
FROM `ma37e_sr_reservation_assets`
WHERE state = 1
188μs680B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (8,9,10,11,12,13,14,15,16) AND `reference_table`= 'sr_reservation_assets'
247μs688B/plugins/system/falangdriver/falang_database.php:325CopySHOW FULL COLUMNS FROM `ma37e_sr_reservation_assets`
824μs2.14KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '8'
195μs21.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (8) AND `reference_table`= 'sr_reservation_assets'
250μ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)
317μ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)
118μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_countries`
807μs1.45KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '224'
98μs1.47KB/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_geo_states`
446μs1.36KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_geo_states`
WHERE `id` = '11'
81μs832B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_currencies`
WHERE `id` = '1'
64μs896B/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_customers`
505μs1.58KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_customers`
WHERE `id` = '31'
91μs2.5KB/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_users`
577μs1.58KB/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_customer_groups`
333μs1.31KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_users`
WHERE `id` = :userid
108μs3.16KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `g`.`id`,`g`.`title`
FROM `ma37e_usergroups` AS `g`
INNER JOIN `ma37e_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id`
WHERE `m`.`user_id` = :muserid
216μs1.38KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '8'
123μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_currencies`
WHERE `id` = 1
805μs896B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_currencies`
WHERE `id` = 2
135μ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 = 8 AND a.type IN (0,2,3,8,9)
ORDER BY a.title ASC
285μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 8
122μ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
122μs784B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,2,3,4,11,16) AND `reference_table`= 'sr_facilities'
318μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 8
112μs568B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 8
80μ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.%'
553μs960B/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
317μs624B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (24,23,22) AND `reference_table`= 'sr_reservation_assets'
209μs688B/plugins/system/falangdriver/falang_database.php:325CopySHOW FULL COLUMNS FROM `ma37e_sr_feedbacks`
605μs1.52KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '24'
113μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_sr_reservations`
1.07ms2.52KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '25'
317μs9.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '5b7390dc1dbb6442cd9b400aabdaa468' AND `published` = '1'
386μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'f10b00376b08b2ad93e3bfc43563dfd0' AND `published` = '1'
92μ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.25'
575μs688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '235'
132μ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
124μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (8) AND `reference_table`= 'sr_reservation_assets'
128μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '9d796f383e03d92ae7f81e02ff903a5c' AND `published` = '1'
103μs16.51KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'aa33e1dae5d108b042420d67a2db06c1' AND `published` = '1'
79μ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
109μ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 = 24 AND a.field_id = 8
148μ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
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 = 10
106μ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
95μ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
92μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
WHERE a.feedback_id = 24 AND a.field_id = 13
122μ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
110μ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
179μ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
103μ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
122μ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
100μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '23'
138μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '26'
361μs9.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.context, a.value, a.storage
FROM `ma37e_sr_customfield_values` AS `a`
WHERE `context` = 'com_solidres.customer.26'
482μs688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '196'
95μ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
147μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (8) AND `reference_table`= 'sr_reservation_assets'
122μ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
208μ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
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 = 10
89μ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
101μ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
74μ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
95μ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
83μ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
183μ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
88μ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
91μ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
90μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '22'
64μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '27'
211μ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'
392μs688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '85'
123μ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
173μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (8) AND `reference_table`= 'sr_reservation_assets'
139μ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
114μ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
66μ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
88μ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
105μ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
104μ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
112μ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
98μ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
194μs624B/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT a.id, a.name
FROM `ma37e_sr_feedback_attribute_values` AS `a`
INNER JOIN `ma37e_sr_feedback_attribute_xref` AS `a2` ON a2.feedback_attribute_value_id = a.id
WHERE a.attribute_id = 11 AND a2.feedback_id = 22
156μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT a.id, a.name
FROM `ma37e_sr_feedback_attribute_values` AS `a`
INNER JOIN `ma37e_sr_feedback_attribute_xref` AS `a2` ON a2.feedback_attribute_value_id = a.id
WHERE a.attribute_id = 12 AND a2.feedback_id = 22
172μ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
105μ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
412μs10.05KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.alias
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = 8
142μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (8) AND `reference_table`= 'sr_reservation_assets'
156μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '8a3015a09ba84b9c296c61ffbb531a9f' AND `published` = '1'
146μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.field
FROM `ma37e_sr_feedback_conditions` AS `a`
WHERE a.scope = 0
72μ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 = 8 OR a2.item_id = 8)
337μ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)
305μ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)
278μ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)
263μs704B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Staff' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 12 AND (a3.reservation_asset_id = 8 OR a2.item_id = 8)
337μ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)
314μ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)
401μ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
334μ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
317μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '9'
265μs21.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (9) AND `reference_table`= 'sr_reservation_assets'
190μ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)
136μ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)
151μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '189'
119μs1.47KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '9'
122μ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 = 9 AND a.type IN (0,2,3,8,9)
ORDER BY a.title ASC
229μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 9
79μ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 (18,5,2,20,6,1)
ORDER BY a.ordering ASC
164μs784B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,2,5,6,18,20) AND `reference_table`= 'sr_facilities'
172μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 9
90μs568B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 9
76μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_reservation_asset_fields`
WHERE reservation_asset_id = 9 AND field_key LIKE 'reservationasset_extra_fields.%'
414μs1KB/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 = 9 OR a.item_id = 9) AND a.state = 1
ORDER BY a.id DESC LIMIT 3
200μs608B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (26,25) AND `reference_table`= 'sr_reservation_assets'
128μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '26'
102μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '32'
214μ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.32'
574μs688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '198'
124μ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 = 32
138μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (9) AND `reference_table`= 'sr_reservation_assets'
139μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'ab57593cdfae390b8f915506b4640fba' AND `published` = '1'
93μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'fce4d79c49e688be051334b03fe19c9a' AND `published` = '1'
65μ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 = 26 AND a.field_id = 8
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 = 26 AND a.field_id = 9
89μ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 = 26 AND a.field_id = 10
104μ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 = 26 AND a.field_id = 11
126μ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 = 26 AND a.field_id = 12
122μ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 = 26 AND a.field_id = 13
93μ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 = 26 AND a.field_id = 14
81μ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 = 26 AND a.scope = 0
162μ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 = 26
134μ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 = 26
115μ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 = 26
119μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '25'
80μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '31'
254μ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.31'
398μs688B/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 = 31
95μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (9) AND `reference_table`= 'sr_reservation_assets'
189μ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 = 25 AND a.field_id = 8
131μ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 = 25 AND a.field_id = 9
106μ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 = 25 AND a.field_id = 10
85μ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 = 25 AND a.field_id = 11
100μ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 = 25 AND a.field_id = 12
213μ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 = 25 AND a.field_id = 13
108μ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 = 25 AND a.field_id = 14
86μ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 = 25 AND a.scope = 0
213μ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 = 25
96μ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 = 25
80μ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 = 25
81μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.*
FROM `ma37e_sr_reservations` AS `a`
WHERE a.reservation_asset_id = 9 AND a.state = 0
227μ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 = 9 OR a2.item_id = 9)
392μ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 = 9 OR a2.item_id = 9)
340μ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 = 9 OR a2.item_id = 9)
338μ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 = 9 OR a2.item_id = 9)
241μ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 = 9 OR a2.item_id = 9)
230μ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 = 9 OR a2.item_id = 9)
232μ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 = 9 OR a2.item_id = 9)
238μ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 = 9 OR a2.item_id = 9)
GROUP BY a.field_id
199μ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 = 9 OR a.item_id = 9) AND a.state = 1
176μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.alias
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = 9
101μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (9) AND `reference_table`= 'sr_reservation_assets'
159μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '8a11e4672eef0383c109c4ffc6b66140' AND `published` = '1'
222μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '10'
253μs21.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (10) AND `reference_table`= 'sr_reservation_assets'
149μ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)
136μ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)
101μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '106'
130μs1.47KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '10'
82μ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 = 10 AND a.type IN (0,2,3,8,9)
ORDER BY a.title ASC
365μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 10
103μ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 (18,22,9,16,15,1)
ORDER BY a.ordering ASC
178μs784B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,9,15,16,18,22) AND `reference_table`= 'sr_facilities'
158μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 10
60μs552B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 10
59μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_reservation_asset_fields`
WHERE reservation_asset_id = 10 AND field_key LIKE 'reservationasset_extra_fields.%'
338μs960B/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 = 10 OR a.item_id = 10) AND a.state = 1
ORDER BY a.id DESC LIMIT 3
205μs608B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (28,27) AND `reference_table`= 'sr_reservation_assets'
150μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '28'
106μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '34'
259μ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.34'
355μs688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '191'
89μ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 = 34
110μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (10) AND `reference_table`= 'sr_reservation_assets'
129μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '3e691aaa55b2702747d3f39ddc997cc7' AND `published` = '1'
115μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '4771580012a40a7bb22d15c06ebcbb1c' AND `published` = '1'
76μ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 = 28 AND a.field_id = 8
134μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
WHERE a.feedback_id = 28 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 = 28 AND a.field_id = 10
105μ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 = 28 AND a.field_id = 11
97μ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 = 28 AND a.field_id = 12
89μ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 = 28 AND a.field_id = 13
103μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
WHERE a.feedback_id = 28 AND a.field_id = 14
103μ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 = 28 AND a.scope = 0
375μ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 = 28
155μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT a.id, a.name
FROM `ma37e_sr_feedback_attribute_values` AS `a`
INNER JOIN `ma37e_sr_feedback_attribute_xref` AS `a2` ON a2.feedback_attribute_value_id = a.id
WHERE a.attribute_id = 12 AND a2.feedback_id = 28
101μ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 = 28
116μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '27'
126μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '33'
253μ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.33'
465μs688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '15'
143μ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 = 33
139μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (10) AND `reference_table`= 'sr_reservation_assets'
162μ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 = 27 AND a.field_id = 8
149μ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 = 27 AND a.field_id = 9
75μ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 = 27 AND a.field_id = 10
84μ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 = 27 AND a.field_id = 11
247μ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 = 27 AND a.field_id = 12
86μ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 = 27 AND a.field_id = 13
71μ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 = 27 AND a.field_id = 14
70μ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 = 27 AND a.scope = 0
160μ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 = 27
132μ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 = 27
109μ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 = 27
99μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.*
FROM `ma37e_sr_reservations` AS `a`
WHERE a.reservation_asset_id = 10 AND a.state = 0
307μ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 = 10 OR a2.item_id = 10)
412μ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 = 10 OR a2.item_id = 10)
278μ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 = 10 OR a2.item_id = 10)
369μ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 = 10 OR a2.item_id = 10)
258μ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 = 10 OR a2.item_id = 10)
347μ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 = 10 OR a2.item_id = 10)
253μ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 = 10 OR a2.item_id = 10)
240μ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 = 10 OR a2.item_id = 10)
GROUP BY a.field_id
168μ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 = 10 OR a.item_id = 10) AND a.state = 1
160μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.alias
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = 10
84μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (10) AND `reference_table`= 'sr_reservation_assets'
151μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'd996c20c1ddc16d8bf7b3450b8f6c129' AND `published` = '1'
273μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '11'
207μs21.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (11) AND `reference_table`= 'sr_reservation_assets'
163μ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)
133μ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)
122μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '11'
89μ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
259μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 11
77μ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
311μs784B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,6,9,14,17,19) AND `reference_table`= 'sr_facilities'
192μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 11
69μs568B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 11
68μ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.%'
519μs1KB/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
287μs608B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (30,29) AND `reference_table`= 'sr_reservation_assets'
198μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '30'
97μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '36'
258μs9.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.context, a.value, a.storage
FROM `ma37e_sr_customfield_values` AS `a`
WHERE `context` = 'com_solidres.customer.36'
408μs688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '162'
66μ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
107μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (11) AND `reference_table`= 'sr_reservation_assets'
188μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'beeafc255237bcdf8cb93baca0138391' AND `published` = '1'
111μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'b796b0d5da415c8e2c057f9dc5ede8bd' AND `published` = '1'
88μ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
159μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
WHERE a.feedback_id = 30 AND a.field_id = 9
96μ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
102μ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
112μ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
77μ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
66μ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
73μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT a.id, a.name
FROM `ma37e_sr_feedback_attributes` AS `a`
INNER JOIN `ma37e_sr_feedback_attribute_values` AS `a2` ON a2.attribute_id = a.id
INNER JOIN `ma37e_sr_feedback_attribute_xref` AS `a3` ON a3.feedback_attribute_value_id = a2.id
WHERE a3.feedback_id = 30 AND a.scope = 0
151μ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
94μ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
88μ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
112μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '29'
143μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '35'
219μ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'
607μs688B/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
141μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (11) AND `reference_table`= 'sr_reservation_assets'
176μ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
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 = 29 AND a.field_id = 9
103μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
WHERE a.feedback_id = 29 AND a.field_id = 10
111μ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
104μ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
95μ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
97μ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
94μ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
179μ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
112μ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
105μ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
98μ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
454μ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)
416μs608B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Comfort' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 9 AND (a3.reservation_asset_id = 11 OR a2.item_id = 11)
263μ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)
287μ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)
331μ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)
267μ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)
291μ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)
310μ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
257μ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
181μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.alias
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = 11
65μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (11) AND `reference_table`= 'sr_reservation_assets'
154μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'cd7c6b98a2291196c2e9d92992abe4a7' AND `published` = '1'
1.16ms536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '12'
278μs21.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (12) AND `reference_table`= 'sr_reservation_assets'
376μ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)
269μ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)
99μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '12'
124μ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 = 12 AND a.type IN (0,2,3,8,9)
ORDER BY a.title ASC
348μs34.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 12
123μ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
103μs784B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,4,8,13,16,21) AND `reference_table`= 'sr_facilities'
325μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 12
125μs568B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 12
138μ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.%'
465μs1KB/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
383μs608B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (32,31) AND `reference_table`= 'sr_reservation_assets'
166μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '32'
340μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '38'
485μ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.38'
521μs688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '197'
137μ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
169μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (12) AND `reference_table`= 'sr_reservation_assets'
151μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '7c2970f0a4d01fca48d29e9f2d6acfd9' AND `published` = '1'
114μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '983db1ab02723142540535cfa026846d' AND `published` = '1'
87μ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 = 32 AND a.field_id = 8
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 = 32 AND a.field_id = 9
353μ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
154μ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
105μ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
199μ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
124μ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
188μ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
111μ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
105μ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
133μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '31'
110μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '37'
309μ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'
471μs688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '213'
155μ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
274μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (12) AND `reference_table`= 'sr_reservation_assets'
295μ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
136μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
WHERE a.feedback_id = 31 AND a.field_id = 9
95μ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
88μ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
84μ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
122μ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
108μ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
971μ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
247μ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
195μ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
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 = 31
131μ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
348μ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 = 12 OR a2.item_id = 12)
699μ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)
599μs608B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Location' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 10 AND (a3.reservation_asset_id = 12 OR a2.item_id = 12)
398μs608B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Facilities' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 11 AND (a3.reservation_asset_id = 12 OR a2.item_id = 12)
404μ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)
793μs608B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score, 'Value for money' AS field
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.state = 1 AND a2.scope = 0 AND a.field_id = 13 AND (a3.reservation_asset_id = 12 OR a2.item_id = 12)
338μ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)
359μs608B/plugins/system/falangdriver/falang_database.php:330CopySELECT count(a.field_id)
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
LEFT JOIN `ma37e_sr_reservations` AS `a3` ON a3.id = a2.reservation_id
WHERE a2.scope = 0 AND a2.state = 1 AND (a3.reservation_asset_id = 12 OR a2.item_id = 12)
GROUP BY a.field_id
271μ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
680μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.alias
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = 12
132μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (12) AND `reference_table`= 'sr_reservation_assets'
220μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '50d220249f5a37291051529b832d6182' AND `published` = '1'
283μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '13'
304μs21.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (13) AND `reference_table`= 'sr_reservation_assets'
220μ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)
134μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `t`.`id`
FROM `ma37e_tags` AS `t`
INNER JOIN `ma37e_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)
100μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '13'
80μ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 = 13 AND a.type IN (0,2,3,8,9)
ORDER BY a.title ASC
214μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 13
89μ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,18,8,6,17,1)
ORDER BY a.ordering ASC
217μs784B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,3,6,8,17,18) AND `reference_table`= 'sr_facilities'
239μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 13
147μs568B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 13
404μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT field_key, field_value
FROM `ma37e_sr_reservation_asset_fields`
WHERE reservation_asset_id = 13 AND field_key LIKE 'reservationasset_extra_fields.%'
507μs1KB/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 = 13 OR a.item_id = 13) AND a.state = 1
ORDER BY a.id DESC LIMIT 3
343μs608B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (34,33) AND `reference_table`= 'sr_reservation_assets'
255μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '34'
183μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '40'
377μ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.40'
997μs688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '2'
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 = 40
133μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (13) AND `reference_table`= 'sr_reservation_assets'
222μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'bf9133f613a3b8a4620910648312518d' AND `published` = '1'
229μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '8519b07daf528ae1e4a923cf80e3ae6f' AND `published` = '1'
128μ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 = 34 AND a.field_id = 8
252μ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 = 34 AND a.field_id = 9
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 = 34 AND a.field_id = 10
111μ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 = 34 AND a.field_id = 11
205μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.score
FROM `ma37e_sr_feedback_scores` AS `a`
INNER JOIN `ma37e_sr_feedbacks` AS `a2` ON a2.id = a.feedback_id
WHERE a.feedback_id = 34 AND a.field_id = 12
391μ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 = 34 AND a.field_id = 13
314μ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 = 34 AND a.field_id = 14
141μ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 = 34 AND a.scope = 0
208μ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 = 34
156μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT a.id, a.name
FROM `ma37e_sr_feedback_attribute_values` AS `a`
INNER JOIN `ma37e_sr_feedback_attribute_xref` AS `a2` ON a2.feedback_attribute_value_id = a.id
WHERE a.attribute_id = 12 AND a2.feedback_id = 34
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 = 13 AND a2.feedback_id = 34
156μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_feedbacks`
WHERE `id` = '33'
140μs1.63KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservations`
WHERE `id` = '39'
315μ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.39'
476μs688B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '216'
180μ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 = 39
140μs768B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (13) AND `reference_table`= 'sr_reservation_assets'
192μ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 = 33 AND a.field_id = 8
211μ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 = 33 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 = 33 AND a.field_id = 10
427μ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 = 33 AND a.field_id = 11
115μ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 = 33 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 = 33 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 = 33 AND a.field_id = 14
156μ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 = 33 AND a.scope = 0
227μ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 = 33
155μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT a.id, a.name
FROM `ma37e_sr_feedback_attribute_values` AS `a`
INNER JOIN `ma37e_sr_feedback_attribute_xref` AS `a2` ON a2.feedback_attribute_value_id = a.id
WHERE a.attribute_id = 12 AND a2.feedback_id = 33
182μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT a.id, a.name
FROM `ma37e_sr_feedback_attribute_values` AS `a`
INNER JOIN `ma37e_sr_feedback_attribute_xref` AS `a2` ON a2.feedback_attribute_value_id = a.id
WHERE a.attribute_id = 13 AND a2.feedback_id = 33
167μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.*
FROM `ma37e_sr_reservations` AS `a`
WHERE a.reservation_asset_id = 13 AND a.state = 0
423μ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 = 13 OR a2.item_id = 13)
670μ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 = 13 OR a2.item_id = 13)
579μ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 = 13 OR a2.item_id = 13)
406μ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 = 13 OR a2.item_id = 13)
334μ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 = 13 OR a2.item_id = 13)
387μ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 = 13 OR a2.item_id = 13)
335μ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 = 13 OR a2.item_id = 13)
308μ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 = 13 OR a2.item_id = 13)
GROUP BY a.field_id
212μ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 = 13 OR a.item_id = 13) AND a.state = 1
811μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.alias
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = 13
398μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (13) AND `reference_table`= 'sr_reservation_assets'
342μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '7a5bb24b47ee7faf34519c70f2ce37e8' AND `published` = '1'
174μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '14'
365μs21.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (14) AND `reference_table`= 'sr_reservation_assets'
6.66ms688B/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)
154μ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)
126μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_countries`
WHERE `id` = '3'
161μs1.47KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_geo_states`
WHERE `id` = '523'
102μs832B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_currencies`
WHERE `id` = '2'
124μs896B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '14'
124μ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
637μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 14
146μs584B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.title, a.description, a.icon
FROM `ma37e_sr_facilities` AS `a`
WHERE a.id IN (13,3,19,21)
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`=1 AND `published`= 1 AND `reference_id`IN (3,13,19,21) AND `reference_table`= 'sr_facilities'
206μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 14
143μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 14
124μ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.%'
470μs960B/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
433μ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
383μ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)
384μ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)
416μ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)
282μ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)
319μ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)
307μ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)
305μ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)
264μ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
228μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '15'
286μs21.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (15) AND `reference_table`= 'sr_reservation_assets'
207μ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)
140μ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)
120μs1.32KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_geo_states`
WHERE `id` = '523'
124μs832B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '15'
117μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT a.*, asset.name as reservationasset
FROM `ma37e_sr_discounts` AS a
LEFT JOIN `ma37e_sr_reservation_assets` AS asset ON asset.id = a.reservation_asset_id
WHERE a.scope = 0 AND a.state = 1 AND a.reservation_asset_id = 15 AND a.type IN (0,2,3,8,9)
ORDER BY a.title ASC
402μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 15
338μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 15
116μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 15
85μ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.%'
409μs960B/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
283μ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
329μ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)
550μ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)
574μ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)
304μ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)
275μ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)
373μ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)
251μ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)
276μ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
223μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.alias
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = 15
124μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (15) AND `reference_table`= 'sr_reservation_assets'
185μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '48a9b3c06d21d2f44535ba39cfc1033c' AND `published` = '1'
175μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_reservation_assets`
WHERE `id` = '16'
280μs21.56KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (16) AND `reference_table`= 'sr_reservation_assets'
253μ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)
188μ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)
133μs1.34KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_sr_geo_states`
WHERE `id` = '523'
131μs832B/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '16'
107μ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
254μs2.55KB/plugins/system/falangdriver/falang_database.php:330CopySELECT facility_id
FROM `ma37e_sr_facility_reservation_asset_xref`
WHERE reservation_asset_id = 16
177μ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
159μs816B/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1,4,6,11,15,22,41) AND `reference_table`= 'sr_facilities'
209μs688B/plugins/system/falangdriver/falang_database.php:325CopySELECT theme_id
FROM `ma37e_sr_reservation_asset_theme_xref`
WHERE reservation_asset_id = 16
113μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT commission_rate_id
FROM `ma37e_sr_commission_rate_property_xref`
WHERE property_id = 16
120μ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.%'
329μs960B/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
269μ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
390μ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)
502μ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)
352μ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)
312μ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)
248μ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)
265μ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)
429μ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)
313μ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
224μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '7166769e1ad2617392565bb053a49ac2' AND `published` = '1'
181μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
218μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
225μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
916μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
253μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '4f039ac0804b4a49993adb319f78923a' AND `published` = '1'
307μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'ccee7456665b059246cfd18e3ea67dbb' AND `published` = '1'
141μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '47ecc622efa35d0ad65c6adef97c81c7' AND `published` = '1'
154μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
239μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
161μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
121μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
119μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
168μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
135μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
135μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
127μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.id, a.title, a.level
FROM ma37e_categories AS a
WHERE a.parent_id > 0 AND extension = 'com_solidres' AND a.published IN (0,1)
ORDER BY a.lft
330μs704B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '63d43163d3395208c295ba65ff2c044d' AND `published` = '1'
299μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '7733087193521252d4c8ee06c12e3766' AND `published` = '1'
134μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT filter_range
FROM ma37e_sr_currencies
WHERE id = 2
198μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT DISTINCT a.base_location
FROM `ma37e_sr_experiences` AS `a`
WHERE a.state = 1
209μs712B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'de6a78283ff18e81335074c721ff958e' AND `published` = '1'
171μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
184μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
181μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
149μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
186μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT a.images
FROM `ma37e_sr_reservation_assets` AS `a`
WHERE a.id = '8'
177μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
185μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
142μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
136μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
121μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
141μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
155μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
2.04ms64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
298μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = 'c9980e0e4a50de3c413f4fa9b75f2839' AND `published` = '1'
311μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '2e5ddead66a3267557802739d658f706' AND `published` = '1'
146μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1308 AND fc.language_id = 6 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
314μs520B/plugins/system/falangdriver/falang_database.php:330CopySHOW FULL COLUMNS FROM `ma37e_menu`
1.37ms1.7KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1308'
470μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1308) AND `reference_table`= 'menu'
386μ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 = 1308 AND p.client_id = 0
ORDER BY p.lft
727μs3.02KB/plugins/system/falangdriver/falang_database.php:325CopySELECT m.path
FROM ma37e_menu m
WHERE m.id = 1308
125μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1308 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
262μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1308'
213μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1308) AND `reference_table`= 'menu'
257μ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 = 1308 AND p.client_id = 0
ORDER BY p.lft
735μs3.02KB/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '7efbc3e84801cd04215240c60c2cf346' AND `published` = '1'
268μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '39225cd5b4fde9d55b557b04d7dcac93' AND `published` = '1'
177μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '370c12b8a5479ccb7c809b95abffa3e0' AND `published` = '1'
308μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '6009483a1491f34cea53f36d366ffa66' AND `published` = '1'
132μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1308 AND fc.language_id = 3 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
220μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1308'
227μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1308) AND `reference_table`= 'menu'
2.3ms688B/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 = 1308 AND p.client_id = 0
ORDER BY p.lft
898μs3.02KB/plugins/system/falangdriver/falang_database.php:325CopySELECT m.path
FROM ma37e_menu m
WHERE m.id = 1308
136μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1308 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
366μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1308'
184μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1308) AND `reference_table`= 'menu'
300μ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 = 1308 AND p.client_id = 0
ORDER BY p.lft
795μs3.02KB/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '241a60392f8802d51486b7a0d56a537d' AND `published` = '1'
242μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '19f895a09dfc4f9b0e096c7c4bf38b68' AND `published` = '1'
132μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1308 AND fc.language_id = 4 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
225μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1308'
218μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1308) AND `reference_table`= 'menu'
200μ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 = 1308 AND p.client_id = 0
ORDER BY p.lft
567μs3.02KB/plugins/system/falangdriver/falang_database.php:325CopySELECT m.path
FROM ma37e_menu m
WHERE m.id = 1308
103μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1308 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
153μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1308'
163μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1308) AND `reference_table`= 'menu'
158μ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 = 1308 AND p.client_id = 0
ORDER BY p.lft
440μs3.02KB/plugins/system/falangdriver/falang_database.php:325CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '95fbdcded7efd07e40d84c336d53109c' AND `published` = '1'
163μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT `sef`
FROM `ma37e_rsseo_pages`
WHERE `hash` = '7b3614febdad54f4119c0cdd3cde9902' AND `published` = '1'
120μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1308 AND fc.language_id = 5 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
150μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1308'
158μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1308) AND `reference_table`= 'menu'
116μ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 = 1308 AND p.client_id = 0
ORDER BY p.lft
534μs3.02KB/plugins/system/falangdriver/falang_database.php:325CopySELECT m.path
FROM ma37e_menu m
WHERE m.id = 1308
304μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT fc.value
FROM ma37e_falang_content fc
WHERE fc.reference_id = 1308 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'
247μs520B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_menu`
WHERE `id` = '1308'
333μs2.84KB/plugins/system/falangdriver/falang_database.php:330CopySELECT reference_field, value, reference_id, original_value
FROM `ma37e_falang_content`
WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (1308) 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='1' and jfc.reference_field='alias'
WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 1308 AND p.client_id = 0
ORDER BY p.lft
434μs3.02KB/plugins/system/falangdriver/falang_database.php:325CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
225μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
134μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
117μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
106μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
73μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
102μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
72μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
64μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
145μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
125μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
125μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
130μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_list WHERE type = 'standard'
214μs1.67KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_field
134μs1.69KB/plugins/system/falangdriver/falang_database.php:330CopySELECT * FROM ma37e_acym_form WHERE active = 1 AND type != 'shortcode'
109μs912B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
185μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
117μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
272μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
216μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
98μs64.91KB/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
242μs1.37KBParams/plugins/system/falangdriver/falang_database.php:330CopySELECT `value` FROM ma37e_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"
277μs536B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_template_styles`
WHERE `client_id` = 0 AND `id` = '31'
196μs64.91KB/plugins/system/falangdriver/falang_database.php:330CopySELECT data_key, data_value
FROM `ma37e_sr_config_data`
WHERE scope_id = 0
576μs592B/plugins/system/falangdriver/falang_database.php:330CopySELECT *
FROM `ma37e_rsseo_keywords`
ORDER BY CHAR_LENGTH(keyword) DESC
101μs1.28KB/plugins/system/falangdriver/falang_database.php:330CopySELECT `id`,`css`,`scripts`
FROM `ma37e_rsseo_pages`
WHERE `published` = 1 AND (`url` = 'countries?location=' OR `sef` = 'countries?location=') LIMIT 1
2.99ms656B/plugins/system/falangdriver/falang_database.php:330Copy