Symfony Profiler

SELECT 
  t0.id AS id_1, 
  t0.text AS text_2, 
  t0.created_at AS created_at_3, 
  t0.audio_path AS audio_path_4, 
  t0.story_id AS story_id_5, 
  t0.place_id AS place_id_6, 
  t0.user_id AS user_id_7 
FROM 
  comment t0 
WHERE 
  t0.place_id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.created_at AS created_at_3, t0.audio_path AS audio_path_4, t0.story_id AS story_id_5, t0.place_id AS place_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.place_id = 196;

SELECT 
  t0.id AS id_1, 
  t0.first_fly_through_video AS first_fly_through_video_2, 
  t0.second_fly_through_video AS second_fly_through_video_3, 
  t0.first_walk_through_video AS first_walk_through_video_4, 
  t0.second_walk_through_video AS second_walk_through_video_5, 
  t0.walk_through_thumbnail AS walk_through_thumbnail_6, 
  t0.fly_through_thumbnail AS fly_through_thumbnail_7, 
  t0.walk_through_view_angle AS walk_through_view_angle_8, 
  t0.fly_through_view_angle AS fly_through_view_angle_9, 
  t0.city_id AS city_id_10, 
  t0.place_id AS place_id_11 
FROM 
  action_video t0 
WHERE 
  t0.place_id = ?

SELECT t0.id AS id_1, t0.first_fly_through_video AS first_fly_through_video_2, t0.second_fly_through_video AS second_fly_through_video_3, t0.first_walk_through_video AS first_walk_through_video_4, t0.second_walk_through_video AS second_walk_through_video_5, t0.walk_through_thumbnail AS walk_through_thumbnail_6, t0.fly_through_thumbnail AS fly_through_thumbnail_7, t0.walk_through_view_angle AS walk_through_view_angle_8, t0.fly_through_view_angle AS fly_through_view_angle_9, t0.city_id AS city_id_10, t0.place_id AS place_id_11 FROM action_video t0 WHERE t0.place_id = 1707;

SELECT 
  t0.`key` AS key_1, 
  t0.value AS value_2, 
  t0.id AS id_3 
FROM 
  dictionary t0 
WHERE 
  t0.`key` = ? 
LIMIT 
  1

SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = 'site_title_default_suffix' LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.title AS title_2, 
  t0.slug AS slug_3, 
  t0.story_type AS story_type_4, 
  t0.description AS description_5, 
  t0.meta_title AS meta_title_6, 
  t0.meta_description AS meta_description_7, 
  t0.video_url AS video_url_8, 
  t0.video_path AS video_path_9, 
  t0.ath AS ath_10, 
  t0.atv AS atv_11, 
  t0.view_count AS view_count_12, 
  t0.is_autogenerated AS is_autogenerated_13, 
  t0.private AS private_14, 
  t0.created_from_place AS created_from_place_15, 
  t0.created_at AS created_at_16, 
  t0.updated_at AS updated_at_17, 
  t0.latitude AS latitude_18, 
  t0.longitude AS longitude_19, 
  t0.user_id AS user_id_20, 
  t0.city_id AS city_id_21, 
  t0.point_id AS point_id_22, 
  t23.id AS id_24, 
  t23.title AS title_25, 
  t23.thumbnail_image AS thumbnail_image_26, 
  t23.slug AS slug_27, 
  t23.meta_title AS meta_title_28, 
  t23.meta_description AS meta_description_29, 
  t23.description AS description_30, 
  t23.video_url AS video_url_31, 
  t23.ath AS ath_32, 
  t23.atv AS atv_33, 
  t23.second_ath AS second_ath_34, 
  t23.second_atv AS second_atv_35, 
  t23.third_ath AS third_ath_36, 
  t23.third_atv AS third_atv_37, 
  t23.view_count AS view_count_38, 
  t23.thumbnail_type AS thumbnail_type_39, 
  t23.css_thumbnail_center AS css_thumbnail_center_40, 
  t23.published AS published_41, 
  t23.created_at AS created_at_42, 
  t23.updated_at AS updated_at_43, 
  t23.name AS name_44, 
  t23.phone_numbers AS phone_numbers_45, 
  t23.address AS address_46, 
  t23.website AS website_47, 
  t23.lonely_planet_id AS lonely_planet_id_48, 
  t23.overlay_image AS overlay_image_49, 
  t23.overlay_h AS overlay_h_50, 
  t23.overlay_v AS overlay_v_51, 
  t23.overlay_width AS overlay_width_52, 
  t23.overlay_height AS overlay_height_53, 
  t23.overlay_active AS overlay_active_54, 
  t23.city_id AS city_id_55, 
  t23.category_id AS category_id_56, 
  t23.new_category_id AS new_category_id_57, 
  t23.category2_id AS category2_id_58, 
  t23.category3_id AS category3_id_59, 
  t23.second_point_id AS second_point_id_60, 
  t23.third_point_id AS third_point_id_61, 
  t23.point_id AS point_id_62, 
  t23.story_id AS story_id_63, 
  t23.inner_point_id AS inner_point_id_64 
FROM 
  story t0 
  LEFT JOIN place t23 ON t23.story_id = t0.id 
WHERE 
  t0.point_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.story_type AS story_type_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.video_url AS video_url_8, t0.video_path AS video_path_9, t0.ath AS ath_10, t0.atv AS atv_11, t0.view_count AS view_count_12, t0.is_autogenerated AS is_autogenerated_13, t0.private AS private_14, t0.created_from_place AS created_from_place_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.latitude AS latitude_18, t0.longitude AS longitude_19, t0.user_id AS user_id_20, t0.city_id AS city_id_21, t0.point_id AS point_id_22, t23.id AS id_24, t23.title AS title_25, t23.thumbnail_image AS thumbnail_image_26, t23.slug AS slug_27, t23.meta_title AS meta_title_28, t23.meta_description AS meta_description_29, t23.description AS description_30, t23.video_url AS video_url_31, t23.ath AS ath_32, t23.atv AS atv_33, t23.second_ath AS second_ath_34, t23.second_atv AS second_atv_35, t23.third_ath AS third_ath_36, t23.third_atv AS third_atv_37, t23.view_count AS view_count_38, t23.thumbnail_type AS thumbnail_type_39, t23.css_thumbnail_center AS css_thumbnail_center_40, t23.published AS published_41, t23.created_at AS created_at_42, t23.updated_at AS updated_at_43, t23.name AS name_44, t23.phone_numbers AS phone_numbers_45, t23.address AS address_46, t23.website AS website_47, t23.lonely_planet_id AS lonely_planet_id_48, t23.overlay_image AS overlay_image_49, t23.overlay_h AS overlay_h_50, t23.overlay_v AS overlay_v_51, t23.overlay_width AS overlay_width_52, t23.overlay_height AS overlay_height_53, t23.overlay_active AS overlay_active_54, t23.city_id AS city_id_55, t23.category_id AS category_id_56, t23.new_category_id AS new_category_id_57, t23.category2_id AS category2_id_58, t23.category3_id AS category3_id_59, t23.second_point_id AS second_point_id_60, t23.third_point_id AS third_point_id_61, t23.point_id AS point_id_62, t23.story_id AS story_id_63, t23.inner_point_id AS inner_point_id_64 FROM story t0 LEFT JOIN place t23 ON t23.story_id = t0.id WHERE t0.point_id = 2692;

SELECT 
  t0.id AS id_1, 
  t0.point_number AS point_number_2, 
  t0.point_name AS point_name_3, 
  t0.slug AS slug_4, 
  t0.sound_name AS sound_name_5, 
  t0.sharing_image_name AS sharing_image_name_6, 
  t0.video_name AS video_name_7, 
  t0.video_name_2 AS video_name_2_8, 
  t0.video_name_3 AS video_name_3_9, 
  t0.latitude AS latitude_10, 
  t0.longitude AS longitude_11, 
  t0.is_published AS is_published_12, 
  t0.is_visible_in_tour AS is_visible_in_tour_13, 
  t0.display_name AS display_name_14, 
  t0.hlookat AS hlookat_15, 
  t0.vlookat AS vlookat_16, 
  t0.created_at AS created_at_17, 
  t0.requires_conversion AS requires_conversion_18, 
  t0.city_id AS city_id_19, 
  t0.place_id AS place_id_20, 
  t21.id AS id_22, 
  t21.image AS image_23, 
  t21.h AS h_24, 
  t21.v AS v_25, 
  t21.width AS width_26, 
  t21.height AS height_27, 
  t21.created_at AS created_at_28, 
  t21.updated_at AS updated_at_29, 
  t21.point_id AS point_id_30, 
  t31.id AS id_32, 
  t31.h AS h_33, 
  t31.v AS v_34, 
  t31.width AS width_35, 
  t31.height AS height_36, 
  t31.rotationX AS rotationX_37, 
  t31.rotationY AS rotationY_38, 
  t31.rotationZ AS rotationZ_39, 
  t31.shadow AS shadow_40, 
  t31.point_id AS point_id_41, 
  t31.experience_id AS experience_id_42 
FROM 
  point t0 
  LEFT JOIN overlay_image t21 ON t21.point_id = t0.id 
  LEFT JOIN portal t31 ON t31.point_id = t0.id 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.point_number AS point_number_2, t0.point_name AS point_name_3, t0.slug AS slug_4, t0.sound_name AS sound_name_5, t0.sharing_image_name AS sharing_image_name_6, t0.video_name AS video_name_7, t0.video_name_2 AS video_name_2_8, t0.video_name_3 AS video_name_3_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.is_published AS is_published_12, t0.is_visible_in_tour AS is_visible_in_tour_13, t0.display_name AS display_name_14, t0.hlookat AS hlookat_15, t0.vlookat AS vlookat_16, t0.created_at AS created_at_17, t0.requires_conversion AS requires_conversion_18, t0.city_id AS city_id_19, t0.place_id AS place_id_20, t21.id AS id_22, t21.image AS image_23, t21.h AS h_24, t21.v AS v_25, t21.width AS width_26, t21.height AS height_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.point_id AS point_id_30, t31.id AS id_32, t31.h AS h_33, t31.v AS v_34, t31.width AS width_35, t31.height AS height_36, t31.rotationX AS rotationX_37, t31.rotationY AS rotationY_38, t31.rotationZ AS rotationZ_39, t31.shadow AS shadow_40, t31.point_id AS point_id_41, t31.experience_id AS experience_id_42 FROM point t0 LEFT JOIN overlay_image t21 ON t21.point_id = t0.id LEFT JOIN portal t31 ON t31.point_id = t0.id WHERE t0.id = 2692;

SELECT 
  t0.id AS id_1, 
  t0.email AS email_2, 
  t0.phone AS phone_3, 
  t0.created_at AS created_at_4, 
  t0.updated_at AS updated_at_5, 
  t0.first_name AS first_name_6, 
  t0.last_name AS last_name_7, 
  t0.country AS country_8, 
  t0.kids AS kids_9, 
  t0.adults AS adults_10, 
  t0.price_kids AS price_kids_11, 
  t0.price_adults AS price_adults_12, 
  t0.data AS data_13, 
  t0.experience_id AS experience_id_14, 
  t0.live_tour_id AS live_tour_id_15, 
  t0.user_id AS user_id_16 
FROM 
  booking t0 
WHERE 
  t0.live_tour_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.country AS country_8, t0.kids AS kids_9, t0.adults AS adults_10, t0.price_kids AS price_kids_11, t0.price_adults AS price_adults_12, t0.data AS data_13, t0.experience_id AS experience_id_14, t0.live_tour_id AS live_tour_id_15, t0.user_id AS user_id_16 FROM booking t0 WHERE t0.live_tour_id = 823;

SELECT 
  t0.id AS id_1, 
  t0.title AS title_2, 
  t0.thumbnail_image AS thumbnail_image_3, 
  t0.slug AS slug_4, 
  t0.meta_title AS meta_title_5, 
  t0.meta_description AS meta_description_6, 
  t0.description AS description_7, 
  t0.video_url AS video_url_8, 
  t0.ath AS ath_9, 
  t0.atv AS atv_10, 
  t0.second_ath AS second_ath_11, 
  t0.second_atv AS second_atv_12, 
  t0.third_ath AS third_ath_13, 
  t0.third_atv AS third_atv_14, 
  t0.view_count AS view_count_15, 
  t0.thumbnail_type AS thumbnail_type_16, 
  t0.css_thumbnail_center AS css_thumbnail_center_17, 
  t0.published AS published_18, 
  t0.created_at AS created_at_19, 
  t0.updated_at AS updated_at_20, 
  t0.name AS name_21, 
  t0.phone_numbers AS phone_numbers_22, 
  t0.address AS address_23, 
  t0.website AS website_24, 
  t0.lonely_planet_id AS lonely_planet_id_25, 
  t0.overlay_image AS overlay_image_26, 
  t0.overlay_h AS overlay_h_27, 
  t0.overlay_v AS overlay_v_28, 
  t0.overlay_width AS overlay_width_29, 
  t0.overlay_height AS overlay_height_30, 
  t0.overlay_active AS overlay_active_31, 
  t0.city_id AS city_id_32, 
  t0.category_id AS category_id_33, 
  t34.name AS name_35, 
  t34.description AS description_36, 
  t34.is_menu AS is_menu_37, 
  t34.is_menu_web AS is_menu_web_38, 
  t34.is_menu_app AS is_menu_app_39, 
  t34.is_menu_vr AS is_menu_vr_40, 
  t34.included_by_default_in_web AS included_by_default_in_web_41, 
  t34.included_by_default_in_app AS included_by_default_in_app_42, 
  t34.included_by_default_in_vr AS included_by_default_in_vr_43, 
  t34.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_44, 
  t34.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_45, 
  t34.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_46, 
  t34.id AS id_47, 
  t34.parent_category_id AS parent_category_id_48, 
  t0.new_category_id AS new_category_id_49, 
  t50.name AS name_51, 
  t50.description AS description_52, 
  t50.is_menu AS is_menu_53, 
  t50.is_menu_web AS is_menu_web_54, 
  t50.is_menu_app AS is_menu_app_55, 
  t50.is_menu_vr AS is_menu_vr_56, 
  t50.included_by_default_in_web AS included_by_default_in_web_57, 
  t50.included_by_default_in_app AS included_by_default_in_app_58, 
  t50.included_by_default_in_vr AS included_by_default_in_vr_59, 
  t50.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_60, 
  t50.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_61, 
  t50.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_62, 
  t50.id AS id_63, 
  t50.parent_category_id AS parent_category_id_64, 
  t0.category2_id AS category2_id_65, 
  t66.name AS name_67, 
  t66.description AS description_68, 
  t66.is_menu AS is_menu_69, 
  t66.is_menu_web AS is_menu_web_70, 
  t66.is_menu_app AS is_menu_app_71, 
  t66.is_menu_vr AS is_menu_vr_72, 
  t66.included_by_default_in_web AS included_by_default_in_web_73, 
  t66.included_by_default_in_app AS included_by_default_in_app_74, 
  t66.included_by_default_in_vr AS included_by_default_in_vr_75, 
  t66.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_76, 
  t66.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_77, 
  t66.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_78, 
  t66.id AS id_79, 
  t66.parent_category_id AS parent_category_id_80, 
  t0.category3_id AS category3_id_81, 
  t82.name AS name_83, 
  t82.description AS description_84, 
  t82.is_menu AS is_menu_85, 
  t82.is_menu_web AS is_menu_web_86, 
  t82.is_menu_app AS is_menu_app_87, 
  t82.is_menu_vr AS is_menu_vr_88, 
  t82.included_by_default_in_web AS included_by_default_in_web_89, 
  t82.included_by_default_in_app AS included_by_default_in_app_90, 
  t82.included_by_default_in_vr AS included_by_default_in_vr_91, 
  t82.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_92, 
  t82.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_93, 
  t82.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_94, 
  t82.id AS id_95, 
  t82.parent_category_id AS parent_category_id_96, 
  t97.id AS id_98, 
  t97.first_fly_through_video AS first_fly_through_video_99, 
  t97.second_fly_through_video AS second_fly_through_video_100, 
  t97.first_walk_through_video AS first_walk_through_video_101, 
  t97.second_walk_through_video AS second_walk_through_video_102, 
  t97.walk_through_thumbnail AS walk_through_thumbnail_103, 
  t97.fly_through_thumbnail AS fly_through_thumbnail_104, 
  t97.walk_through_view_angle AS walk_through_view_angle_105, 
  t97.fly_through_view_angle AS fly_through_view_angle_106, 
  t97.city_id AS city_id_107, 
  t97.place_id AS place_id_108, 
  t0.second_point_id AS second_point_id_109, 
  t0.third_point_id AS third_point_id_110, 
  t0.point_id AS point_id_111, 
  t0.story_id AS story_id_112, 
  t0.inner_point_id AS inner_point_id_113 
FROM 
  place t0 
  LEFT JOIN category t34 ON t0.category_id = t34.id 
  LEFT JOIN category t50 ON t0.new_category_id = t50.id 
  LEFT JOIN category t66 ON t0.category2_id = t66.id 
  LEFT JOIN category t82 ON t0.category3_id = t82.id 
  LEFT JOIN action_video t97 ON t97.place_id = t0.id 
WHERE 
  t0.slug = ? 
  AND t0.published = ? 
  AND t0.city_id = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.thumbnail_image AS thumbnail_image_3, t0.slug AS slug_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.description AS description_7, t0.video_url AS video_url_8, t0.ath AS ath_9, t0.atv AS atv_10, t0.second_ath AS second_ath_11, t0.second_atv AS second_atv_12, t0.third_ath AS third_ath_13, t0.third_atv AS third_atv_14, t0.view_count AS view_count_15, t0.thumbnail_type AS thumbnail_type_16, t0.css_thumbnail_center AS css_thumbnail_center_17, t0.published AS published_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.name AS name_21, t0.phone_numbers AS phone_numbers_22, t0.address AS address_23, t0.website AS website_24, t0.lonely_planet_id AS lonely_planet_id_25, t0.overlay_image AS overlay_image_26, t0.overlay_h AS overlay_h_27, t0.overlay_v AS overlay_v_28, t0.overlay_width AS overlay_width_29, t0.overlay_height AS overlay_height_30, t0.overlay_active AS overlay_active_31, t0.city_id AS city_id_32, t0.category_id AS category_id_33, t34.name AS name_35, t34.description AS description_36, t34.is_menu AS is_menu_37, t34.is_menu_web AS is_menu_web_38, t34.is_menu_app AS is_menu_app_39, t34.is_menu_vr AS is_menu_vr_40, t34.included_by_default_in_web AS included_by_default_in_web_41, t34.included_by_default_in_app AS included_by_default_in_app_42, t34.included_by_default_in_vr AS included_by_default_in_vr_43, t34.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_44, t34.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_45, t34.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_46, t34.id AS id_47, t34.parent_category_id AS parent_category_id_48, t0.new_category_id AS new_category_id_49, t50.name AS name_51, t50.description AS description_52, t50.is_menu AS is_menu_53, t50.is_menu_web AS is_menu_web_54, t50.is_menu_app AS is_menu_app_55, t50.is_menu_vr AS is_menu_vr_56, t50.included_by_default_in_web AS included_by_default_in_web_57, t50.included_by_default_in_app AS included_by_default_in_app_58, t50.included_by_default_in_vr AS included_by_default_in_vr_59, t50.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_60, t50.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_61, t50.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_62, t50.id AS id_63, t50.parent_category_id AS parent_category_id_64, t0.category2_id AS category2_id_65, t66.name AS name_67, t66.description AS description_68, t66.is_menu AS is_menu_69, t66.is_menu_web AS is_menu_web_70, t66.is_menu_app AS is_menu_app_71, t66.is_menu_vr AS is_menu_vr_72, t66.included_by_default_in_web AS included_by_default_in_web_73, t66.included_by_default_in_app AS included_by_default_in_app_74, t66.included_by_default_in_vr AS included_by_default_in_vr_75, t66.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_76, t66.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_77, t66.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_78, t66.id AS id_79, t66.parent_category_id AS parent_category_id_80, t0.category3_id AS category3_id_81, t82.name AS name_83, t82.description AS description_84, t82.is_menu AS is_menu_85, t82.is_menu_web AS is_menu_web_86, t82.is_menu_app AS is_menu_app_87, t82.is_menu_vr AS is_menu_vr_88, t82.included_by_default_in_web AS included_by_default_in_web_89, t82.included_by_default_in_app AS included_by_default_in_app_90, t82.included_by_default_in_vr AS included_by_default_in_vr_91, t82.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_92, t82.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_93, t82.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_94, t82.id AS id_95, t82.parent_category_id AS parent_category_id_96, t97.id AS id_98, t97.first_fly_through_video AS first_fly_through_video_99, t97.second_fly_through_video AS second_fly_through_video_100, t97.first_walk_through_video AS first_walk_through_video_101, t97.second_walk_through_video AS second_walk_through_video_102, t97.walk_through_thumbnail AS walk_through_thumbnail_103, t97.fly_through_thumbnail AS fly_through_thumbnail_104, t97.walk_through_view_angle AS walk_through_view_angle_105, t97.fly_through_view_angle AS fly_through_view_angle_106, t97.city_id AS city_id_107, t97.place_id AS place_id_108, t0.second_point_id AS second_point_id_109, t0.third_point_id AS third_point_id_110, t0.point_id AS point_id_111, t0.story_id AS story_id_112, t0.inner_point_id AS inner_point_id_113 FROM place t0 LEFT JOIN category t34 ON t0.category_id = t34.id LEFT JOIN category t50 ON t0.new_category_id = t50.id LEFT JOIN category t66 ON t0.category2_id = t66.id LEFT JOIN category t82 ON t0.category3_id = t82.id LEFT JOIN action_video t97 ON t97.place_id = t0.id WHERE t0.slug = 'holy-mother-of-god-church-avan' AND t0.published = 1 AND t0.city_id = 1 LIMIT 1;

SELECT 
  p0_.id AS id_0, 
  p0_.title AS title_1, 
  p0_.thumbnail_image AS thumbnail_image_2, 
  p0_.slug AS slug_3, 
  p0_.meta_title AS meta_title_4, 
  p0_.meta_description AS meta_description_5, 
  p0_.description AS description_6, 
  p0_.video_url AS video_url_7, 
  p0_.ath AS ath_8, 
  p0_.atv AS atv_9, 
  p0_.second_ath AS second_ath_10, 
  p0_.second_atv AS second_atv_11, 
  p0_.third_ath AS third_ath_12, 
  p0_.third_atv AS third_atv_13, 
  p0_.view_count AS view_count_14, 
  p0_.thumbnail_type AS thumbnail_type_15, 
  p0_.css_thumbnail_center AS css_thumbnail_center_16, 
  p0_.published AS published_17, 
  p0_.created_at AS created_at_18, 
  p0_.updated_at AS updated_at_19, 
  p0_.name AS name_20, 
  p0_.phone_numbers AS phone_numbers_21, 
  p0_.address AS address_22, 
  p0_.website AS website_23, 
  p0_.lonely_planet_id AS lonely_planet_id_24, 
  p0_.overlay_image AS overlay_image_25, 
  p0_.overlay_h AS overlay_h_26, 
  p0_.overlay_v AS overlay_v_27, 
  p0_.overlay_width AS overlay_width_28, 
  p0_.overlay_height AS overlay_height_29, 
  p0_.overlay_active AS overlay_active_30, 
  p0_.city_id AS city_id_31, 
  p0_.category_id AS category_id_32, 
  p0_.new_category_id AS new_category_id_33, 
  p0_.category2_id AS category2_id_34, 
  p0_.category3_id AS category3_id_35, 
  p0_.second_point_id AS second_point_id_36, 
  p0_.third_point_id AS third_point_id_37, 
  p0_.point_id AS point_id_38, 
  p0_.story_id AS story_id_39, 
  p0_.inner_point_id AS inner_point_id_40 
FROM 
  place p0_ 
  LEFT JOIN city c1_ ON p0_.city_id = c1_.id 
  LEFT JOIN category c2_ ON p0_.new_category_id = c2_.id 
WHERE 
  c1_.id = ? 
  AND c2_.id = ? 
  AND p0_.published = 1 
  AND p0_.id > ? 
LIMIT 
  8

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.thumbnail_image AS thumbnail_image_2, p0_.slug AS slug_3, p0_.meta_title AS meta_title_4, p0_.meta_description AS meta_description_5, p0_.description AS description_6, p0_.video_url AS video_url_7, p0_.ath AS ath_8, p0_.atv AS atv_9, p0_.second_ath AS second_ath_10, p0_.second_atv AS second_atv_11, p0_.third_ath AS third_ath_12, p0_.third_atv AS third_atv_13, p0_.view_count AS view_count_14, p0_.thumbnail_type AS thumbnail_type_15, p0_.css_thumbnail_center AS css_thumbnail_center_16, p0_.published AS published_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.name AS name_20, p0_.phone_numbers AS phone_numbers_21, p0_.address AS address_22, p0_.website AS website_23, p0_.lonely_planet_id AS lonely_planet_id_24, p0_.overlay_image AS overlay_image_25, p0_.overlay_h AS overlay_h_26, p0_.overlay_v AS overlay_v_27, p0_.overlay_width AS overlay_width_28, p0_.overlay_height AS overlay_height_29, p0_.overlay_active AS overlay_active_30, p0_.city_id AS city_id_31, p0_.category_id AS category_id_32, p0_.new_category_id AS new_category_id_33, p0_.category2_id AS category2_id_34, p0_.category3_id AS category3_id_35, p0_.second_point_id AS second_point_id_36, p0_.third_point_id AS third_point_id_37, p0_.point_id AS point_id_38, p0_.story_id AS story_id_39, p0_.inner_point_id AS inner_point_id_40 FROM place p0_ LEFT JOIN city c1_ ON p0_.city_id = c1_.id LEFT JOIN category c2_ ON p0_.new_category_id = c2_.id WHERE c1_.id = 1 AND c2_.id = 145 AND p0_.published = 1 AND p0_.id > 196 LIMIT 8;

SELECT 
  t0.id AS id_1, 
  t0.published AS published_2, 
  t0.meta_title AS meta_title_3, 
  t0.meta_description AS meta_description_4, 
  t0.name AS name_5, 
  t0.domains AS domains_6, 
  t0.slug AS slug_7, 
  t0.lat AS lat_8, 
  t0.lng AS lng_9, 
  t0.map_zoom_level AS map_zoom_level_10, 
  t0.address AS address_11, 
  t0.phone_number AS phone_number_12, 
  t0.email AS email_13, 
  t0.lonely_planet_id AS lonely_planet_id_14, 
  t0.landing_image1 AS landing_image1_15, 
  t0.landing_image2 AS landing_image2_16, 
  t0.landing_image3 AS landing_image3_17, 
  t0.landing_image4 AS landing_image4_18, 
  t0.landing_image5 AS landing_image5_19, 
  t0.landing_image6 AS landing_image6_20, 
  t0.landing_image7 AS landing_image7_21, 
  t0.vr_image AS vr_image_22, 
  t0.poly_image AS poly_image_23, 
  t0.vr_icon AS vr_icon_24, 
  t0.vr_map_icon_x AS vr_map_icon_x_25, 
  t0.vr_map_icon_y AS vr_map_icon_y_26, 
  t0.airport_code AS airport_code_27, 
  t0.airport_name AS airport_name_28, 
  t0.position AS position_29, 
  t0.point_id AS point_id_30, 
  t0.weather_id AS weather_id_31, 
  t0.continent_id AS continent_id_32, 
  t0.voice_configuration_id AS voice_configuration_id_33, 
  t0.country_id AS country_id_34 
FROM 
  city t0 
WHERE 
  t0.published = ? 
ORDER BY 
  t0.slug ASC

SELECT t0.id AS id_1, t0.published AS published_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.name AS name_5, t0.domains AS domains_6, t0.slug AS slug_7, t0.lat AS lat_8, t0.lng AS lng_9, t0.map_zoom_level AS map_zoom_level_10, t0.address AS address_11, t0.phone_number AS phone_number_12, t0.email AS email_13, t0.lonely_planet_id AS lonely_planet_id_14, t0.landing_image1 AS landing_image1_15, t0.landing_image2 AS landing_image2_16, t0.landing_image3 AS landing_image3_17, t0.landing_image4 AS landing_image4_18, t0.landing_image5 AS landing_image5_19, t0.landing_image6 AS landing_image6_20, t0.landing_image7 AS landing_image7_21, t0.vr_image AS vr_image_22, t0.poly_image AS poly_image_23, t0.vr_icon AS vr_icon_24, t0.vr_map_icon_x AS vr_map_icon_x_25, t0.vr_map_icon_y AS vr_map_icon_y_26, t0.airport_code AS airport_code_27, t0.airport_name AS airport_name_28, t0.position AS position_29, t0.point_id AS point_id_30, t0.weather_id AS weather_id_31, t0.continent_id AS continent_id_32, t0.voice_configuration_id AS voice_configuration_id_33, t0.country_id AS country_id_34 FROM city t0 WHERE t0.published = 1 ORDER BY t0.slug ASC;

SELECT 
  t0.id AS id_1, 
  t0.published AS published_2, 
  t0.meta_title AS meta_title_3, 
  t0.meta_description AS meta_description_4, 
  t0.name AS name_5, 
  t0.domains AS domains_6, 
  t0.slug AS slug_7, 
  t0.lat AS lat_8, 
  t0.lng AS lng_9, 
  t0.map_zoom_level AS map_zoom_level_10, 
  t0.address AS address_11, 
  t0.phone_number AS phone_number_12, 
  t0.email AS email_13, 
  t0.lonely_planet_id AS lonely_planet_id_14, 
  t0.landing_image1 AS landing_image1_15, 
  t0.landing_image2 AS landing_image2_16, 
  t0.landing_image3 AS landing_image3_17, 
  t0.landing_image4 AS landing_image4_18, 
  t0.landing_image5 AS landing_image5_19, 
  t0.landing_image6 AS landing_image6_20, 
  t0.landing_image7 AS landing_image7_21, 
  t0.vr_image AS vr_image_22, 
  t0.poly_image AS poly_image_23, 
  t0.vr_icon AS vr_icon_24, 
  t0.vr_map_icon_x AS vr_map_icon_x_25, 
  t0.vr_map_icon_y AS vr_map_icon_y_26, 
  t0.airport_code AS airport_code_27, 
  t0.airport_name AS airport_name_28, 
  t0.position AS position_29, 
  t0.point_id AS point_id_30, 
  t0.weather_id AS weather_id_31, 
  t0.continent_id AS continent_id_32, 
  t0.voice_configuration_id AS voice_configuration_id_33, 
  t0.country_id AS country_id_34 
FROM 
  city t0 
WHERE 
  t0.name = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.published AS published_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.name AS name_5, t0.domains AS domains_6, t0.slug AS slug_7, t0.lat AS lat_8, t0.lng AS lng_9, t0.map_zoom_level AS map_zoom_level_10, t0.address AS address_11, t0.phone_number AS phone_number_12, t0.email AS email_13, t0.lonely_planet_id AS lonely_planet_id_14, t0.landing_image1 AS landing_image1_15, t0.landing_image2 AS landing_image2_16, t0.landing_image3 AS landing_image3_17, t0.landing_image4 AS landing_image4_18, t0.landing_image5 AS landing_image5_19, t0.landing_image6 AS landing_image6_20, t0.landing_image7 AS landing_image7_21, t0.vr_image AS vr_image_22, t0.poly_image AS poly_image_23, t0.vr_icon AS vr_icon_24, t0.vr_map_icon_x AS vr_map_icon_x_25, t0.vr_map_icon_y AS vr_map_icon_y_26, t0.airport_code AS airport_code_27, t0.airport_name AS airport_name_28, t0.position AS position_29, t0.point_id AS point_id_30, t0.weather_id AS weather_id_31, t0.continent_id AS continent_id_32, t0.voice_configuration_id AS voice_configuration_id_33, t0.country_id AS country_id_34 FROM city t0 WHERE t0.name = 'armenia' LIMIT 1;