| 1 |
0.30 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.slug = 'doble' LIMIT 1;
|
| 2 |
0.36 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_published AS is_published_3, t0.position AS position_4, t0.main_image_id AS main_image_id_5 FROM room t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_published AS is_published_3, t0.position AS position_4, t0.main_image_id AS main_image_id_5 FROM room t0 WHERE t0.id = 1;
|
| 3 |
0.26 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_published AS is_published_3, t0.position AS position_4, t0.main_image_id AS main_image_id_5 FROM room t0 WHERE t0.is_published = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_published AS is_published_3, t0.position AS position_4, t0.main_image_id AS main_image_id_5 FROM room t0 WHERE t0.is_published = 1;
|
| 4 |
0.18 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = 1 AND t0.language_id = 'ca' LIMIT 1;
|
| 5 |
0.16 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = 1;
|
| 6 |
0.21 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4 FROM language t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4 FROM language t0 WHERE t0.id = 1;
|
| 7 |
0.20 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_published AS is_published_3, t0.position AS position_4, t0.main_image_id AS main_image_id_5 FROM room t0 WHERE t0.is_published = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_published AS is_published_3, t0.position AS position_4, t0.main_image_id AS main_image_id_5 FROM room t0 WHERE t0.is_published = 1;
|
| 8 |
0.16 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = 1 AND t0.language_id = 'ca' LIMIT 1;
|
| 9 |
0.24 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.updated_at AS updated_at_3, t0.alt_image AS alt_image_4, t0.alt_image_ca AS alt_image_ca_5, t0.alt_image_es AS alt_image_es_6, t0.alt_image_fr AS alt_image_fr_7, t0.alt_image_en AS alt_image_en_8, t0.alt_image_it AS alt_image_it_9, t0.alt_image_kr AS alt_image_kr_10, t0.desc_image AS desc_image_11, t0.desc_image_ca AS desc_image_ca_12, t0.desc_image_es AS desc_image_es_13, t0.desc_image_fr AS desc_image_fr_14, t0.desc_image_en AS desc_image_en_15, t0.desc_image_it AS desc_image_it_16, t0.desc_image_kr AS desc_image_kr_17, t0.position AS position_18 FROM image t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.image AS image_2, t0.updated_at AS updated_at_3, t0.alt_image AS alt_image_4, t0.alt_image_ca AS alt_image_ca_5, t0.alt_image_es AS alt_image_es_6, t0.alt_image_fr AS alt_image_fr_7, t0.alt_image_en AS alt_image_en_8, t0.alt_image_it AS alt_image_it_9, t0.alt_image_kr AS alt_image_kr_10, t0.desc_image AS desc_image_11, t0.desc_image_ca AS desc_image_ca_12, t0.desc_image_es AS desc_image_es_13, t0.desc_image_fr AS desc_image_fr_14, t0.desc_image_en AS desc_image_en_15, t0.desc_image_it AS desc_image_it_16, t0.desc_image_kr AS desc_image_kr_17, t0.position AS position_18 FROM image t0 WHERE t0.id = 17;
|
| 10 |
0.44 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.updated_at AS updated_at_3, t0.alt_image AS alt_image_4, t0.alt_image_ca AS alt_image_ca_5, t0.alt_image_es AS alt_image_es_6, t0.alt_image_fr AS alt_image_fr_7, t0.alt_image_en AS alt_image_en_8, t0.alt_image_it AS alt_image_it_9, t0.alt_image_kr AS alt_image_kr_10, t0.desc_image AS desc_image_11, t0.desc_image_ca AS desc_image_ca_12, t0.desc_image_es AS desc_image_es_13, t0.desc_image_fr AS desc_image_fr_14, t0.desc_image_en AS desc_image_en_15, t0.desc_image_it AS desc_image_it_16, t0.desc_image_kr AS desc_image_kr_17, t0.position AS position_18 FROM image t0 INNER JOIN room_image ON t0.id = room_image.image_id WHERE room_image.room_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.image AS image_2, t0.updated_at AS updated_at_3, t0.alt_image AS alt_image_4, t0.alt_image_ca AS alt_image_ca_5, t0.alt_image_es AS alt_image_es_6, t0.alt_image_fr AS alt_image_fr_7, t0.alt_image_en AS alt_image_en_8, t0.alt_image_it AS alt_image_it_9, t0.alt_image_kr AS alt_image_kr_10, t0.desc_image AS desc_image_11, t0.desc_image_ca AS desc_image_ca_12, t0.desc_image_es AS desc_image_es_13, t0.desc_image_fr AS desc_image_fr_14, t0.desc_image_en AS desc_image_en_15, t0.desc_image_it AS desc_image_it_16, t0.desc_image_kr AS desc_image_kr_17, t0.position AS position_18 FROM image t0 INNER JOIN room_image ON t0.id = room_image.image_id WHERE room_image.room_id = 1 ORDER BY t0.position ASC;
|
| 11 |
0.40 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.updated_at AS updated_at_4, t0.is_published AS is_published_5 FROM room_service t0 INNER JOIN room_room_service ON t0.id = room_room_service.room_service_id WHERE room_room_service.room_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.updated_at AS updated_at_4, t0.is_published AS is_published_5 FROM room_service t0 INNER JOIN room_room_service ON t0.id = room_room_service.room_service_id WHERE room_room_service.room_id = 1;
|
| 12 |
0.26 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.room_service_id AS room_service_id_4, t0.language_id AS language_id_5 FROM room_service_content t0 WHERE t0.room_service_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.room_service_id AS room_service_id_4, t0.language_id AS language_id_5 FROM room_service_content t0 WHERE t0.room_service_id = 1;
|
| 13 |
0.13 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.room_service_id AS room_service_id_4, t0.language_id AS language_id_5 FROM room_service_content t0 WHERE t0.room_service_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.room_service_id AS room_service_id_4, t0.language_id AS language_id_5 FROM room_service_content t0 WHERE t0.room_service_id = 2;
|
| 14 |
0.11 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.room_service_id AS room_service_id_4, t0.language_id AS language_id_5 FROM room_service_content t0 WHERE t0.room_service_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.room_service_id AS room_service_id_4, t0.language_id AS language_id_5 FROM room_service_content t0 WHERE t0.room_service_id = 3;
|
| 15 |
0.14 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.room_service_id AS room_service_id_4, t0.language_id AS language_id_5 FROM room_service_content t0 WHERE t0.room_service_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.room_service_id AS room_service_id_4, t0.language_id AS language_id_5 FROM room_service_content t0 WHERE t0.room_service_id = 4;
|
| 16 |
0.15 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.room_service_id AS room_service_id_4, t0.language_id AS language_id_5 FROM room_service_content t0 WHERE t0.room_service_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.room_service_id AS room_service_id_4, t0.language_id AS language_id_5 FROM room_service_content t0 WHERE t0.room_service_id = 5;
|
| 17 |
0.12 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.room_service_id AS room_service_id_4, t0.language_id AS language_id_5 FROM room_service_content t0 WHERE t0.room_service_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.room_service_id AS room_service_id_4, t0.language_id AS language_id_5 FROM room_service_content t0 WHERE t0.room_service_id = 7;
|
| 18 |
0.20 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.room_service_id AS room_service_id_4, t0.language_id AS language_id_5 FROM room_service_content t0 WHERE t0.room_service_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.room_service_id AS room_service_id_4, t0.language_id AS language_id_5 FROM room_service_content t0 WHERE t0.room_service_id = 9;
|
| 19 |
0.16 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.room_service_id AS room_service_id_4, t0.language_id AS language_id_5 FROM room_service_content t0 WHERE t0.room_service_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.room_service_id AS room_service_id_4, t0.language_id AS language_id_5 FROM room_service_content t0 WHERE t0.room_service_id = 10;
|
| 20 |
0.30 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.room_service_id AS room_service_id_4, t0.language_id AS language_id_5 FROM room_service_content t0 WHERE t0.room_service_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.room_service_id AS room_service_id_4, t0.language_id AS language_id_5 FROM room_service_content t0 WHERE t0.room_service_id = 15;
|
| 21 |
16.47 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_published AS is_published_3, t0.position AS position_4, t0.main_image_id AS main_image_id_5 FROM room t0 WHERE t0.is_published = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_published AS is_published_3, t0.position AS position_4, t0.main_image_id AS main_image_id_5 FROM room t0 WHERE t0.is_published = 1;
|
| 22 |
0.28 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = 1 AND t0.language_id = 'ca' LIMIT 1;
|
| 23 |
0.28 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.body AS body_5, t0.rate AS rate_6, t0.is_published AS is_published_7, t0.language_id AS language_id_8 FROM review t0 WHERE t0.is_published = ?
SELECT t0.id AS id_1, t0.date AS date_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.body AS body_5, t0.rate AS rate_6, t0.is_published AS is_published_7, t0.language_id AS language_id_8 FROM review t0 WHERE t0.is_published = 1;
|