Symfony Profiler

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.status = ?
ORDER BY
  t0.order_number ASC

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.status = 1 ORDER BY t0.order_number ASC;

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.description AS description_7
FROM
  trip_category t0

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.description AS description_7 FROM trip_category t0;

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

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;

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 = ?

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 = 6;

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 = ?

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 = 3;

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 = ?

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 = 5;

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 = ?

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 = 1;

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 = ?

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 = 8;

SELECT
  t0.id AS id_1,
  t0.caption AS caption_2,
  t0.file_name AS file_name_3,
  t4.created_at AS created_at_5,
  t4.updated_at AS updated_at_6,
  t4.deleted_at AS deleted_at_7,
  t4.id AS id_8,
  t4.name AS name_9,
  t4.cid AS cid_10,
  t4.description AS description_11,
  t4.complet_address AS complet_address_12,
  t4.uri_image AS uri_image_13,
  t4.lat AS lat_14,
  t4.lng AS lng_15,
  t4.geohash AS geohash_16,
  t4.rating AS rating_17,
  t4.votes_count AS votes_count_18,
  t4.rating_count1 AS rating_count1_19,
  t4.rating_count2 AS rating_count2_20,
  t4.rating_count3 AS rating_count3_21,
  t4.rating_count4 AS rating_count4_22,
  t4.rating_count5 AS rating_count5_23,
  t4.status AS status_24,
  t4.score AS score_25,
  t4.recent AS recent_26,
  t4.opening_time AS opening_time_27,
  t4.closing_time AS closing_time_28,
  t4.popularity_time0001 AS popularity_time0001_29,
  t4.popularity_time0102 AS popularity_time0102_30,
  t4.popularity_time0203 AS popularity_time0203_31,
  t4.popularity_time0304 AS popularity_time0304_32,
  t4.popularity_time0405 AS popularity_time0405_33,
  t4.popularity_time0506 AS popularity_time0506_34,
  t4.popularity_time0607 AS popularity_time0607_35,
  t4.popularity_time0708 AS popularity_time0708_36,
  t4.popularity_time0809 AS popularity_time0809_37,
  t4.popularity_time0910 AS popularity_time0910_38,
  t4.popularity_time1011 AS popularity_time1011_39,
  t4.popularity_time1112 AS popularity_time1112_40,
  t4.popularity_time1213 AS popularity_time1213_41,
  t4.popularity_time1314 AS popularity_time1314_42,
  t4.popularity_time1415 AS popularity_time1415_43,
  t4.popularity_time1516 AS popularity_time1516_44,
  t4.popularity_time1617 AS popularity_time1617_45,
  t4.popularity_time1718 AS popularity_time1718_46,
  t4.popularity_time1819 AS popularity_time1819_47,
  t4.popularity_time1920 AS popularity_time1920_48,
  t4.popularity_time2021 AS popularity_time2021_49,
  t4.popularity_time2122 AS popularity_time2122_50,
  t4.popularity_time2223 AS popularity_time2223_51,
  t4.popularity_time2300 AS popularity_time2300_52,
  t4.you_tube_id AS you_tube_id_53,
  t4.city_id AS city_id_54,
  t4.media_id AS media_id_55,
  t4.price_range_id AS price_range_id_56,
  t0.gallery_place_id AS gallery_place_id_57
FROM
  media t0
  LEFT JOIN place t4 ON t4.media_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.file_name AS file_name_3, t4.created_at AS created_at_5, t4.updated_at AS updated_at_6, t4.deleted_at AS deleted_at_7, t4.id AS id_8, t4.name AS name_9, t4.cid AS cid_10, t4.description AS description_11, t4.complet_address AS complet_address_12, t4.uri_image AS uri_image_13, t4.lat AS lat_14, t4.lng AS lng_15, t4.geohash AS geohash_16, t4.rating AS rating_17, t4.votes_count AS votes_count_18, t4.rating_count1 AS rating_count1_19, t4.rating_count2 AS rating_count2_20, t4.rating_count3 AS rating_count3_21, t4.rating_count4 AS rating_count4_22, t4.rating_count5 AS rating_count5_23, t4.status AS status_24, t4.score AS score_25, t4.recent AS recent_26, t4.opening_time AS opening_time_27, t4.closing_time AS closing_time_28, t4.popularity_time0001 AS popularity_time0001_29, t4.popularity_time0102 AS popularity_time0102_30, t4.popularity_time0203 AS popularity_time0203_31, t4.popularity_time0304 AS popularity_time0304_32, t4.popularity_time0405 AS popularity_time0405_33, t4.popularity_time0506 AS popularity_time0506_34, t4.popularity_time0607 AS popularity_time0607_35, t4.popularity_time0708 AS popularity_time0708_36, t4.popularity_time0809 AS popularity_time0809_37, t4.popularity_time0910 AS popularity_time0910_38, t4.popularity_time1011 AS popularity_time1011_39, t4.popularity_time1112 AS popularity_time1112_40, t4.popularity_time1213 AS popularity_time1213_41, t4.popularity_time1314 AS popularity_time1314_42, t4.popularity_time1415 AS popularity_time1415_43, t4.popularity_time1516 AS popularity_time1516_44, t4.popularity_time1617 AS popularity_time1617_45, t4.popularity_time1718 AS popularity_time1718_46, t4.popularity_time1819 AS popularity_time1819_47, t4.popularity_time1920 AS popularity_time1920_48, t4.popularity_time2021 AS popularity_time2021_49, t4.popularity_time2122 AS popularity_time2122_50, t4.popularity_time2223 AS popularity_time2223_51, t4.popularity_time2300 AS popularity_time2300_52, t4.you_tube_id AS you_tube_id_53, t4.city_id AS city_id_54, t4.media_id AS media_id_55, t4.price_range_id AS price_range_id_56, t0.gallery_place_id AS gallery_place_id_57 FROM media t0 LEFT JOIN place t4 ON t4.media_id = t0.id WHERE t0.id = 2699;

SELECT
  t0.id AS id_1,
  t0.caption AS caption_2,
  t0.file_name AS file_name_3,
  t4.created_at AS created_at_5,
  t4.updated_at AS updated_at_6,
  t4.deleted_at AS deleted_at_7,
  t4.id AS id_8,
  t4.name AS name_9,
  t4.cid AS cid_10,
  t4.description AS description_11,
  t4.complet_address AS complet_address_12,
  t4.uri_image AS uri_image_13,
  t4.lat AS lat_14,
  t4.lng AS lng_15,
  t4.geohash AS geohash_16,
  t4.rating AS rating_17,
  t4.votes_count AS votes_count_18,
  t4.rating_count1 AS rating_count1_19,
  t4.rating_count2 AS rating_count2_20,
  t4.rating_count3 AS rating_count3_21,
  t4.rating_count4 AS rating_count4_22,
  t4.rating_count5 AS rating_count5_23,
  t4.status AS status_24,
  t4.score AS score_25,
  t4.recent AS recent_26,
  t4.opening_time AS opening_time_27,
  t4.closing_time AS closing_time_28,
  t4.popularity_time0001 AS popularity_time0001_29,
  t4.popularity_time0102 AS popularity_time0102_30,
  t4.popularity_time0203 AS popularity_time0203_31,
  t4.popularity_time0304 AS popularity_time0304_32,
  t4.popularity_time0405 AS popularity_time0405_33,
  t4.popularity_time0506 AS popularity_time0506_34,
  t4.popularity_time0607 AS popularity_time0607_35,
  t4.popularity_time0708 AS popularity_time0708_36,
  t4.popularity_time0809 AS popularity_time0809_37,
  t4.popularity_time0910 AS popularity_time0910_38,
  t4.popularity_time1011 AS popularity_time1011_39,
  t4.popularity_time1112 AS popularity_time1112_40,
  t4.popularity_time1213 AS popularity_time1213_41,
  t4.popularity_time1314 AS popularity_time1314_42,
  t4.popularity_time1415 AS popularity_time1415_43,
  t4.popularity_time1516 AS popularity_time1516_44,
  t4.popularity_time1617 AS popularity_time1617_45,
  t4.popularity_time1718 AS popularity_time1718_46,
  t4.popularity_time1819 AS popularity_time1819_47,
  t4.popularity_time1920 AS popularity_time1920_48,
  t4.popularity_time2021 AS popularity_time2021_49,
  t4.popularity_time2122 AS popularity_time2122_50,
  t4.popularity_time2223 AS popularity_time2223_51,
  t4.popularity_time2300 AS popularity_time2300_52,
  t4.you_tube_id AS you_tube_id_53,
  t4.city_id AS city_id_54,
  t4.media_id AS media_id_55,
  t4.price_range_id AS price_range_id_56,
  t0.gallery_place_id AS gallery_place_id_57
FROM
  media t0
  LEFT JOIN place t4 ON t4.media_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.file_name AS file_name_3, t4.created_at AS created_at_5, t4.updated_at AS updated_at_6, t4.deleted_at AS deleted_at_7, t4.id AS id_8, t4.name AS name_9, t4.cid AS cid_10, t4.description AS description_11, t4.complet_address AS complet_address_12, t4.uri_image AS uri_image_13, t4.lat AS lat_14, t4.lng AS lng_15, t4.geohash AS geohash_16, t4.rating AS rating_17, t4.votes_count AS votes_count_18, t4.rating_count1 AS rating_count1_19, t4.rating_count2 AS rating_count2_20, t4.rating_count3 AS rating_count3_21, t4.rating_count4 AS rating_count4_22, t4.rating_count5 AS rating_count5_23, t4.status AS status_24, t4.score AS score_25, t4.recent AS recent_26, t4.opening_time AS opening_time_27, t4.closing_time AS closing_time_28, t4.popularity_time0001 AS popularity_time0001_29, t4.popularity_time0102 AS popularity_time0102_30, t4.popularity_time0203 AS popularity_time0203_31, t4.popularity_time0304 AS popularity_time0304_32, t4.popularity_time0405 AS popularity_time0405_33, t4.popularity_time0506 AS popularity_time0506_34, t4.popularity_time0607 AS popularity_time0607_35, t4.popularity_time0708 AS popularity_time0708_36, t4.popularity_time0809 AS popularity_time0809_37, t4.popularity_time0910 AS popularity_time0910_38, t4.popularity_time1011 AS popularity_time1011_39, t4.popularity_time1112 AS popularity_time1112_40, t4.popularity_time1213 AS popularity_time1213_41, t4.popularity_time1314 AS popularity_time1314_42, t4.popularity_time1415 AS popularity_time1415_43, t4.popularity_time1516 AS popularity_time1516_44, t4.popularity_time1617 AS popularity_time1617_45, t4.popularity_time1718 AS popularity_time1718_46, t4.popularity_time1819 AS popularity_time1819_47, t4.popularity_time1920 AS popularity_time1920_48, t4.popularity_time2021 AS popularity_time2021_49, t4.popularity_time2122 AS popularity_time2122_50, t4.popularity_time2223 AS popularity_time2223_51, t4.popularity_time2300 AS popularity_time2300_52, t4.you_tube_id AS you_tube_id_53, t4.city_id AS city_id_54, t4.media_id AS media_id_55, t4.price_range_id AS price_range_id_56, t0.gallery_place_id AS gallery_place_id_57 FROM media t0 LEFT JOIN place t4 ON t4.media_id = t0.id WHERE t0.id = 2702;

SELECT
  t0.id AS id_1,
  t0.caption AS caption_2,
  t0.file_name AS file_name_3,
  t4.created_at AS created_at_5,
  t4.updated_at AS updated_at_6,
  t4.deleted_at AS deleted_at_7,
  t4.id AS id_8,
  t4.name AS name_9,
  t4.cid AS cid_10,
  t4.description AS description_11,
  t4.complet_address AS complet_address_12,
  t4.uri_image AS uri_image_13,
  t4.lat AS lat_14,
  t4.lng AS lng_15,
  t4.geohash AS geohash_16,
  t4.rating AS rating_17,
  t4.votes_count AS votes_count_18,
  t4.rating_count1 AS rating_count1_19,
  t4.rating_count2 AS rating_count2_20,
  t4.rating_count3 AS rating_count3_21,
  t4.rating_count4 AS rating_count4_22,
  t4.rating_count5 AS rating_count5_23,
  t4.status AS status_24,
  t4.score AS score_25,
  t4.recent AS recent_26,
  t4.opening_time AS opening_time_27,
  t4.closing_time AS closing_time_28,
  t4.popularity_time0001 AS popularity_time0001_29,
  t4.popularity_time0102 AS popularity_time0102_30,
  t4.popularity_time0203 AS popularity_time0203_31,
  t4.popularity_time0304 AS popularity_time0304_32,
  t4.popularity_time0405 AS popularity_time0405_33,
  t4.popularity_time0506 AS popularity_time0506_34,
  t4.popularity_time0607 AS popularity_time0607_35,
  t4.popularity_time0708 AS popularity_time0708_36,
  t4.popularity_time0809 AS popularity_time0809_37,
  t4.popularity_time0910 AS popularity_time0910_38,
  t4.popularity_time1011 AS popularity_time1011_39,
  t4.popularity_time1112 AS popularity_time1112_40,
  t4.popularity_time1213 AS popularity_time1213_41,
  t4.popularity_time1314 AS popularity_time1314_42,
  t4.popularity_time1415 AS popularity_time1415_43,
  t4.popularity_time1516 AS popularity_time1516_44,
  t4.popularity_time1617 AS popularity_time1617_45,
  t4.popularity_time1718 AS popularity_time1718_46,
  t4.popularity_time1819 AS popularity_time1819_47,
  t4.popularity_time1920 AS popularity_time1920_48,
  t4.popularity_time2021 AS popularity_time2021_49,
  t4.popularity_time2122 AS popularity_time2122_50,
  t4.popularity_time2223 AS popularity_time2223_51,
  t4.popularity_time2300 AS popularity_time2300_52,
  t4.you_tube_id AS you_tube_id_53,
  t4.city_id AS city_id_54,
  t4.media_id AS media_id_55,
  t4.price_range_id AS price_range_id_56,
  t0.gallery_place_id AS gallery_place_id_57
FROM
  media t0
  LEFT JOIN place t4 ON t4.media_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.file_name AS file_name_3, t4.created_at AS created_at_5, t4.updated_at AS updated_at_6, t4.deleted_at AS deleted_at_7, t4.id AS id_8, t4.name AS name_9, t4.cid AS cid_10, t4.description AS description_11, t4.complet_address AS complet_address_12, t4.uri_image AS uri_image_13, t4.lat AS lat_14, t4.lng AS lng_15, t4.geohash AS geohash_16, t4.rating AS rating_17, t4.votes_count AS votes_count_18, t4.rating_count1 AS rating_count1_19, t4.rating_count2 AS rating_count2_20, t4.rating_count3 AS rating_count3_21, t4.rating_count4 AS rating_count4_22, t4.rating_count5 AS rating_count5_23, t4.status AS status_24, t4.score AS score_25, t4.recent AS recent_26, t4.opening_time AS opening_time_27, t4.closing_time AS closing_time_28, t4.popularity_time0001 AS popularity_time0001_29, t4.popularity_time0102 AS popularity_time0102_30, t4.popularity_time0203 AS popularity_time0203_31, t4.popularity_time0304 AS popularity_time0304_32, t4.popularity_time0405 AS popularity_time0405_33, t4.popularity_time0506 AS popularity_time0506_34, t4.popularity_time0607 AS popularity_time0607_35, t4.popularity_time0708 AS popularity_time0708_36, t4.popularity_time0809 AS popularity_time0809_37, t4.popularity_time0910 AS popularity_time0910_38, t4.popularity_time1011 AS popularity_time1011_39, t4.popularity_time1112 AS popularity_time1112_40, t4.popularity_time1213 AS popularity_time1213_41, t4.popularity_time1314 AS popularity_time1314_42, t4.popularity_time1415 AS popularity_time1415_43, t4.popularity_time1516 AS popularity_time1516_44, t4.popularity_time1617 AS popularity_time1617_45, t4.popularity_time1718 AS popularity_time1718_46, t4.popularity_time1819 AS popularity_time1819_47, t4.popularity_time1920 AS popularity_time1920_48, t4.popularity_time2021 AS popularity_time2021_49, t4.popularity_time2122 AS popularity_time2122_50, t4.popularity_time2223 AS popularity_time2223_51, t4.popularity_time2300 AS popularity_time2300_52, t4.you_tube_id AS you_tube_id_53, t4.city_id AS city_id_54, t4.media_id AS media_id_55, t4.price_range_id AS price_range_id_56, t0.gallery_place_id AS gallery_place_id_57 FROM media t0 LEFT JOIN place t4 ON t4.media_id = t0.id WHERE t0.id = 2704;