GET http://api-dev.tripncity.com/front/country/8/france

Query Metrics

16 Database Queries
5 Different statements
25.08 ms Query time
0 Invalid entities
397 Managed entities

Queries

Group similar statements

# Time Info
1 2.42 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.flag AS flag_6, t0.status AS status_7, t0.order_number AS order_number_8, t0.iso_code AS iso_code_9, t0.media_id AS media_id_10 FROM country t0 WHERE t0.id = ?
Parameters:
[
  "8"
]
2 1.00 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.status AS status_6, t0.group_name AS group_name_7 FROM place_category t0
Parameters:
[]
3 0.74 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.icon AS icon_4, t0.status AS status_5 FROM travel_preference t0
Parameters:
[]
4 1.78 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.status AS status_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.country_id AS country_id_9, t0.media_id AS media_id_10 FROM city t0 WHERE t0.country_id = ?
Parameters:
[
  8
]
5 5.05 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
Parameters:
[
  223
]
6 1.65 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
Parameters:
[
  224
]
7 1.40 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
Parameters:
[
  225
]
8 1.23 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
Parameters:
[
  226
]
9 1.21 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
Parameters:
[
  227
]
10 1.20 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
Parameters:
[
  228
]
11 1.36 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
Parameters:
[
  229
]
12 1.29 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
Parameters:
[
  230
]
13 1.35 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
Parameters:
[
  231
]
14 1.13 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
Parameters:
[
  232
]
15 1.23 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
Parameters:
[
  233
]
16 1.03 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
Parameters:
[
  234
]

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\Place 185
App\Entity\PlaceCategory 166
App\Entity\Media 30
App\Entity\City 12
App\Entity\PriceRange 3
App\Entity\Country 1

Entities Mapping