Query Metrics
37
Database Queries
12
Different statements
12.90 ms
Query time
4
Invalid entities
107
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.24 ms |
SELECT revision FROM t_product_publication_state WHERE id = 1
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 0.60 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:
[
"sidi-azzouz"
]
|
||||||||||||||||||||||||||||||
| 3 | 0.46 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:
[
30030
]
|
||||||||||||||||||||||||||||||
| 4 | 0.44 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.welcome AS welcome_4, t0.keywords AS keywords_5, t0.seo_description AS seo_description_6, t0.address AS address_7, t0._text AS _text_8, t0.tags AS tags_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.commune_id AS commune_id_14, t0.lang AS lang_15 FROM t_communes_xl t0 WHERE t0.commune_id = ?
Parameters:
[
1250
]
|
||||||||||||||||||||||||||||||
| 5 | 0.41 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.welcome AS welcome_4, t0.seo_description AS seo_description_5, t0.address AS address_6, t0._text AS _text_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_at_gmt AS created_at_gmt_10, t0.updated_at_gmt AS updated_at_gmt_11, t0.lang AS lang_12, t0.province_id AS province_id_13 FROM t_provinces_xl t0 WHERE t0.province_id = ?
Parameters:
[
30030
]
|
||||||||||||||||||||||||||||||
| 6 | 0.35 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
]
|
||||||||||||||||||||||||||||||
| 7 | 0.32 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.22 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.25 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.29 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
]
|
||||||||||||||||||||||||||||||
| 11 | 0.25 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
]
|
||||||||||||||||||||||||||||||
| 12 | 0.25 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
]
|
||||||||||||||||||||||||||||||
| 13 | 0.25 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
]
|
||||||||||||||||||||||||||||||
| 14 | 0.23 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
]
|
||||||||||||||||||||||||||||||
| 15 | 0.23 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.24 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.26 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.29 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.29 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.35 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.56 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.41 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.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:
[
6
]
|
||||||||||||||||||||||||||||||
| 24 | 0.49 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
]
|
||||||||||||||||||||||||||||||
| 25 | 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
]
|
||||||||||||||||||||||||||||||
| 26 | 0.53 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
]
|
||||||||||||||||||||||||||||||
| 27 | 0.55 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
]
|
||||||||||||||||||||||||||||||
| 28 | 0.60 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
]
|
||||||||||||||||||||||||||||||
| 29 | 0.36 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
]
|
||||||||||||||||||||||||||||||
| 30 | 0.26 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
]
|
||||||||||||||||||||||||||||||
| 31 | 0.25 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
]
|
||||||||||||||||||||||||||||||
| 32 | 0.25 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
]
|
||||||||||||||||||||||||||||||
| 33 | 0.25 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
]
|
||||||||||||||||||||||||||||||
| 34 | 0.24 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
]
|
||||||||||||||||||||||||||||||
| 35 | 0.24 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
]
|
||||||||||||||||||||||||||||||
| 36 | 0.25 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
]
|
||||||||||||||||||||||||||||||
| 37 | 0.47 ms |
SELECT t0.id AS id_1, t0._year AS _year_2, t0.population AS population_3, t0.urbain_population AS urbain_population_4, t0.rural_population AS rural_population_5, t0.foreigners AS foreigners_6, t0.urbain_foreigners AS urbain_foreigners_7, t0.rural_foreigners AS rural_foreigners_8, t0.moroccan AS moroccan_9, t0.urbain_moroccan AS urbain_moroccan_10, t0.rural_moroccan AS rural_moroccan_11, t0.households AS households_12, t0.urbain_households AS urbain_households_13, t0.rural_households AS rural_households_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.created_at_gmt AS created_at_gmt_17, t0.updated_at_gmt AS updated_at_gmt_18, t0.commune_id AS commune_id_19 FROM t_commune_demography t0 WHERE t0.commune_id = ? ORDER BY t0._year DESC
Parameters:
[
1250
]
|
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\Commune\Xl | 8 |
| App\Entity\Annex\Language | 8 |
| App\Entity\Province\Xl | 8 |
| App\Entity\Blog\Section | 8 |
| App\Entity\Commune | 6 |
| App\Entity\Province | 5 |
| App\Entity\Commune\Demography | 4 |
| 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\User | 1 |
| App\Entity\Annex\Currency | 1 |
| App\Entity\Commune\Activity\Category | 1 |
| App\Entity\Organisation | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Commune |
|
| App\Entity\Province | No errors. |
| App\Entity\UniqueIdentifier | No errors. |
| App\Entity\DataProvider | No errors. |
| App\Entity\Tour | No errors. |
| App\Entity\Commune\Demography |
|
| 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 |
|
| App\Entity\Commune\Activity | No errors. |
| App\Entity\Commune\Weather | No errors. |
| App\Entity\Commune\Weather\Onecall | No errors. |
| App\Entity\Scraper\Article |
|
| 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\Annex\Language | 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\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. |