GET https://dev.communesmaroc.com/zh/commune/talmakante/add-your-business

Query Metrics

38 Database Queries
12 Different statements
18.01 ms Query time
4 Invalid entities
81 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.31 ms
SELECT revision FROM t_product_publication_state WHERE id = 1
Parameters:
[]
2 0.69 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.codeGeo16 AS codeGeo16_3, t0.codeGeo12 AS codeGeo12_4, t0.codeGeo12_2 AS codeGeo12_2_5, t0.woeid AS woeid_6, t0._type AS _type_7, t0._type2 AS _type2_8, t0._type3 AS _type3_9, t0.url AS url_10, t0.slogan AS slogan_11, t0.path AS path_12, t0.logo_450x100 AS logo_450x100_13, t0.background_image AS background_image_14, t0.background_images AS background_images_15, t0.description AS description_16, t0.welcome AS welcome_17, t0.keywords AS keywords_18, t0.seo_description AS seo_description_19, t0._text AS _text_20, t0.address AS address_21, t0.mayor AS mayor_22, t0.website AS website_23, t0.facebook AS facebook_24, t0.twitter AS twitter_25, t0.instagram AS instagram_26, t0.pinterest AS pinterest_27, t0.zip_code AS zip_code_28, t0.altitude AS altitude_29, t0.superficie_old AS superficie_old_30, t0.superficie AS superficie_31, t0.latitude AS latitude_32, t0.northeast_latitude AS northeast_latitude_33, t0.southwest_latitude AS southwest_latitude_34, t0.longitude AS longitude_35, t0.northeast_longitude AS northeast_longitude_36, t0.southwest_longitude AS southwest_longitude_37, t0.fax AS fax_38, t0.tel AS tel_39, t0.google_tag AS google_tag_40, t0.density AS density_41, t0.codeWeather AS codeWeather_42, t0.total_comment AS total_comment_43, t0.tags AS tags_44, t0.views AS views_45, t0.flag_img AS flag_img_46, t0.thumb_225x130 AS thumb_225x130_47, t0.location_map_img AS location_map_img_48, t0.ean_done AS ean_done_49, t0.total_hotels AS total_hotels_50, t0.total_hotels_new AS total_hotels_new_51, t0.total_hospitals AS total_hospitals_52, t0.total_health_centers AS total_health_centers_53, t0.total_e_institutions AS total_e_institutions_54, t0.total_news AS total_news_55, t0.total_albums AS total_albums_56, t0.total_videos AS total_videos_57, t0.total_events AS total_events_58, t0.total_images AS total_images_59, t0.total_cafes AS total_cafes_60, t0.total_restaurants AS total_restaurants_61, t0.total_places AS total_places_62, t0.total_spots AS total_spots_63, t0.total_activities AS total_activities_64, t0.total_tours AS total_tours_65, t0.has_prayer_times AS has_prayer_times_66, t0.has_weather AS has_weather_67, t0.is_trending AS is_trending_68, t0.created_at AS created_at_69, t0.updated_at AS updated_at_70, t0.created_at_gmt AS created_at_gmt_71, t0.updated_at_gmt AS updated_at_gmt_72, t0.image_name AS image_name_73, t0.image_size AS image_size_74, t0.rating AS rating_75, t0.price_range AS price_range_76, t0.total_reviews AS total_reviews_77, t0.uuid4 AS uuid4_78, t0.slug AS slug_79, t0.province_id AS province_id_80, t0.unique_identifier AS unique_identifier_81, t0.provider_id AS provider_id_82 FROM t_communes t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "talmakante"
]
3 0.54 ms
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.flaticon AS flaticon_3, t0.background_image AS background_image_4, t0.name AS name_5, t0.verb AS verb_6, t0.code AS code_7, t0._status AS _status_8, t0.total_place AS total_place_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.created_at_gmt AS created_at_gmt_12, t0.updated_at_gmt AS updated_at_gmt_13, t0.parent_id AS parent_id_14 FROM t_place_categories t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "food"
]
4 0.71 ms
SELECT t0_.id AS id_0, t0_.icon AS icon_1, t0_.flaticon AS flaticon_2, t0_.background_image AS background_image_3, t0_.name AS name_4, t0_.verb AS verb_5, t0_.code AS code_6, t0_._status AS _status_7, t0_.total_place AS total_place_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t0_.created_at_gmt AS created_at_gmt_11, t0_.updated_at_gmt AS updated_at_gmt_12, t1_.id AS id_13, t1_.name AS name_14, t1_.verb AS verb_15, t1_.created_at AS created_at_16, t1_.updated_at AS updated_at_17, t1_.created_at_gmt AS created_at_gmt_18, t1_.updated_at_gmt AS updated_at_gmt_19, t0_.parent_id AS parent_id_20, t1_.category_id AS category_id_21, t1_.lang AS lang_22 FROM t_place_categories t0_ LEFT JOIN t_place_categories_xl t1_ ON t0_.id = t1_.category_id WHERE t1_.lang = ? ORDER BY t1_.name ASC
Parameters:
[
  "zh"
]
5 0.69 ms
SELECT t0.id AS id_1, t0.province_old_id AS province_old_id_2, t0.codeGeo AS codeGeo_3, t0.name AS name_4, t0.url AS url_5, t0.path AS path_6, t0.fax AS fax_7, t0.tel AS tel_8, t0.density AS density_9, t0.description AS description_10, t0.welcome AS welcome_11, t0.seo_description AS seo_description_12, t0.address AS address_13, t0._text AS _text_14, t0.type AS type_15, t0.longitude AS longitude_16, t0.latitude AS latitude_17, t0.superficie AS superficie_18, t0.cheflieu AS cheflieu_19, t0.total_commune AS total_commune_20, t0.total_arrondissement AS total_arrondissement_21, t0.total_commune_rural AS total_commune_rural_22, t0.total_commune_urbain AS total_commune_urbain_23, t0.total_city AS total_city_24, t0.site_officiel AS site_officiel_25, t0.total_comment AS total_comment_26, t0.tags AS tags_27, t0.views AS views_28, t0.flag_img AS flag_img_29, t0.location_map_img AS location_map_img_30, t0.total_news AS total_news_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.created_at_gmt AS created_at_gmt_34, t0.updated_at_gmt AS updated_at_gmt_35, t0.image_name AS image_name_36, t0.image_size AS image_size_37, t0.uuid4 AS uuid4_38, t0.slug AS slug_39, t0.rating AS rating_40, t0.price_range AS price_range_41, t0.cheflieu_id AS cheflieu_id_42, t0.parent_id AS parent_id_43, t0.region_id AS region_id_44, t0.unique_identifier AS unique_identifier_45, t0.provider_id AS provider_id_46 FROM t_provinces t0 WHERE t0.id = ?
Parameters:
[
  30063
]
6 0.46 ms
SELECT t0.id AS id_1, t0.codeGeo AS codeGeo_2, t0.name AS name_3, t0.url AS url_4, t0.path AS path_5, t0.description AS description_6, t0.welcome AS welcome_7, t0.seo_description AS seo_description_8, t0.address AS address_9, t0._text AS _text_10, t0.code AS code_11, t0.fax AS fax_12, t0.tel AS tel_13, t0.density AS density_14, t0.superficie AS superficie_15, t0.site_officiel AS site_officiel_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.total_comment AS total_comment_19, t0.tags AS tags_20, t0.views AS views_21, t0.flag_img AS flag_img_22, t0.location_map_img AS location_map_img_23, t0.total_province AS total_province_24, t0.total_subdivision AS total_subdivision_25, t0.total_prefecture AS total_prefecture_26, t0.total_arrondissement AS total_arrondissement_27, t0.total_news AS total_news_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.created_at_gmt AS created_at_gmt_31, t0.updated_at_gmt AS updated_at_gmt_32, t0.image_name AS image_name_33, t0.image_size AS image_size_34, t0.uuid4 AS uuid4_35, t0.slug AS slug_36, t0.rating AS rating_37, t0.price_range AS price_range_38, t0.cheflieu_id AS cheflieu_id_39, t0.unique_identifier AS unique_identifier_40, t0.provider_id AS provider_id_41 FROM t_regions t0 WHERE t0.id = ?
Parameters:
[
  109
]
7 0.47 ms
SELECT t0.id AS id_1, t0.codeGeo AS codeGeo_2, t0.name AS name_3, t0.url AS url_4, t0.path AS path_5, t0.description AS description_6, t0.welcome AS welcome_7, t0.seo_description AS seo_description_8, t0.address AS address_9, t0._text AS _text_10, t0.code AS code_11, t0.fax AS fax_12, t0.tel AS tel_13, t0.density AS density_14, t0.superficie AS superficie_15, t0.site_officiel AS site_officiel_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.total_comment AS total_comment_19, t0.tags AS tags_20, t0.views AS views_21, t0.flag_img AS flag_img_22, t0.location_map_img AS location_map_img_23, t0.total_province AS total_province_24, t0.total_subdivision AS total_subdivision_25, t0.total_prefecture AS total_prefecture_26, t0.total_arrondissement AS total_arrondissement_27, t0.total_news AS total_news_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.created_at_gmt AS created_at_gmt_31, t0.updated_at_gmt AS updated_at_gmt_32, t0.image_name AS image_name_33, t0.image_size AS image_size_34, t0.uuid4 AS uuid4_35, t0.slug AS slug_36, t0.rating AS rating_37, t0.price_range AS price_range_38, t0.cheflieu_id AS cheflieu_id_39, t0.unique_identifier AS unique_identifier_40, t0.provider_id AS provider_id_41 FROM t_regions t0 WHERE t0.id = ?
Parameters:
[
  100
]
8 0.38 ms
SELECT t0.id AS id_1, t0.codeGeo AS codeGeo_2, t0.name AS name_3, t0.url AS url_4, t0.path AS path_5, t0.description AS description_6, t0.welcome AS welcome_7, t0.seo_description AS seo_description_8, t0.address AS address_9, t0._text AS _text_10, t0.code AS code_11, t0.fax AS fax_12, t0.tel AS tel_13, t0.density AS density_14, t0.superficie AS superficie_15, t0.site_officiel AS site_officiel_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.total_comment AS total_comment_19, t0.tags AS tags_20, t0.views AS views_21, t0.flag_img AS flag_img_22, t0.location_map_img AS location_map_img_23, t0.total_province AS total_province_24, t0.total_subdivision AS total_subdivision_25, t0.total_prefecture AS total_prefecture_26, t0.total_arrondissement AS total_arrondissement_27, t0.total_news AS total_news_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.created_at_gmt AS created_at_gmt_31, t0.updated_at_gmt AS updated_at_gmt_32, t0.image_name AS image_name_33, t0.image_size AS image_size_34, t0.uuid4 AS uuid4_35, t0.slug AS slug_36, t0.rating AS rating_37, t0.price_range AS price_range_38, t0.cheflieu_id AS cheflieu_id_39, t0.unique_identifier AS unique_identifier_40, t0.provider_id AS provider_id_41 FROM t_regions t0 WHERE t0.id = ?
Parameters:
[
  102
]
9 0.48 ms
SELECT t0.id AS id_1, t0.codeGeo AS codeGeo_2, t0.name AS name_3, t0.url AS url_4, t0.path AS path_5, t0.description AS description_6, t0.welcome AS welcome_7, t0.seo_description AS seo_description_8, t0.address AS address_9, t0._text AS _text_10, t0.code AS code_11, t0.fax AS fax_12, t0.tel AS tel_13, t0.density AS density_14, t0.superficie AS superficie_15, t0.site_officiel AS site_officiel_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.total_comment AS total_comment_19, t0.tags AS tags_20, t0.views AS views_21, t0.flag_img AS flag_img_22, t0.location_map_img AS location_map_img_23, t0.total_province AS total_province_24, t0.total_subdivision AS total_subdivision_25, t0.total_prefecture AS total_prefecture_26, t0.total_arrondissement AS total_arrondissement_27, t0.total_news AS total_news_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.created_at_gmt AS created_at_gmt_31, t0.updated_at_gmt AS updated_at_gmt_32, t0.image_name AS image_name_33, t0.image_size AS image_size_34, t0.uuid4 AS uuid4_35, t0.slug AS slug_36, t0.rating AS rating_37, t0.price_range AS price_range_38, t0.cheflieu_id AS cheflieu_id_39, t0.unique_identifier AS unique_identifier_40, t0.provider_id AS provider_id_41 FROM t_regions t0 WHERE t0.id = ?
Parameters:
[
  103
]
10 0.55 ms
SELECT t0.id AS id_1, t0.codeGeo AS codeGeo_2, t0.name AS name_3, t0.url AS url_4, t0.path AS path_5, t0.description AS description_6, t0.welcome AS welcome_7, t0.seo_description AS seo_description_8, t0.address AS address_9, t0._text AS _text_10, t0.code AS code_11, t0.fax AS fax_12, t0.tel AS tel_13, t0.density AS density_14, t0.superficie AS superficie_15, t0.site_officiel AS site_officiel_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.total_comment AS total_comment_19, t0.tags AS tags_20, t0.views AS views_21, t0.flag_img AS flag_img_22, t0.location_map_img AS location_map_img_23, t0.total_province AS total_province_24, t0.total_subdivision AS total_subdivision_25, t0.total_prefecture AS total_prefecture_26, t0.total_arrondissement AS total_arrondissement_27, t0.total_news AS total_news_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.created_at_gmt AS created_at_gmt_31, t0.updated_at_gmt AS updated_at_gmt_32, t0.image_name AS image_name_33, t0.image_size AS image_size_34, t0.uuid4 AS uuid4_35, t0.slug AS slug_36, t0.rating AS rating_37, t0.price_range AS price_range_38, t0.cheflieu_id AS cheflieu_id_39, t0.unique_identifier AS unique_identifier_40, t0.provider_id AS provider_id_41 FROM t_regions t0 WHERE t0.id = ?
Parameters:
[
  104
]
11 0.37 ms
SELECT t0.id AS id_1, t0.codeGeo AS codeGeo_2, t0.name AS name_3, t0.url AS url_4, t0.path AS path_5, t0.description AS description_6, t0.welcome AS welcome_7, t0.seo_description AS seo_description_8, t0.address AS address_9, t0._text AS _text_10, t0.code AS code_11, t0.fax AS fax_12, t0.tel AS tel_13, t0.density AS density_14, t0.superficie AS superficie_15, t0.site_officiel AS site_officiel_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.total_comment AS total_comment_19, t0.tags AS tags_20, t0.views AS views_21, t0.flag_img AS flag_img_22, t0.location_map_img AS location_map_img_23, t0.total_province AS total_province_24, t0.total_subdivision AS total_subdivision_25, t0.total_prefecture AS total_prefecture_26, t0.total_arrondissement AS total_arrondissement_27, t0.total_news AS total_news_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.created_at_gmt AS created_at_gmt_31, t0.updated_at_gmt AS updated_at_gmt_32, t0.image_name AS image_name_33, t0.image_size AS image_size_34, t0.uuid4 AS uuid4_35, t0.slug AS slug_36, t0.rating AS rating_37, t0.price_range AS price_range_38, t0.cheflieu_id AS cheflieu_id_39, t0.unique_identifier AS unique_identifier_40, t0.provider_id AS provider_id_41 FROM t_regions t0 WHERE t0.id = ?
Parameters:
[
  105
]
12 0.36 ms
SELECT t0.id AS id_1, t0.codeGeo AS codeGeo_2, t0.name AS name_3, t0.url AS url_4, t0.path AS path_5, t0.description AS description_6, t0.welcome AS welcome_7, t0.seo_description AS seo_description_8, t0.address AS address_9, t0._text AS _text_10, t0.code AS code_11, t0.fax AS fax_12, t0.tel AS tel_13, t0.density AS density_14, t0.superficie AS superficie_15, t0.site_officiel AS site_officiel_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.total_comment AS total_comment_19, t0.tags AS tags_20, t0.views AS views_21, t0.flag_img AS flag_img_22, t0.location_map_img AS location_map_img_23, t0.total_province AS total_province_24, t0.total_subdivision AS total_subdivision_25, t0.total_prefecture AS total_prefecture_26, t0.total_arrondissement AS total_arrondissement_27, t0.total_news AS total_news_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.created_at_gmt AS created_at_gmt_31, t0.updated_at_gmt AS updated_at_gmt_32, t0.image_name AS image_name_33, t0.image_size AS image_size_34, t0.uuid4 AS uuid4_35, t0.slug AS slug_36, t0.rating AS rating_37, t0.price_range AS price_range_38, t0.cheflieu_id AS cheflieu_id_39, t0.unique_identifier AS unique_identifier_40, t0.provider_id AS provider_id_41 FROM t_regions t0 WHERE t0.id = ?
Parameters:
[
  106
]
13 0.37 ms
SELECT t0.id AS id_1, t0.codeGeo AS codeGeo_2, t0.name AS name_3, t0.url AS url_4, t0.path AS path_5, t0.description AS description_6, t0.welcome AS welcome_7, t0.seo_description AS seo_description_8, t0.address AS address_9, t0._text AS _text_10, t0.code AS code_11, t0.fax AS fax_12, t0.tel AS tel_13, t0.density AS density_14, t0.superficie AS superficie_15, t0.site_officiel AS site_officiel_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.total_comment AS total_comment_19, t0.tags AS tags_20, t0.views AS views_21, t0.flag_img AS flag_img_22, t0.location_map_img AS location_map_img_23, t0.total_province AS total_province_24, t0.total_subdivision AS total_subdivision_25, t0.total_prefecture AS total_prefecture_26, t0.total_arrondissement AS total_arrondissement_27, t0.total_news AS total_news_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.created_at_gmt AS created_at_gmt_31, t0.updated_at_gmt AS updated_at_gmt_32, t0.image_name AS image_name_33, t0.image_size AS image_size_34, t0.uuid4 AS uuid4_35, t0.slug AS slug_36, t0.rating AS rating_37, t0.price_range AS price_range_38, t0.cheflieu_id AS cheflieu_id_39, t0.unique_identifier AS unique_identifier_40, t0.provider_id AS provider_id_41 FROM t_regions t0 WHERE t0.id = ?
Parameters:
[
  107
]
14 0.37 ms
SELECT t0.id AS id_1, t0.codeGeo AS codeGeo_2, t0.name AS name_3, t0.url AS url_4, t0.path AS path_5, t0.description AS description_6, t0.welcome AS welcome_7, t0.seo_description AS seo_description_8, t0.address AS address_9, t0._text AS _text_10, t0.code AS code_11, t0.fax AS fax_12, t0.tel AS tel_13, t0.density AS density_14, t0.superficie AS superficie_15, t0.site_officiel AS site_officiel_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.total_comment AS total_comment_19, t0.tags AS tags_20, t0.views AS views_21, t0.flag_img AS flag_img_22, t0.location_map_img AS location_map_img_23, t0.total_province AS total_province_24, t0.total_subdivision AS total_subdivision_25, t0.total_prefecture AS total_prefecture_26, t0.total_arrondissement AS total_arrondissement_27, t0.total_news AS total_news_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.created_at_gmt AS created_at_gmt_31, t0.updated_at_gmt AS updated_at_gmt_32, t0.image_name AS image_name_33, t0.image_size AS image_size_34, t0.uuid4 AS uuid4_35, t0.slug AS slug_36, t0.rating AS rating_37, t0.price_range AS price_range_38, t0.cheflieu_id AS cheflieu_id_39, t0.unique_identifier AS unique_identifier_40, t0.provider_id AS provider_id_41 FROM t_regions t0 WHERE t0.id = ?
Parameters:
[
  108
]
15 0.37 ms
SELECT t0.id AS id_1, t0.codeGeo AS codeGeo_2, t0.name AS name_3, t0.url AS url_4, t0.path AS path_5, t0.description AS description_6, t0.welcome AS welcome_7, t0.seo_description AS seo_description_8, t0.address AS address_9, t0._text AS _text_10, t0.code AS code_11, t0.fax AS fax_12, t0.tel AS tel_13, t0.density AS density_14, t0.superficie AS superficie_15, t0.site_officiel AS site_officiel_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.total_comment AS total_comment_19, t0.tags AS tags_20, t0.views AS views_21, t0.flag_img AS flag_img_22, t0.location_map_img AS location_map_img_23, t0.total_province AS total_province_24, t0.total_subdivision AS total_subdivision_25, t0.total_prefecture AS total_prefecture_26, t0.total_arrondissement AS total_arrondissement_27, t0.total_news AS total_news_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.created_at_gmt AS created_at_gmt_31, t0.updated_at_gmt AS updated_at_gmt_32, t0.image_name AS image_name_33, t0.image_size AS image_size_34, t0.uuid4 AS uuid4_35, t0.slug AS slug_36, t0.rating AS rating_37, t0.price_range AS price_range_38, t0.cheflieu_id AS cheflieu_id_39, t0.unique_identifier AS unique_identifier_40, t0.provider_id AS provider_id_41 FROM t_regions t0 WHERE t0.id = ?
Parameters:
[
  110
]
16 0.37 ms
SELECT t0.id AS id_1, t0.codeGeo AS codeGeo_2, t0.name AS name_3, t0.url AS url_4, t0.path AS path_5, t0.description AS description_6, t0.welcome AS welcome_7, t0.seo_description AS seo_description_8, t0.address AS address_9, t0._text AS _text_10, t0.code AS code_11, t0.fax AS fax_12, t0.tel AS tel_13, t0.density AS density_14, t0.superficie AS superficie_15, t0.site_officiel AS site_officiel_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.total_comment AS total_comment_19, t0.tags AS tags_20, t0.views AS views_21, t0.flag_img AS flag_img_22, t0.location_map_img AS location_map_img_23, t0.total_province AS total_province_24, t0.total_subdivision AS total_subdivision_25, t0.total_prefecture AS total_prefecture_26, t0.total_arrondissement AS total_arrondissement_27, t0.total_news AS total_news_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.created_at_gmt AS created_at_gmt_31, t0.updated_at_gmt AS updated_at_gmt_32, t0.image_name AS image_name_33, t0.image_size AS image_size_34, t0.uuid4 AS uuid4_35, t0.slug AS slug_36, t0.rating AS rating_37, t0.price_range AS price_range_38, t0.cheflieu_id AS cheflieu_id_39, t0.unique_identifier AS unique_identifier_40, t0.provider_id AS provider_id_41 FROM t_regions t0 WHERE t0.id = ?
Parameters:
[
  111
]
17 0.36 ms
SELECT t0.id AS id_1, t0.codeGeo AS codeGeo_2, t0.name AS name_3, t0.url AS url_4, t0.path AS path_5, t0.description AS description_6, t0.welcome AS welcome_7, t0.seo_description AS seo_description_8, t0.address AS address_9, t0._text AS _text_10, t0.code AS code_11, t0.fax AS fax_12, t0.tel AS tel_13, t0.density AS density_14, t0.superficie AS superficie_15, t0.site_officiel AS site_officiel_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.total_comment AS total_comment_19, t0.tags AS tags_20, t0.views AS views_21, t0.flag_img AS flag_img_22, t0.location_map_img AS location_map_img_23, t0.total_province AS total_province_24, t0.total_subdivision AS total_subdivision_25, t0.total_prefecture AS total_prefecture_26, t0.total_arrondissement AS total_arrondissement_27, t0.total_news AS total_news_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.created_at_gmt AS created_at_gmt_31, t0.updated_at_gmt AS updated_at_gmt_32, t0.image_name AS image_name_33, t0.image_size AS image_size_34, t0.uuid4 AS uuid4_35, t0.slug AS slug_36, t0.rating AS rating_37, t0.price_range AS price_range_38, t0.cheflieu_id AS cheflieu_id_39, t0.unique_identifier AS unique_identifier_40, t0.provider_id AS provider_id_41 FROM t_regions t0 WHERE t0.id = ?
Parameters:
[
  112
]
18 0.64 ms
SELECT t0.image_collage_sources AS image_collage_sources_1, t0.id AS id_2, t0.max_participants AS max_participants_3, t0.name AS name_4, t0.url AS url_5, t0.code AS code_6, t0.phone AS phone_7, t0.description AS description_8, t0._text AS _text_9, t0.before_you_go AS before_you_go_10, t0.included_services AS included_services_11, t0.excluded_services AS excluded_services_12, t0.total_comment AS total_comment_13, t0.price_from AS price_from_14, t0.price_to AS price_to_15, t0.views AS views_16, t0._status AS _status_17, t0.price_indicative AS price_indicative_18, t0.indicative_price_from AS indicative_price_from_19, t0.active_web AS active_web_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.created_at_gmt AS created_at_gmt_23, t0.updated_at_gmt AS updated_at_gmt_24, t0.image_name AS image_name_25, t0.image_size AS image_size_26, t0.rating AS rating_27, t0.price_range AS price_range_28, t0.book_deadline AS book_deadline_29, t0.book_deadline_days AS book_deadline_days_30, t0.duration AS duration_31, t0.duration_days AS duration_days_32, t0.total_reviews AS total_reviews_33, t0.cancel_deadline AS cancel_deadline_34, t0.cancel_deadline_days AS cancel_deadline_days_35, t0.uuid4 AS uuid4_36, t0.slug AS slug_37, t0.creator_id AS creator_id_38, t0.manager_id AS manager_id_39, t0.organisation_id AS organisation_id_40, t0.currency_id AS currency_id_41, t0.departure_commune_id AS departure_commune_id_42, t0.end_commune_id AS end_commune_id_43, t0.guide_id AS guide_id_44, t0.unique_identifier AS unique_identifier_45 FROM t_tours t0 WHERE t0.id = ? AND ((t0.active_web = 1))
Parameters:
[
  31
]
19 0.66 ms
SELECT t0.image_collage_sources AS image_collage_sources_1, t0.id AS id_2, t0.max_participants AS max_participants_3, t0.name AS name_4, t0.url AS url_5, t0.code AS code_6, t0.phone AS phone_7, t0.description AS description_8, t0._text AS _text_9, t0.before_you_go AS before_you_go_10, t0.included_services AS included_services_11, t0.excluded_services AS excluded_services_12, t0.total_comment AS total_comment_13, t0.price_from AS price_from_14, t0.price_to AS price_to_15, t0.views AS views_16, t0._status AS _status_17, t0.price_indicative AS price_indicative_18, t0.indicative_price_from AS indicative_price_from_19, t0.active_web AS active_web_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.created_at_gmt AS created_at_gmt_23, t0.updated_at_gmt AS updated_at_gmt_24, t0.image_name AS image_name_25, t0.image_size AS image_size_26, t0.rating AS rating_27, t0.price_range AS price_range_28, t0.book_deadline AS book_deadline_29, t0.book_deadline_days AS book_deadline_days_30, t0.duration AS duration_31, t0.duration_days AS duration_days_32, t0.total_reviews AS total_reviews_33, t0.cancel_deadline AS cancel_deadline_34, t0.cancel_deadline_days AS cancel_deadline_days_35, t0.uuid4 AS uuid4_36, t0.slug AS slug_37, t0.creator_id AS creator_id_38, t0.manager_id AS manager_id_39, t0.organisation_id AS organisation_id_40, t0.currency_id AS currency_id_41, t0.departure_commune_id AS departure_commune_id_42, t0.end_commune_id AS end_commune_id_43, t0.guide_id AS guide_id_44, t0.unique_identifier AS unique_identifier_45 FROM t_tours t0 WHERE t0.id = ? AND ((t0.active_web = 1))
Parameters:
[
  30
]
20 0.76 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0._text AS _text_5, t0.before_you_go AS before_you_go_6, t0.total_comment AS total_comment_7, t0.address1 AS address1_8, t0.address2 AS address2_9, t0.phone AS phone_10, t0.email AS email_11, t0.longitude AS longitude_12, t0.latitude AS latitude_13, t0.website AS website_14, t0.facebook AS facebook_15, t0.twitter AS twitter_16, t0.instagram AS instagram_17, t0.pinterest AS pinterest_18, t0.price_from AS price_from_19, t0.price_to AS price_to_20, t0.views AS views_21, t0._status AS _status_22, t0.url AS url_23, t0.has_business_center AS has_business_center_24, t0._type AS _type_25, t0.zip_code AS zip_code_26, t0.has_fitness_center AS has_fitness_center_27, t0.has_internet_access AS has_internet_access_28, t0.has_pets AS has_pets_29, t0.has_pool AS has_pool_30, t0.has_parking AS has_parking_31, t0.has_restaurant AS has_restaurant_32, t0.has_room_service AS has_room_service_33, t0.has_breakfast AS has_breakfast_34, t0.has_babysitting AS has_babysitting_35, t0.has_wifi AS has_wifi_36, t0.has_kitchen AS has_kitchen_37, t0.has_jacuzzi AS has_jacuzzi_38, t0.pets_policy AS pets_policy_39, t0.arrival_time AS arrival_time_40, t0.departure_time AS departure_time_41, t0.early_checkin AS early_checkin_42, t0.late_checkin AS late_checkin_43, t0.children_policy AS children_policy_44, t0.tourist_tax AS tourist_tax_45, t0.stars AS stars_46, t0.total_type_rooms AS total_type_rooms_47, t0.capacity AS capacity_48, t0.price_indicative AS price_indicative_49, t0.indicative_price_from AS indicative_price_from_50, t0.active_web AS active_web_51, t0.created_at AS created_at_52, t0.updated_at AS updated_at_53, t0.created_at_gmt AS created_at_gmt_54, t0.updated_at_gmt AS updated_at_gmt_55, t0.image_name AS image_name_56, t0.image_size AS image_size_57, t0.rating AS rating_58, t0.price_range AS price_range_59, t0.book_deadline AS book_deadline_60, t0.book_deadline_days AS book_deadline_days_61, t0.cancel_deadline AS cancel_deadline_62, t0.cancel_deadline_days AS cancel_deadline_days_63, t0.total_reviews AS total_reviews_64, t0.uuid4 AS uuid4_65, t0.duration AS duration_66, t0.duration_days AS duration_days_67, t0.slug AS slug_68, t0.commune_id AS commune_id_69, t0.unique_identifier AS unique_identifier_70, t0.provider_id AS provider_id_71, t0.currency_id AS currency_id_72, t0.creator_id AS creator_id_73, t0.manager_id AS manager_id_74, t0.organisation_id AS organisation_id_75, t0.agoda_id AS agoda_id_76 FROM t_commune_hotels t0 WHERE t0.id = ? AND ((t0.active_web = 1))
Parameters:
[
  2279
]
21 0.64 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0._text AS _text_5, t0.before_you_go AS before_you_go_6, t0.total_comment AS total_comment_7, t0.address1 AS address1_8, t0.address2 AS address2_9, t0.phone AS phone_10, t0.email AS email_11, t0.longitude AS longitude_12, t0.latitude AS latitude_13, t0.website AS website_14, t0.facebook AS facebook_15, t0.twitter AS twitter_16, t0.instagram AS instagram_17, t0.pinterest AS pinterest_18, t0.price_from AS price_from_19, t0.price_to AS price_to_20, t0.views AS views_21, t0._status AS _status_22, t0.url AS url_23, t0.has_business_center AS has_business_center_24, t0._type AS _type_25, t0.zip_code AS zip_code_26, t0.has_fitness_center AS has_fitness_center_27, t0.has_internet_access AS has_internet_access_28, t0.has_pets AS has_pets_29, t0.has_pool AS has_pool_30, t0.has_parking AS has_parking_31, t0.has_restaurant AS has_restaurant_32, t0.has_room_service AS has_room_service_33, t0.has_breakfast AS has_breakfast_34, t0.has_babysitting AS has_babysitting_35, t0.has_wifi AS has_wifi_36, t0.has_kitchen AS has_kitchen_37, t0.has_jacuzzi AS has_jacuzzi_38, t0.pets_policy AS pets_policy_39, t0.arrival_time AS arrival_time_40, t0.departure_time AS departure_time_41, t0.early_checkin AS early_checkin_42, t0.late_checkin AS late_checkin_43, t0.children_policy AS children_policy_44, t0.tourist_tax AS tourist_tax_45, t0.stars AS stars_46, t0.total_type_rooms AS total_type_rooms_47, t0.capacity AS capacity_48, t0.price_indicative AS price_indicative_49, t0.indicative_price_from AS indicative_price_from_50, t0.active_web AS active_web_51, t0.created_at AS created_at_52, t0.updated_at AS updated_at_53, t0.created_at_gmt AS created_at_gmt_54, t0.updated_at_gmt AS updated_at_gmt_55, t0.image_name AS image_name_56, t0.image_size AS image_size_57, t0.rating AS rating_58, t0.price_range AS price_range_59, t0.book_deadline AS book_deadline_60, t0.book_deadline_days AS book_deadline_days_61, t0.cancel_deadline AS cancel_deadline_62, t0.cancel_deadline_days AS cancel_deadline_days_63, t0.total_reviews AS total_reviews_64, t0.uuid4 AS uuid4_65, t0.duration AS duration_66, t0.duration_days AS duration_days_67, t0.slug AS slug_68, t0.commune_id AS commune_id_69, t0.unique_identifier AS unique_identifier_70, t0.provider_id AS provider_id_71, t0.currency_id AS currency_id_72, t0.creator_id AS creator_id_73, t0.manager_id AS manager_id_74, t0.organisation_id AS organisation_id_75, t0.agoda_id AS agoda_id_76 FROM t_commune_hotels t0 WHERE t0.id = ? AND ((t0.active_web = 1))
Parameters:
[
  2278
]
22 0.64 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.codeGeo16 AS codeGeo16_3, t0.codeGeo12 AS codeGeo12_4, t0.codeGeo12_2 AS codeGeo12_2_5, t0.woeid AS woeid_6, t0._type AS _type_7, t0._type2 AS _type2_8, t0._type3 AS _type3_9, t0.url AS url_10, t0.slogan AS slogan_11, t0.path AS path_12, t0.logo_450x100 AS logo_450x100_13, t0.background_image AS background_image_14, t0.background_images AS background_images_15, t0.description AS description_16, t0.welcome AS welcome_17, t0.keywords AS keywords_18, t0.seo_description AS seo_description_19, t0._text AS _text_20, t0.address AS address_21, t0.mayor AS mayor_22, t0.website AS website_23, t0.facebook AS facebook_24, t0.twitter AS twitter_25, t0.instagram AS instagram_26, t0.pinterest AS pinterest_27, t0.zip_code AS zip_code_28, t0.altitude AS altitude_29, t0.superficie_old AS superficie_old_30, t0.superficie AS superficie_31, t0.latitude AS latitude_32, t0.northeast_latitude AS northeast_latitude_33, t0.southwest_latitude AS southwest_latitude_34, t0.longitude AS longitude_35, t0.northeast_longitude AS northeast_longitude_36, t0.southwest_longitude AS southwest_longitude_37, t0.fax AS fax_38, t0.tel AS tel_39, t0.google_tag AS google_tag_40, t0.density AS density_41, t0.codeWeather AS codeWeather_42, t0.total_comment AS total_comment_43, t0.tags AS tags_44, t0.views AS views_45, t0.flag_img AS flag_img_46, t0.thumb_225x130 AS thumb_225x130_47, t0.location_map_img AS location_map_img_48, t0.ean_done AS ean_done_49, t0.total_hotels AS total_hotels_50, t0.total_hotels_new AS total_hotels_new_51, t0.total_hospitals AS total_hospitals_52, t0.total_health_centers AS total_health_centers_53, t0.total_e_institutions AS total_e_institutions_54, t0.total_news AS total_news_55, t0.total_albums AS total_albums_56, t0.total_videos AS total_videos_57, t0.total_events AS total_events_58, t0.total_images AS total_images_59, t0.total_cafes AS total_cafes_60, t0.total_restaurants AS total_restaurants_61, t0.total_places AS total_places_62, t0.total_spots AS total_spots_63, t0.total_activities AS total_activities_64, t0.total_tours AS total_tours_65, t0.has_prayer_times AS has_prayer_times_66, t0.has_weather AS has_weather_67, t0.is_trending AS is_trending_68, t0.created_at AS created_at_69, t0.updated_at AS updated_at_70, t0.created_at_gmt AS created_at_gmt_71, t0.updated_at_gmt AS updated_at_gmt_72, t0.image_name AS image_name_73, t0.image_size AS image_size_74, t0.rating AS rating_75, t0.price_range AS price_range_76, t0.total_reviews AS total_reviews_77, t0.uuid4 AS uuid4_78, t0.slug AS slug_79, t0.province_id AS province_id_80, t0.unique_identifier AS unique_identifier_81, t0.provider_id AS provider_id_82 FROM t_communes t0 WHERE t0.id = ?
Parameters:
[
  963
]
23 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.before_you_go AS before_you_go_6, t0._text AS _text_7, t0.pets_policy AS pets_policy_8, t0.children_policy AS children_policy_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.created_at_gmt AS created_at_gmt_12, t0.updated_at_gmt AS updated_at_gmt_13, t0.lang AS lang_14, t0.hotel_id AS hotel_id_15 FROM t_commune_hotels_xl t0 WHERE t0.hotel_id = ? AND (((t0.hotel_id IS NULL OR EXISTS (SELECT 1 FROM t_commune_hotels wp WHERE wp.id = t0.hotel_id AND wp.active_web = 1))))
Parameters:
[
  2279
]
24 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.before_you_go AS before_you_go_6, t0._text AS _text_7, t0.pets_policy AS pets_policy_8, t0.children_policy AS children_policy_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.created_at_gmt AS created_at_gmt_12, t0.updated_at_gmt AS updated_at_gmt_13, t0.lang AS lang_14, t0.hotel_id AS hotel_id_15 FROM t_commune_hotels_xl t0 WHERE t0.hotel_id = ? AND (((t0.hotel_id IS NULL OR EXISTS (SELECT 1 FROM t_commune_hotels wp WHERE wp.id = t0.hotel_id AND wp.active_web = 1))))
Parameters:
[
  2278
]
25 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.description AS description_4, t0.code AS code_5, t0._text AS _text_6, t0.min_age AS min_age_7, t0.default_image AS default_image_8, t0.meeting_point_address AS meeting_point_address_9, t0.meeting_point_latitude AS meeting_point_latitude_10, t0.meeting_point_longitude AS meeting_point_longitude_11, t0.total_comment AS total_comment_12, t0.price_from AS price_from_13, t0.price_to AS price_to_14, t0.views AS views_15, t0._status AS _status_16, t0._type AS _type_17, t0.price_indicative AS price_indicative_18, t0.indicative_price_from AS indicative_price_from_19, t0.active_web AS active_web_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.created_at_gmt AS created_at_gmt_23, t0.updated_at_gmt AS updated_at_gmt_24, t0.image_name AS image_name_25, t0.image_size AS image_size_26, t0.book_deadline AS book_deadline_27, t0.book_deadline_days AS book_deadline_days_28, t0.rating AS rating_29, t0.price_range AS price_range_30, t0.cancel_deadline AS cancel_deadline_31, t0.cancel_deadline_days AS cancel_deadline_days_32, t0.duration AS duration_33, t0.duration_days AS duration_days_34, t0.total_reviews AS total_reviews_35, t0.uuid4 AS uuid4_36, t0.slug AS slug_37, t0.commune_id AS commune_id_38, t0.creator_id AS creator_id_39, t0.manager_id AS manager_id_40, t0.organisation_id AS organisation_id_41, t0.lang AS lang_42, t0.currency_id AS currency_id_43, t0.category_id AS category_id_44, t0.unique_identifier AS unique_identifier_45, t0.guide_id AS guide_id_46 FROM t_commune_activities t0 WHERE t0.id = ? AND ((t0.active_web = 1))
Parameters:
[
  6
]
26 0.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.description AS description_4, t0.code AS code_5, t0._text AS _text_6, t0.min_age AS min_age_7, t0.default_image AS default_image_8, t0.meeting_point_address AS meeting_point_address_9, t0.meeting_point_latitude AS meeting_point_latitude_10, t0.meeting_point_longitude AS meeting_point_longitude_11, t0.total_comment AS total_comment_12, t0.price_from AS price_from_13, t0.price_to AS price_to_14, t0.views AS views_15, t0._status AS _status_16, t0._type AS _type_17, t0.price_indicative AS price_indicative_18, t0.indicative_price_from AS indicative_price_from_19, t0.active_web AS active_web_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.created_at_gmt AS created_at_gmt_23, t0.updated_at_gmt AS updated_at_gmt_24, t0.image_name AS image_name_25, t0.image_size AS image_size_26, t0.book_deadline AS book_deadline_27, t0.book_deadline_days AS book_deadline_days_28, t0.rating AS rating_29, t0.price_range AS price_range_30, t0.cancel_deadline AS cancel_deadline_31, t0.cancel_deadline_days AS cancel_deadline_days_32, t0.duration AS duration_33, t0.duration_days AS duration_days_34, t0.total_reviews AS total_reviews_35, t0.uuid4 AS uuid4_36, t0.slug AS slug_37, t0.commune_id AS commune_id_38, t0.creator_id AS creator_id_39, t0.manager_id AS manager_id_40, t0.organisation_id AS organisation_id_41, t0.lang AS lang_42, t0.currency_id AS currency_id_43, t0.category_id AS category_id_44, t0.unique_identifier AS unique_identifier_45, t0.guide_id AS guide_id_46 FROM t_commune_activities t0 WHERE t0.id = ? AND ((t0.active_web = 1))
Parameters:
[
  5
]
27 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.description AS description_4, t0.code AS code_5, t0._text AS _text_6, t0.min_age AS min_age_7, t0.default_image AS default_image_8, t0.meeting_point_address AS meeting_point_address_9, t0.meeting_point_latitude AS meeting_point_latitude_10, t0.meeting_point_longitude AS meeting_point_longitude_11, t0.total_comment AS total_comment_12, t0.price_from AS price_from_13, t0.price_to AS price_to_14, t0.views AS views_15, t0._status AS _status_16, t0._type AS _type_17, t0.price_indicative AS price_indicative_18, t0.indicative_price_from AS indicative_price_from_19, t0.active_web AS active_web_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.created_at_gmt AS created_at_gmt_23, t0.updated_at_gmt AS updated_at_gmt_24, t0.image_name AS image_name_25, t0.image_size AS image_size_26, t0.book_deadline AS book_deadline_27, t0.book_deadline_days AS book_deadline_days_28, t0.rating AS rating_29, t0.price_range AS price_range_30, t0.cancel_deadline AS cancel_deadline_31, t0.cancel_deadline_days AS cancel_deadline_days_32, t0.duration AS duration_33, t0.duration_days AS duration_days_34, t0.total_reviews AS total_reviews_35, t0.uuid4 AS uuid4_36, t0.slug AS slug_37, t0.commune_id AS commune_id_38, t0.creator_id AS creator_id_39, t0.manager_id AS manager_id_40, t0.organisation_id AS organisation_id_41, t0.lang AS lang_42, t0.currency_id AS currency_id_43, t0.category_id AS category_id_44, t0.unique_identifier AS unique_identifier_45, t0.guide_id AS guide_id_46 FROM t_commune_activities t0 WHERE t0.id = ? AND ((t0.active_web = 1))
Parameters:
[
  2
]
28 0.62 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.codeGeo16 AS codeGeo16_3, t0.codeGeo12 AS codeGeo12_4, t0.codeGeo12_2 AS codeGeo12_2_5, t0.woeid AS woeid_6, t0._type AS _type_7, t0._type2 AS _type2_8, t0._type3 AS _type3_9, t0.url AS url_10, t0.slogan AS slogan_11, t0.path AS path_12, t0.logo_450x100 AS logo_450x100_13, t0.background_image AS background_image_14, t0.background_images AS background_images_15, t0.description AS description_16, t0.welcome AS welcome_17, t0.keywords AS keywords_18, t0.seo_description AS seo_description_19, t0._text AS _text_20, t0.address AS address_21, t0.mayor AS mayor_22, t0.website AS website_23, t0.facebook AS facebook_24, t0.twitter AS twitter_25, t0.instagram AS instagram_26, t0.pinterest AS pinterest_27, t0.zip_code AS zip_code_28, t0.altitude AS altitude_29, t0.superficie_old AS superficie_old_30, t0.superficie AS superficie_31, t0.latitude AS latitude_32, t0.northeast_latitude AS northeast_latitude_33, t0.southwest_latitude AS southwest_latitude_34, t0.longitude AS longitude_35, t0.northeast_longitude AS northeast_longitude_36, t0.southwest_longitude AS southwest_longitude_37, t0.fax AS fax_38, t0.tel AS tel_39, t0.google_tag AS google_tag_40, t0.density AS density_41, t0.codeWeather AS codeWeather_42, t0.total_comment AS total_comment_43, t0.tags AS tags_44, t0.views AS views_45, t0.flag_img AS flag_img_46, t0.thumb_225x130 AS thumb_225x130_47, t0.location_map_img AS location_map_img_48, t0.ean_done AS ean_done_49, t0.total_hotels AS total_hotels_50, t0.total_hotels_new AS total_hotels_new_51, t0.total_hospitals AS total_hospitals_52, t0.total_health_centers AS total_health_centers_53, t0.total_e_institutions AS total_e_institutions_54, t0.total_news AS total_news_55, t0.total_albums AS total_albums_56, t0.total_videos AS total_videos_57, t0.total_events AS total_events_58, t0.total_images AS total_images_59, t0.total_cafes AS total_cafes_60, t0.total_restaurants AS total_restaurants_61, t0.total_places AS total_places_62, t0.total_spots AS total_spots_63, t0.total_activities AS total_activities_64, t0.total_tours AS total_tours_65, t0.has_prayer_times AS has_prayer_times_66, t0.has_weather AS has_weather_67, t0.is_trending AS is_trending_68, t0.created_at AS created_at_69, t0.updated_at AS updated_at_70, t0.created_at_gmt AS created_at_gmt_71, t0.updated_at_gmt AS updated_at_gmt_72, t0.image_name AS image_name_73, t0.image_size AS image_size_74, t0.rating AS rating_75, t0.price_range AS price_range_76, t0.total_reviews AS total_reviews_77, t0.uuid4 AS uuid4_78, t0.slug AS slug_79, t0.province_id AS province_id_80, t0.unique_identifier AS unique_identifier_81, t0.provider_id AS provider_id_82 FROM t_communes t0 WHERE t0.id = ?
Parameters:
[
  13888
]
29 0.64 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.codeGeo16 AS codeGeo16_3, t0.codeGeo12 AS codeGeo12_4, t0.codeGeo12_2 AS codeGeo12_2_5, t0.woeid AS woeid_6, t0._type AS _type_7, t0._type2 AS _type2_8, t0._type3 AS _type3_9, t0.url AS url_10, t0.slogan AS slogan_11, t0.path AS path_12, t0.logo_450x100 AS logo_450x100_13, t0.background_image AS background_image_14, t0.background_images AS background_images_15, t0.description AS description_16, t0.welcome AS welcome_17, t0.keywords AS keywords_18, t0.seo_description AS seo_description_19, t0._text AS _text_20, t0.address AS address_21, t0.mayor AS mayor_22, t0.website AS website_23, t0.facebook AS facebook_24, t0.twitter AS twitter_25, t0.instagram AS instagram_26, t0.pinterest AS pinterest_27, t0.zip_code AS zip_code_28, t0.altitude AS altitude_29, t0.superficie_old AS superficie_old_30, t0.superficie AS superficie_31, t0.latitude AS latitude_32, t0.northeast_latitude AS northeast_latitude_33, t0.southwest_latitude AS southwest_latitude_34, t0.longitude AS longitude_35, t0.northeast_longitude AS northeast_longitude_36, t0.southwest_longitude AS southwest_longitude_37, t0.fax AS fax_38, t0.tel AS tel_39, t0.google_tag AS google_tag_40, t0.density AS density_41, t0.codeWeather AS codeWeather_42, t0.total_comment AS total_comment_43, t0.tags AS tags_44, t0.views AS views_45, t0.flag_img AS flag_img_46, t0.thumb_225x130 AS thumb_225x130_47, t0.location_map_img AS location_map_img_48, t0.ean_done AS ean_done_49, t0.total_hotels AS total_hotels_50, t0.total_hotels_new AS total_hotels_new_51, t0.total_hospitals AS total_hospitals_52, t0.total_health_centers AS total_health_centers_53, t0.total_e_institutions AS total_e_institutions_54, t0.total_news AS total_news_55, t0.total_albums AS total_albums_56, t0.total_videos AS total_videos_57, t0.total_events AS total_events_58, t0.total_images AS total_images_59, t0.total_cafes AS total_cafes_60, t0.total_restaurants AS total_restaurants_61, t0.total_places AS total_places_62, t0.total_spots AS total_spots_63, t0.total_activities AS total_activities_64, t0.total_tours AS total_tours_65, t0.has_prayer_times AS has_prayer_times_66, t0.has_weather AS has_weather_67, t0.is_trending AS is_trending_68, t0.created_at AS created_at_69, t0.updated_at AS updated_at_70, t0.created_at_gmt AS created_at_gmt_71, t0.updated_at_gmt AS updated_at_gmt_72, t0.image_name AS image_name_73, t0.image_size AS image_size_74, t0.rating AS rating_75, t0.price_range AS price_range_76, t0.total_reviews AS total_reviews_77, t0.uuid4 AS uuid4_78, t0.slug AS slug_79, t0.province_id AS province_id_80, t0.unique_identifier AS unique_identifier_81, t0.provider_id AS provider_id_82 FROM t_communes t0 WHERE t0.id = ?
Parameters:
[
  13897
]
30 0.62 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.codeGeo16 AS codeGeo16_3, t0.codeGeo12 AS codeGeo12_4, t0.codeGeo12_2 AS codeGeo12_2_5, t0.woeid AS woeid_6, t0._type AS _type_7, t0._type2 AS _type2_8, t0._type3 AS _type3_9, t0.url AS url_10, t0.slogan AS slogan_11, t0.path AS path_12, t0.logo_450x100 AS logo_450x100_13, t0.background_image AS background_image_14, t0.background_images AS background_images_15, t0.description AS description_16, t0.welcome AS welcome_17, t0.keywords AS keywords_18, t0.seo_description AS seo_description_19, t0._text AS _text_20, t0.address AS address_21, t0.mayor AS mayor_22, t0.website AS website_23, t0.facebook AS facebook_24, t0.twitter AS twitter_25, t0.instagram AS instagram_26, t0.pinterest AS pinterest_27, t0.zip_code AS zip_code_28, t0.altitude AS altitude_29, t0.superficie_old AS superficie_old_30, t0.superficie AS superficie_31, t0.latitude AS latitude_32, t0.northeast_latitude AS northeast_latitude_33, t0.southwest_latitude AS southwest_latitude_34, t0.longitude AS longitude_35, t0.northeast_longitude AS northeast_longitude_36, t0.southwest_longitude AS southwest_longitude_37, t0.fax AS fax_38, t0.tel AS tel_39, t0.google_tag AS google_tag_40, t0.density AS density_41, t0.codeWeather AS codeWeather_42, t0.total_comment AS total_comment_43, t0.tags AS tags_44, t0.views AS views_45, t0.flag_img AS flag_img_46, t0.thumb_225x130 AS thumb_225x130_47, t0.location_map_img AS location_map_img_48, t0.ean_done AS ean_done_49, t0.total_hotels AS total_hotels_50, t0.total_hotels_new AS total_hotels_new_51, t0.total_hospitals AS total_hospitals_52, t0.total_health_centers AS total_health_centers_53, t0.total_e_institutions AS total_e_institutions_54, t0.total_news AS total_news_55, t0.total_albums AS total_albums_56, t0.total_videos AS total_videos_57, t0.total_events AS total_events_58, t0.total_images AS total_images_59, t0.total_cafes AS total_cafes_60, t0.total_restaurants AS total_restaurants_61, t0.total_places AS total_places_62, t0.total_spots AS total_spots_63, t0.total_activities AS total_activities_64, t0.total_tours AS total_tours_65, t0.has_prayer_times AS has_prayer_times_66, t0.has_weather AS has_weather_67, t0.is_trending AS is_trending_68, t0.created_at AS created_at_69, t0.updated_at AS updated_at_70, t0.created_at_gmt AS created_at_gmt_71, t0.updated_at_gmt AS updated_at_gmt_72, t0.image_name AS image_name_73, t0.image_size AS image_size_74, t0.rating AS rating_75, t0.price_range AS price_range_76, t0.total_reviews AS total_reviews_77, t0.uuid4 AS uuid4_78, t0.slug AS slug_79, t0.province_id AS province_id_80, t0.unique_identifier AS unique_identifier_81, t0.provider_id AS provider_id_82 FROM t_communes t0 WHERE t0.id = ?
Parameters:
[
  187
]
31 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.image_file AS image_file_4, t0.description AS description_5, t0.tags AS tags_6, t0.total_comment AS total_comment_7, t0.views AS views_8, t0._status AS _status_9, t0.done AS done_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.created_at_gmt AS created_at_gmt_13, t0.updated_at_gmt AS updated_at_gmt_14, t0.image_name AS image_name_15, t0.image_size AS image_size_16, t0.image_credit_name AS image_credit_name_17, t0.image_credit_url AS image_credit_url_18, t0.image_source_url AS image_source_url_19, t0.slug AS slug_20, t0.uuid4 AS uuid4_21, t0.unique_identifier AS unique_identifier_22 FROM t_blog_sections t0 WHERE t0.id = ?
Parameters:
[
  1
]
32 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.image_file AS image_file_4, t0.description AS description_5, t0.tags AS tags_6, t0.total_comment AS total_comment_7, t0.views AS views_8, t0._status AS _status_9, t0.done AS done_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.created_at_gmt AS created_at_gmt_13, t0.updated_at_gmt AS updated_at_gmt_14, t0.image_name AS image_name_15, t0.image_size AS image_size_16, t0.image_credit_name AS image_credit_name_17, t0.image_credit_url AS image_credit_url_18, t0.image_source_url AS image_source_url_19, t0.slug AS slug_20, t0.uuid4 AS uuid4_21, t0.unique_identifier AS unique_identifier_22 FROM t_blog_sections t0 WHERE t0.id = ?
Parameters:
[
  3
]
33 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.image_file AS image_file_4, t0.description AS description_5, t0.tags AS tags_6, t0.total_comment AS total_comment_7, t0.views AS views_8, t0._status AS _status_9, t0.done AS done_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.created_at_gmt AS created_at_gmt_13, t0.updated_at_gmt AS updated_at_gmt_14, t0.image_name AS image_name_15, t0.image_size AS image_size_16, t0.image_credit_name AS image_credit_name_17, t0.image_credit_url AS image_credit_url_18, t0.image_source_url AS image_source_url_19, t0.slug AS slug_20, t0.uuid4 AS uuid4_21, t0.unique_identifier AS unique_identifier_22 FROM t_blog_sections t0 WHERE t0.id = ?
Parameters:
[
  5
]
34 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.image_file AS image_file_4, t0.description AS description_5, t0.tags AS tags_6, t0.total_comment AS total_comment_7, t0.views AS views_8, t0._status AS _status_9, t0.done AS done_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.created_at_gmt AS created_at_gmt_13, t0.updated_at_gmt AS updated_at_gmt_14, t0.image_name AS image_name_15, t0.image_size AS image_size_16, t0.image_credit_name AS image_credit_name_17, t0.image_credit_url AS image_credit_url_18, t0.image_source_url AS image_source_url_19, t0.slug AS slug_20, t0.uuid4 AS uuid4_21, t0.unique_identifier AS unique_identifier_22 FROM t_blog_sections t0 WHERE t0.id = ?
Parameters:
[
  6
]
35 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.image_file AS image_file_4, t0.description AS description_5, t0.tags AS tags_6, t0.total_comment AS total_comment_7, t0.views AS views_8, t0._status AS _status_9, t0.done AS done_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.created_at_gmt AS created_at_gmt_13, t0.updated_at_gmt AS updated_at_gmt_14, t0.image_name AS image_name_15, t0.image_size AS image_size_16, t0.image_credit_name AS image_credit_name_17, t0.image_credit_url AS image_credit_url_18, t0.image_source_url AS image_source_url_19, t0.slug AS slug_20, t0.uuid4 AS uuid4_21, t0.unique_identifier AS unique_identifier_22 FROM t_blog_sections t0 WHERE t0.id = ?
Parameters:
[
  7
]
36 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.image_file AS image_file_4, t0.description AS description_5, t0.tags AS tags_6, t0.total_comment AS total_comment_7, t0.views AS views_8, t0._status AS _status_9, t0.done AS done_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.created_at_gmt AS created_at_gmt_13, t0.updated_at_gmt AS updated_at_gmt_14, t0.image_name AS image_name_15, t0.image_size AS image_size_16, t0.image_credit_name AS image_credit_name_17, t0.image_credit_url AS image_credit_url_18, t0.image_source_url AS image_source_url_19, t0.slug AS slug_20, t0.uuid4 AS uuid4_21, t0.unique_identifier AS unique_identifier_22 FROM t_blog_sections t0 WHERE t0.id = ?
Parameters:
[
  8
]
37 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.image_file AS image_file_4, t0.description AS description_5, t0.tags AS tags_6, t0.total_comment AS total_comment_7, t0.views AS views_8, t0._status AS _status_9, t0.done AS done_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.created_at_gmt AS created_at_gmt_13, t0.updated_at_gmt AS updated_at_gmt_14, t0.image_name AS image_name_15, t0.image_size AS image_size_16, t0.image_credit_name AS image_credit_name_17, t0.image_credit_url AS image_credit_url_18, t0.image_source_url AS image_source_url_19, t0.slug AS slug_20, t0.uuid4 AS uuid4_21, t0.unique_identifier AS unique_identifier_22 FROM t_blog_sections t0 WHERE t0.id = ?
Parameters:
[
  9
]
38 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.image_file AS image_file_4, t0.description AS description_5, t0.tags AS tags_6, t0.total_comment AS total_comment_7, t0.views AS views_8, t0._status AS _status_9, t0.done AS done_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.created_at_gmt AS created_at_gmt_13, t0.updated_at_gmt AS updated_at_gmt_14, t0.image_name AS image_name_15, t0.image_size AS image_size_16, t0.image_credit_name AS image_credit_name_17, t0.image_credit_url AS image_credit_url_18, t0.image_source_url AS image_source_url_19, t0.slug AS slug_20, t0.uuid4 AS uuid4_21, t0.unique_identifier AS unique_identifier_22 FROM t_blog_sections t0 WHERE t0.id = ?
Parameters:
[
  10
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\UniqueIdentifier 33
App\Entity\Region 12
App\Entity\Blog\Section 8
App\Entity\Commune 6
App\Entity\Province 5
App\Entity\Commune\Activity 3
App\Entity\DataProvider 2
App\Entity\Tour 2
App\Entity\Commune\Hotel 2
App\Entity\Agoda\Hotel 2
App\Entity\Place\Category 1
App\Entity\User 1
App\Entity\Annex\Currency 1
App\Entity\Annex\Language 1
App\Entity\Commune\Activity\Category 1
App\Entity\Organisation 1

Entities Mapping

Class Mapping errors
App\Entity\Commune
  • The mappings App\Entity\Commune#demographies and App\Entity\Commune\Demography#commune are inconsistent with each other.
  • The mappings App\Entity\Commune#weatherOnecalls and App\Entity\Commune\Weather\Onecall#commune are inconsistent with each other.
App\Entity\Province No errors.
App\Entity\UniqueIdentifier No errors.
App\Entity\DataProvider No errors.
App\Entity\Tour No errors.
App\Entity\Commune\Demography
  • The association App\Entity\Commune\Demography#commune refers to the inverse side field App\Entity\Commune#demographics which does not exist.
App\Entity\Commune\PrayerTime No errors.
App\Entity\Commune\Article No errors.
App\Entity\Commune\Distance No errors.
App\Entity\Commune\Xl No errors.
App\Entity\Commune\Name No errors.
App\Entity\Commune\Image\Album No errors.
App\Entity\Commune\Video No errors.
App\Entity\Hospital No errors.
App\Entity\Education\Institution No errors.
App\Entity\HealthCenter No errors.
App\Entity\Commune\Event\Group No errors.
App\Entity\Commune\Place No errors.
App\Entity\Commune\Spot No errors.
App\Entity\Commune\Hotel
  • The field App\Entity\Commune\Hotel#detailExtraServices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Commune\Hotel\ExtraService#hotel does not contain the required 'inversedBy: "detailExtraServices"' attribute.
App\Entity\Commune\Activity No errors.
App\Entity\Commune\Weather No errors.
App\Entity\Commune\Weather\Onecall No errors.
App\Entity\Scraper\Article
  • The mappings App\Entity\Scraper\Article#categories and App\Entity\Scraper\Article\Category#articles are inconsistent with each other.
  • If association App\Entity\Scraper\Article#mainCategory is many-to-one, then the inversed side App\Entity\Scraper\Article\Category#articles has to be one-to-many.
  • If association App\Entity\Scraper\Article#call is many-to-one, then the inversed side App\Entity\Scraper\Call#articles has to be one-to-many.
App\Entity\Place\Category No errors.
App\Entity\Place\Category\Xl No errors.
App\Entity\Region No errors.
App\Entity\Province\Demography No errors.
App\Entity\Province\Xl No errors.
App\Entity\Province\Article No errors.
App\Entity\Region\Demography No errors.
App\Entity\Region\Xl No errors.
App\Entity\Region\Article No errors.
App\Entity\User No errors.
App\Entity\Organisation No errors.
App\Entity\Annex\Currency No errors.
App\Entity\Guide No errors.
App\Entity\Tour\Xl No errors.
App\Entity\Tour\Program No errors.
App\Entity\Tag No errors.
App\Entity\Tour\Availability No errors.
App\Entity\Tour\TDate No errors.
App\Entity\Tour\Image No errors.
App\Entity\Tour\Flight No errors.
App\Entity\TravelTheme No errors.
App\Entity\Agoda\Hotel No errors.
App\Entity\Commune\Hotel\Xl No errors.
App\Entity\Hotel\Amenity No errors.
App\Entity\ExtraService No errors.
App\Entity\Commune\Hotel\ExtraService No errors.
App\Entity\Commune\Hotel\Image No errors.
App\Entity\Commune\Hotel\Room No errors.
App\Entity\Commune\Hotel\Map No errors.
App\Entity\Annex\Language No errors.
App\Entity\Commune\Activity\Category No errors.
App\Entity\Commune\Activity\Xl No errors.
App\Entity\Commune\Activity\Requirement No errors.
App\Entity\Commune\Activity\Service No errors.
App\Entity\Commune\Activity\Feature No errors.
App\Entity\Commune\Activity\Availability No errors.
App\Entity\Commune\Activity\ADate No errors.
App\Entity\Commune\Activity\Image No errors.
App\Entity\Blog\Section No errors.
App\Entity\Blog\Category No errors.
App\Entity\Blog\Section\Xl No errors.