Symfony Profiler

Query Metrics

72 Database Queries
12 Different statements
45.56 ms Query time
0 Invalid entities
Queries


SELECT e0_.name AS name_0, e0_.note AS note_1, e0_.manager AS manager_2, e0_.reference AS reference_3, e0_.phone AS phone_4, e0_.description AS description_5, e0_.website AS website_6, e0_.email AS email_7, e0_.phone2 AS phone2_8, e0_.view_number AS view_number_9, e0_.verified AS verified_10, e0_.score AS score_11, e0_.keywords AS keywords_12, e0_.place_id AS place_id_13, e0_.platform AS platform_14, e0_.version AS version_15, e0_.google_type AS google_type_16, e0_.google_photos AS google_photos_17, e0_.map_url AS map_url_18, e0_.weekday_text AS weekday_text_19, e0_.enabled AS enabled_20, e0_.ranks AS ranks_21, e0_.full_address AS full_address_22, e0_.latitude AS latitude_23, e0_.longitude AS longitude_24, e0_.created_at AS created_at_25, e0_.updated_at AS updated_at_26, e0_.slug AS slug_27, e0_.id AS id_28, e0_.facebook AS facebook_29, e0_.youtube AS youtube_30, e0_.instagram AS instagram_31, e0_.twitter AS twitter_32, e0_.google_plus AS google_plus_33, e0_.region_id AS region_id_34, e0_.commune_id AS commune_id_35, e0_.city_id AS city_id_36, e0_.quartier_id AS quartier_id_37, e0_.sub_prefecture_id AS sub_prefecture_id_38, e0_.prefecture_id AS prefecture_id_39, e0_.campagne_id AS campagne_id_40, e0_.operator_id AS operator_id_41, e0_.quotation_id AS quotation_id_42 FROM establishment e0_ WHERE e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT c0_.name AS name_0, c0_.start_at AS start_at_1, c0_.end_at AS end_at_2, c0_.status AS status_3, c0_.space AS space_4, c0_.type AS type_5, c0_.title AS title_6, c0_.content AS content_7, c0_.ranks AS ranks_8, c0_.summary AS summary_9, c0_.link AS link_10, c0_.id AS id_11, c0_.created_at AS created_at_12, c0_.updated_at AS updated_at_13 FROM campagne c0_ WHERE c0_.status = ? AND c0_.start_at <= ? AND c0_.end_at >= ? ORDER BY c0_.id ASC LIMIT 4
SELECT t0.id AS id_1, t0.number AS number_2, t0.category_id AS category_id_3 FROM establishment_per_category t0
SELECT s0_.name AS name_0, s0_.latitude AS latitude_1, s0_.longitude AS longitude_2, s0_.id AS id_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.slug AS slug_6, s0_.prefecture_id AS prefecture_id_7 FROM sub_prefecture s0_ ORDER BY s0_.name ASC
SELECT c0_.name AS name_0, c0_.second_name AS second_name_1, c0_.reference AS reference_2, c0_.icon AS icon_3, c0_.score AS score_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.slug AS slug_7, c0_.id AS id_8, c0_.parent_id AS parent_id_9, c0_.popular_category_id AS popular_category_id_10, c0_.quotation_id AS quotation_id_11 FROM category c0_ ORDER BY c0_.name ASC
SELECT c0_.name AS name_0, c0_.second_name AS second_name_1, c0_.reference AS reference_2, c0_.icon AS icon_3, c0_.score AS score_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.slug AS slug_7, c0_.id AS id_8, c0_.parent_id AS parent_id_9, c0_.popular_category_id AS popular_category_id_10, c0_.quotation_id AS quotation_id_11 FROM category c0_
SELECT e0_.name AS name_0, e0_.note AS note_1, e0_.manager AS manager_2, e0_.reference AS reference_3, e0_.phone AS phone_4, e0_.description AS description_5, e0_.website AS website_6, e0_.email AS email_7, e0_.phone2 AS phone2_8, e0_.view_number AS view_number_9, e0_.verified AS verified_10, e0_.score AS score_11, e0_.keywords AS keywords_12, e0_.place_id AS place_id_13, e0_.platform AS platform_14, e0_.version AS version_15, e0_.google_type AS google_type_16, e0_.google_photos AS google_photos_17, e0_.map_url AS map_url_18, e0_.weekday_text AS weekday_text_19, e0_.enabled AS enabled_20, e0_.ranks AS ranks_21, e0_.full_address AS full_address_22, e0_.latitude AS latitude_23, e0_.longitude AS longitude_24, e0_.created_at AS created_at_25, e0_.updated_at AS updated_at_26, e0_.slug AS slug_27, e0_.id AS id_28, e0_.facebook AS facebook_29, e0_.youtube AS youtube_30, e0_.instagram AS instagram_31, e0_.twitter AS twitter_32, e0_.google_plus AS google_plus_33, e0_.region_id AS region_id_34, e0_.commune_id AS commune_id_35, e0_.city_id AS city_id_36, e0_.quartier_id AS quartier_id_37, e0_.sub_prefecture_id AS sub_prefecture_id_38, e0_.prefecture_id AS prefecture_id_39, e0_.campagne_id AS campagne_id_40, e0_.operator_id AS operator_id_41, e0_.quotation_id AS quotation_id_42 FROM establishment e0_
SELECT r0_.name AS name_0, r0_.latitude AS latitude_1, r0_.longitude AS longitude_2, r0_.id AS id_3, r0_.created_at AS created_at_4, r0_.updated_at AS updated_at_5, r0_.slug AS slug_6 FROM region r0_
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN establishment_category ON t0.id = establishment_category.category_id WHERE establishment_category.establishment_id = ?
SELECT t0.content AS content_1, t0.rating AS rating_2, t0.value_money AS value_money_3, t0.location AS location_4, t0.cleanliness AS cleanliness_5, t0.author_url AS author_url_6, t0.google_comment_created_at AS google_comment_created_at_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.establishement_id AS establishement_id_13, t0.author_id AS author_id_14 FROM COMMENT t0 WHERE t0.establishement_id = ?
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN establishment_category ON t0.id = establishment_category.category_id WHERE establishment_category.establishment_id = ?
SELECT t0.content AS content_1, t0.rating AS rating_2, t0.value_money AS value_money_3, t0.location AS location_4, t0.cleanliness AS cleanliness_5, t0.author_url AS author_url_6, t0.google_comment_created_at AS google_comment_created_at_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.establishement_id AS establishement_id_13, t0.author_id AS author_id_14 FROM COMMENT t0 WHERE t0.establishement_id = ?
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN establishment_category ON t0.id = establishment_category.category_id WHERE establishment_category.establishment_id = ?
SELECT t0.content AS content_1, t0.rating AS rating_2, t0.value_money AS value_money_3, t0.location AS location_4, t0.cleanliness AS cleanliness_5, t0.author_url AS author_url_6, t0.google_comment_created_at AS google_comment_created_at_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.establishement_id AS establishement_id_13, t0.author_id AS author_id_14 FROM COMMENT t0 WHERE t0.establishement_id = ?
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN establishment_category ON t0.id = establishment_category.category_id WHERE establishment_category.establishment_id = ?
SELECT t0.content AS content_1, t0.rating AS rating_2, t0.value_money AS value_money_3, t0.location AS location_4, t0.cleanliness AS cleanliness_5, t0.author_url AS author_url_6, t0.google_comment_created_at AS google_comment_created_at_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.establishement_id AS establishement_id_13, t0.author_id AS author_id_14 FROM COMMENT t0 WHERE t0.establishement_id = ?
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN establishment_category ON t0.id = establishment_category.category_id WHERE establishment_category.establishment_id = ?
SELECT t0.content AS content_1, t0.rating AS rating_2, t0.value_money AS value_money_3, t0.location AS location_4, t0.cleanliness AS cleanliness_5, t0.author_url AS author_url_6, t0.google_comment_created_at AS google_comment_created_at_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.establishement_id AS establishement_id_13, t0.author_id AS author_id_14 FROM COMMENT t0 WHERE t0.establishement_id = ?
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN establishment_category ON t0.id = establishment_category.category_id WHERE establishment_category.establishment_id = ?
SELECT t0.content AS content_1, t0.rating AS rating_2, t0.value_money AS value_money_3, t0.location AS location_4, t0.cleanliness AS cleanliness_5, t0.author_url AS author_url_6, t0.google_comment_created_at AS google_comment_created_at_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.establishement_id AS establishement_id_13, t0.author_id AS author_id_14 FROM COMMENT t0 WHERE t0.establishement_id = ?
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN establishment_category ON t0.id = establishment_category.category_id WHERE establishment_category.establishment_id = ?
SELECT t0.content AS content_1, t0.rating AS rating_2, t0.value_money AS value_money_3, t0.location AS location_4, t0.cleanliness AS cleanliness_5, t0.author_url AS author_url_6, t0.google_comment_created_at AS google_comment_created_at_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.establishement_id AS establishement_id_13, t0.author_id AS author_id_14 FROM COMMENT t0 WHERE t0.establishement_id = ?
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN establishment_category ON t0.id = establishment_category.category_id WHERE establishment_category.establishment_id = ?
SELECT t0.content AS content_1, t0.rating AS rating_2, t0.value_money AS value_money_3, t0.location AS location_4, t0.cleanliness AS cleanliness_5, t0.author_url AS author_url_6, t0.google_comment_created_at AS google_comment_created_at_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.establishement_id AS establishement_id_13, t0.author_id AS author_id_14 FROM COMMENT t0 WHERE t0.establishement_id = ?
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN establishment_category ON t0.id = establishment_category.category_id WHERE establishment_category.establishment_id = ?
SELECT t0.content AS content_1, t0.rating AS rating_2, t0.value_money AS value_money_3, t0.location AS location_4, t0.cleanliness AS cleanliness_5, t0.author_url AS author_url_6, t0.google_comment_created_at AS google_comment_created_at_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.establishement_id AS establishement_id_13, t0.author_id AS author_id_14 FROM COMMENT t0 WHERE t0.establishement_id = ?
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN establishment_category ON t0.id = establishment_category.category_id WHERE establishment_category.establishment_id = ?
SELECT t0.content AS content_1, t0.rating AS rating_2, t0.value_money AS value_money_3, t0.location AS location_4, t0.cleanliness AS cleanliness_5, t0.author_url AS author_url_6, t0.google_comment_created_at AS google_comment_created_at_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.establishement_id AS establishement_id_13, t0.author_id AS author_id_14 FROM COMMENT t0 WHERE t0.establishement_id = ?
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN establishment_category ON t0.id = establishment_category.category_id WHERE establishment_category.establishment_id = ?
SELECT t0.content AS content_1, t0.rating AS rating_2, t0.value_money AS value_money_3, t0.location AS location_4, t0.cleanliness AS cleanliness_5, t0.author_url AS author_url_6, t0.google_comment_created_at AS google_comment_created_at_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.establishement_id AS establishement_id_13, t0.author_id AS author_id_14 FROM COMMENT t0 WHERE t0.establishement_id = ?
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN establishment_category ON t0.id = establishment_category.category_id WHERE establishment_category.establishment_id = ?
SELECT t0.content AS content_1, t0.rating AS rating_2, t0.value_money AS value_money_3, t0.location AS location_4, t0.cleanliness AS cleanliness_5, t0.author_url AS author_url_6, t0.google_comment_created_at AS google_comment_created_at_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.establishement_id AS establishement_id_13, t0.author_id AS author_id_14 FROM COMMENT t0 WHERE t0.establishement_id = ?
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN establishment_category ON t0.id = establishment_category.category_id WHERE establishment_category.establishment_id = ?
SELECT t0.content AS content_1, t0.rating AS rating_2, t0.value_money AS value_money_3, t0.location AS location_4, t0.cleanliness AS cleanliness_5, t0.author_url AS author_url_6, t0.google_comment_created_at AS google_comment_created_at_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.establishement_id AS establishement_id_13, t0.author_id AS author_id_14 FROM COMMENT t0 WHERE t0.establishement_id = ?
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN establishment_category ON t0.id = establishment_category.category_id WHERE establishment_category.establishment_id = ?
SELECT t0.content AS content_1, t0.rating AS rating_2, t0.value_money AS value_money_3, t0.location AS location_4, t0.cleanliness AS cleanliness_5, t0.author_url AS author_url_6, t0.google_comment_created_at AS google_comment_created_at_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.establishement_id AS establishement_id_13, t0.author_id AS author_id_14 FROM COMMENT t0 WHERE t0.establishement_id = ?
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN establishment_category ON t0.id = establishment_category.category_id WHERE establishment_category.establishment_id = ?
SELECT t0.content AS content_1, t0.rating AS rating_2, t0.value_money AS value_money_3, t0.location AS location_4, t0.cleanliness AS cleanliness_5, t0.author_url AS author_url_6, t0.google_comment_created_at AS google_comment_created_at_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.establishement_id AS establishement_id_13, t0.author_id AS author_id_14 FROM COMMENT t0 WHERE t0.establishement_id = ?
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN establishment_category ON t0.id = establishment_category.category_id WHERE establishment_category.establishment_id = ?
SELECT t0.content AS content_1, t0.rating AS rating_2, t0.value_money AS value_money_3, t0.location AS location_4, t0.cleanliness AS cleanliness_5, t0.author_url AS author_url_6, t0.google_comment_created_at AS google_comment_created_at_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.establishement_id AS establishement_id_13, t0.author_id AS author_id_14 FROM COMMENT t0 WHERE t0.establishement_id = ?
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN establishment_category ON t0.id = establishment_category.category_id WHERE establishment_category.establishment_id = ?
SELECT t0.content AS content_1, t0.rating AS rating_2, t0.value_money AS value_money_3, t0.location AS location_4, t0.cleanliness AS cleanliness_5, t0.author_url AS author_url_6, t0.google_comment_created_at AS google_comment_created_at_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.establishement_id AS establishement_id_13, t0.author_id AS author_id_14 FROM COMMENT t0 WHERE t0.establishement_id = ?
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN establishment_category ON t0.id = establishment_category.category_id WHERE establishment_category.establishment_id = ?
SELECT t0.content AS content_1, t0.rating AS rating_2, t0.value_money AS value_money_3, t0.location AS location_4, t0.cleanliness AS cleanliness_5, t0.author_url AS author_url_6, t0.google_comment_created_at AS google_comment_created_at_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.establishement_id AS establishement_id_13, t0.author_id AS author_id_14 FROM COMMENT t0 WHERE t0.establishement_id = ?
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN establishment_category ON t0.id = establishment_category.category_id WHERE establishment_category.establishment_id = ?
SELECT t0.content AS content_1, t0.rating AS rating_2, t0.value_money AS value_money_3, t0.location AS location_4, t0.cleanliness AS cleanliness_5, t0.author_url AS author_url_6, t0.google_comment_created_at AS google_comment_created_at_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.establishement_id AS establishement_id_13, t0.author_id AS author_id_14 FROM COMMENT t0 WHERE t0.establishement_id = ?
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN establishment_category ON t0.id = establishment_category.category_id WHERE establishment_category.establishment_id = ?
SELECT t0.content AS content_1, t0.rating AS rating_2, t0.value_money AS value_money_3, t0.location AS location_4, t0.cleanliness AS cleanliness_5, t0.author_url AS author_url_6, t0.google_comment_created_at AS google_comment_created_at_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.establishement_id AS establishement_id_13, t0.author_id AS author_id_14 FROM COMMENT t0 WHERE t0.establishement_id = ?
SELECT t0.name AS name_1, t0.note AS note_2, t0.manager AS manager_3, t0.reference AS reference_4, t0.phone AS phone_5, t0.description AS description_6, t0.website AS website_7, t0.email AS email_8, t0.phone2 AS phone2_9, t0.view_number AS view_number_10, t0.verified AS verified_11, t0.score AS score_12, t0.keywords AS keywords_13, t0.place_id AS place_id_14, t0.platform AS platform_15, t0.version AS version_16, t0.google_type AS google_type_17, t0.google_photos AS google_photos_18, t0.map_url AS map_url_19, t0.weekday_text AS weekday_text_20, t0.enabled AS enabled_21, t0.ranks AS ranks_22, t0.full_address AS full_address_23, t0.latitude AS latitude_24, t0.longitude AS longitude_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.slug AS slug_28, t0.id AS id_29, t0.facebook AS facebook_30, t0.youtube AS youtube_31, t0.instagram AS instagram_32, t0.twitter AS twitter_33, t0.google_plus AS google_plus_34, t0.region_id AS region_id_35, t0.commune_id AS commune_id_36, t0.city_id AS city_id_37, t0.quartier_id AS quartier_id_38, t0.sub_prefecture_id AS sub_prefecture_id_39, t0.prefecture_id AS prefecture_id_40, t0.campagne_id AS campagne_id_41, t0.operator_id AS operator_id_42, t0.quotation_id AS quotation_id_43 FROM establishment t0 WHERE t0.campagne_id = ?
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
SELECT t0.name AS name_1, t0.note AS note_2, t0.manager AS manager_3, t0.reference AS reference_4, t0.phone AS phone_5, t0.description AS description_6, t0.website AS website_7, t0.email AS email_8, t0.phone2 AS phone2_9, t0.view_number AS view_number_10, t0.verified AS verified_11, t0.score AS score_12, t0.keywords AS keywords_13, t0.place_id AS place_id_14, t0.platform AS platform_15, t0.version AS version_16, t0.google_type AS google_type_17, t0.google_photos AS google_photos_18, t0.map_url AS map_url_19, t0.weekday_text AS weekday_text_20, t0.enabled AS enabled_21, t0.ranks AS ranks_22, t0.full_address AS full_address_23, t0.latitude AS latitude_24, t0.longitude AS longitude_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.slug AS slug_28, t0.id AS id_29, t0.facebook AS facebook_30, t0.youtube AS youtube_31, t0.instagram AS instagram_32, t0.twitter AS twitter_33, t0.google_plus AS google_plus_34, t0.region_id AS region_id_35, t0.commune_id AS commune_id_36, t0.city_id AS city_id_37, t0.quartier_id AS quartier_id_38, t0.sub_prefecture_id AS sub_prefecture_id_39, t0.prefecture_id AS prefecture_id_40, t0.campagne_id AS campagne_id_41, t0.operator_id AS operator_id_42, t0.quotation_id AS quotation_id_43 FROM establishment t0 WHERE t0.campagne_id = ?
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
Database Connections

Name	Service
default	doctrine.dbal.default_connection
Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
Second Level Cache

Second Level Cache is not enabled.
Entities Mapping

Class	Mapping errors
App\Entity\Category	No errors.
App\Entity\Establishment	No errors.
App\Entity\Region	No errors.
App\Entity\Commune	No errors.
App\Entity\City	No errors.
App\Entity\Quartier	No errors.
App\Entity\SubPrefecture	No errors.
App\Entity\Prefecture	No errors.
App\Entity\Campagne	No errors.
App\Entity\Operator	No errors.
App\Entity\Quotation	No errors.
App\Entity\Image	No errors.
App\Entity\OpeningHours	No errors.
App\Entity\PricingList	No errors.
App\Entity\Comment	No errors.
App\Entity\Address	No errors.
App\Entity\Booking	No errors.
App\Entity\EstablishmentAdd	No errors.
App\Entity\JobOffert	No errors.
App\Entity\Amenity	No errors.
App\Entity\PopularCategory	No errors.
App\Entity\EstablishmentPerCategory	No errors.
App\Entity\LandingPage	No errors.
App\Entity\Author	No errors.
Symfony Profiler

GET http://193.70.3.237/index.php/establishment/search/establishmen/list?list=all&page=39

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping
