| 1 |
1.08 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.role_suffix AS role_suffix_4, t0.email AS email_5, t0.photo AS photo_6, t0.website AS website_7, t0.key_collection_times AS key_collection_times_8, t0.come_by_car AS come_by_car_9, t0.come_by_plane AS come_by_plane_10, t0.come_by_train AS come_by_train_11, t0.description AS description_12, t0.name AS name_13, t0.name_localization AS name_localization_14, t0.slug AS slug_15, t0.template_folder AS template_folder_16, t0.address AS address_17, t0.zipcode AS zipcode_18, t0.city AS city_19, t0.country AS country_20, t0.phone AS phone_21, t0.information AS information_22, t0.manager_firstname AS manager_firstname_23, t0.manager_lastname AS manager_lastname_24, t0.manager_email AS manager_email_25, t0.comment AS comment_26, t0.public AS public_27, t0.active AS active_28, t0.configured AS configured_29, t0.position AS position_30 FROM nw_residence t0 WHERE t0.slug = ? AND t0.active = ? LIMIT 1
Parameters: [
"meribel-mottaret-lesbleuets"
1
]
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.role_suffix AS role_suffix_4, t0.email AS email_5, t0.photo AS photo_6, t0.website AS website_7, t0.key_collection_times AS key_collection_times_8, t0.come_by_car AS come_by_car_9, t0.come_by_plane AS come_by_plane_10, t0.come_by_train AS come_by_train_11, t0.description AS description_12, t0.name AS name_13, t0.name_localization AS name_localization_14, t0.slug AS slug_15, t0.template_folder AS template_folder_16, t0.address AS address_17, t0.zipcode AS zipcode_18, t0.city AS city_19, t0.country AS country_20, t0.phone AS phone_21, t0.information AS information_22, t0.manager_firstname AS manager_firstname_23, t0.manager_lastname AS manager_lastname_24, t0.manager_email AS manager_email_25, t0.comment AS comment_26, t0.public AS public_27, t0.active AS active_28, t0.configured AS configured_29, t0.position AS position_30 FROM nw_residence t0 WHERE t0.slug = 'meribel-mottaret-lesbleuets' AND t0.active = 1 LIMIT 1;
|
| 2 |
1.16 ms |
SELECT n0_.id AS id_0, n0_.date AS date_1, n0_.name AS name_2, n0_.content AS content_3, n0_.slug AS slug_4, n0_.comment AS comment_5, n0_.supervisor AS supervisor_6, n0_.admin AS admin_7, n0_.editor AS editor_8, n0_.premium AS premium_9, n0_.std AS std_10, n0_.visitor AS visitor_11, n0_.front AS front_12, n0_.published AS published_13, n0_.pinned AS pinned_14, n0_.residence_id AS residence_id_15, n0_.document_id AS document_id_16 FROM nw_note n0_ WHERE n0_.residence_id = ? AND n0_.front = ? AND n0_.published = ? ORDER BY n0_.date DESC
SELECT n0_.id AS id_0, n0_.date AS date_1, n0_.name AS name_2, n0_.content AS content_3, n0_.slug AS slug_4, n0_.comment AS comment_5, n0_.supervisor AS supervisor_6, n0_.admin AS admin_7, n0_.editor AS editor_8, n0_.premium AS premium_9, n0_.std AS std_10, n0_.visitor AS visitor_11, n0_.front AS front_12, n0_.published AS published_13, n0_.pinned AS pinned_14, n0_.residence_id AS residence_id_15, n0_.document_id AS document_id_16 FROM nw_note n0_ WHERE n0_.residence_id = 25 AND n0_.front = 1 AND n0_.published = 1 ORDER BY n0_.date DESC;
|
| 3 |
0.87 ms |
SELECT n0_.id AS id_0, n0_.date AS date_1, n0_.name AS name_2, n0_.comment AS comment_3 FROM nw_category n0_ WHERE n0_.name <> ? ORDER BY n0_.name ASC
SELECT n0_.id AS id_0, n0_.date AS date_1, n0_.name AS name_2, n0_.comment AS comment_3 FROM nw_category n0_ WHERE n0_.name <> 'system' ORDER BY n0_.name ASC;
|
| 4 |
1.29 ms |
SELECT n0_.id AS id_0, n0_.date AS date_1, n0_.name AS name_2, n0_.comment AS comment_3 FROM nw_category n0_ LEFT JOIN nw_note_category n1_ ON (n1_.category_id = n0_.id) LEFT JOIN nw_note n2_ ON (n1_.note_id = n2_.id) WHERE n1_.category_id IS NOT NULL
SELECT n0_.id AS id_0, n0_.date AS date_1, n0_.name AS name_2, n0_.comment AS comment_3 FROM nw_category n0_ LEFT JOIN nw_note_category n1_ ON (n1_.category_id = n0_.id) LEFT JOIN nw_note n2_ ON (n1_.note_id = n2_.id) WHERE n1_.category_id IS NOT NULL;
|
| 5 |
0.78 ms |
SELECT n0_.id AS id_0, n0_.created_at AS created_at_1, n0_.updated_at AS updated_at_2, n0_.name AS name_3, n0_.short_name AS short_name_4, n0_.summary AS summary_5, n0_.content AS content_6, n0_.comment AS comment_7, n0_.residence_id AS residence_id_8 FROM nw_configuration n0_ WHERE n0_.short_name = ? AND n0_.residence_id = ?
Parameters: [
"meta_title"
25
]
SELECT n0_.id AS id_0, n0_.created_at AS created_at_1, n0_.updated_at AS updated_at_2, n0_.name AS name_3, n0_.short_name AS short_name_4, n0_.summary AS summary_5, n0_.content AS content_6, n0_.comment AS comment_7, n0_.residence_id AS residence_id_8 FROM nw_configuration n0_ WHERE n0_.short_name = 'meta_title' AND n0_.residence_id = 25;
|
| 6 |
0.77 ms |
SELECT n0_.id AS id_0, n0_.created_at AS created_at_1, n0_.updated_at AS updated_at_2, n0_.name AS name_3, n0_.short_name AS short_name_4, n0_.summary AS summary_5, n0_.content AS content_6, n0_.comment AS comment_7, n0_.residence_id AS residence_id_8 FROM nw_configuration n0_ WHERE n0_.short_name = ? AND n0_.residence_id = ?
Parameters: [
"meta_description"
25
]
SELECT n0_.id AS id_0, n0_.created_at AS created_at_1, n0_.updated_at AS updated_at_2, n0_.name AS name_3, n0_.short_name AS short_name_4, n0_.summary AS summary_5, n0_.content AS content_6, n0_.comment AS comment_7, n0_.residence_id AS residence_id_8 FROM nw_configuration n0_ WHERE n0_.short_name = 'meta_description' AND n0_.residence_id = 25;
|
| 7 |
0.74 ms |
SELECT n0_.id AS id_0, n0_.created_at AS created_at_1, n0_.updated_at AS updated_at_2, n0_.name AS name_3, n0_.short_name AS short_name_4, n0_.summary AS summary_5, n0_.content AS content_6, n0_.comment AS comment_7, n0_.residence_id AS residence_id_8 FROM nw_configuration n0_ WHERE n0_.short_name = ? AND n0_.residence_id = ?
Parameters: [
"meta_keywords"
25
]
SELECT n0_.id AS id_0, n0_.created_at AS created_at_1, n0_.updated_at AS updated_at_2, n0_.name AS name_3, n0_.short_name AS short_name_4, n0_.summary AS summary_5, n0_.content AS content_6, n0_.comment AS comment_7, n0_.residence_id AS residence_id_8 FROM nw_configuration n0_ WHERE n0_.short_name = 'meta_keywords' AND n0_.residence_id = 25;
|
| 8 |
0.75 ms |
SELECT n0_.id AS id_0, n0_.created_at AS created_at_1, n0_.updated_at AS updated_at_2, n0_.name AS name_3, n0_.short_name AS short_name_4, n0_.summary AS summary_5, n0_.content AS content_6, n0_.comment AS comment_7, n0_.residence_id AS residence_id_8 FROM nw_configuration n0_ WHERE n0_.short_name = ? AND n0_.residence_id = ?
Parameters: [
"meta_author"
25
]
SELECT n0_.id AS id_0, n0_.created_at AS created_at_1, n0_.updated_at AS updated_at_2, n0_.name AS name_3, n0_.short_name AS short_name_4, n0_.summary AS summary_5, n0_.content AS content_6, n0_.comment AS comment_7, n0_.residence_id AS residence_id_8 FROM nw_configuration n0_ WHERE n0_.short_name = 'meta_author' AND n0_.residence_id = 25;
|
| 9 |
0.64 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.name AS name_3, t0.description AS description_4, t0.file_name AS file_name_5, t0.slug AS slug_6, t0.comment AS comment_7 FROM nw_document t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.date AS date_2, t0.name AS name_3, t0.description AS description_4, t0.file_name AS file_name_5, t0.slug AS slug_6, t0.comment AS comment_7 FROM nw_document t0 WHERE t0.id = 153;
|
| 10 |
0.63 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.name AS name_3, t0.description AS description_4, t0.file_name AS file_name_5, t0.slug AS slug_6, t0.comment AS comment_7 FROM nw_document t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.date AS date_2, t0.name AS name_3, t0.description AS description_4, t0.file_name AS file_name_5, t0.slug AS slug_6, t0.comment AS comment_7 FROM nw_document t0 WHERE t0.id = 125;
|
| 11 |
0.60 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.name AS name_3, t0.description AS description_4, t0.file_name AS file_name_5, t0.slug AS slug_6, t0.comment AS comment_7 FROM nw_document t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.date AS date_2, t0.name AS name_3, t0.description AS description_4, t0.file_name AS file_name_5, t0.slug AS slug_6, t0.comment AS comment_7 FROM nw_document t0 WHERE t0.id = 60;
|