Symfony Profiler

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;

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.slug = ? 
  AND t0.city_id = ? 
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.slug = 'play-city' AND t0.city_id = 1 LIMIT 1;

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

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

SELECT 
  t0.name AS name_1, 
  t0.description AS description_2, 
  t0.is_menu AS is_menu_3, 
  t0.is_menu_web AS is_menu_web_4, 
  t0.is_menu_app AS is_menu_app_5, 
  t0.is_menu_vr AS is_menu_vr_6, 
  t0.included_by_default_in_web AS included_by_default_in_web_7, 
  t0.included_by_default_in_app AS included_by_default_in_app_8, 
  t0.included_by_default_in_vr AS included_by_default_in_vr_9, 
  t0.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_10, 
  t0.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_11, 
  t0.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_12, 
  t0.id AS id_13, 
  t0.parent_category_id AS parent_category_id_14 
FROM 
  category t0 
WHERE 
  t0.id IN (?)

SELECT t0.name AS name_1, t0.description AS description_2, t0.is_menu AS is_menu_3, t0.is_menu_web AS is_menu_web_4, t0.is_menu_app AS is_menu_app_5, t0.is_menu_vr AS is_menu_vr_6, t0.included_by_default_in_web AS included_by_default_in_web_7, t0.included_by_default_in_app AS included_by_default_in_app_8, t0.included_by_default_in_vr AS included_by_default_in_vr_9, t0.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_10, t0.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_11, t0.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_12, t0.id AS id_13, t0.parent_category_id AS parent_category_id_14 FROM category t0 WHERE t0.id IN (3, 135, 64);

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

SELECT 
  t0.id AS id_1, 
  t0.thumbnail_image AS thumbnail_image_2, 
  t0.type AS type_3, 
  t0.data AS data_4, 
  t0.game_data AS game_data_5, 
  t0.active AS active_6, 
  t0.test_card_allowed AS test_card_allowed_7, 
  t0.latitude AS latitude_8, 
  t0.longitude AS longitude_9, 
  t0.is_single_place AS is_single_place_10, 
  t0.title AS title_11, 
  t0.provider_url AS provider_url_12, 
  t0.slug AS slug_13, 
  t0.duration AS duration_14, 
  t0.thumbnail_type AS thumbnail_type_15, 
  t0.css_thumbnail_center AS css_thumbnail_center_16, 
  t0.short_description AS short_description_17, 
  t0.description AS description_18, 
  t0.meta_title AS meta_title_19, 
  t0.created_by AS created_by_20, 
  t0.show_in_libraries_page AS show_in_libraries_page_21, 
  t0.meta_description AS meta_description_22, 
  t0.created_at AS created_at_23, 
  t0.updated_at AS updated_at_24, 
  t0.image AS image_25, 
  t0.booking_page_image AS booking_page_image_26, 
  t0.price_amd AS price_amd_27, 
  t0.price_usd AS price_usd_28, 
  t0.price_euro AS price_euro_29, 
  t0.price_ruble AS price_ruble_30, 
  t0.rating AS rating_31, 
  t0.total_reviews AS total_reviews_32, 
  t0.lonely_planet_id AS lonely_planet_id_33, 
  t0.gyg_id AS gyg_id_34, 
  t0.tiqets_id AS tiqets_id_35, 
  t0.headout_id AS headout_id_36, 
  t0.path AS path_37, 
  t0.provider_id AS provider_id_38, 
  t0.tour_id AS tour_id_39, 
  t0.created_by_user_id AS created_by_user_id_40, 
  t0.video_id AS video_id_41, 
  t0.new_category_id AS new_category_id_42, 
  t43.name AS name_44, 
  t43.description AS description_45, 
  t43.is_menu AS is_menu_46, 
  t43.is_menu_web AS is_menu_web_47, 
  t43.is_menu_app AS is_menu_app_48, 
  t43.is_menu_vr AS is_menu_vr_49, 
  t43.included_by_default_in_web AS included_by_default_in_web_50, 
  t43.included_by_default_in_app AS included_by_default_in_app_51, 
  t43.included_by_default_in_vr AS included_by_default_in_vr_52, 
  t43.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_53, 
  t43.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_54, 
  t43.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_55, 
  t43.id AS id_56, 
  t43.parent_category_id AS parent_category_id_57, 
  t0.city_id AS city_id_58, 
  t0.selected_city_id AS selected_city_id_59 
FROM 
  experience t0 
  LEFT JOIN category t43 ON t0.new_category_id = t43.id 
  INNER JOIN experience_story ON t0.id = experience_story.experience_id 
WHERE 
  experience_story.story_id = ?

SELECT t0.id AS id_1, t0.thumbnail_image AS thumbnail_image_2, t0.type AS type_3, t0.data AS data_4, t0.game_data AS game_data_5, t0.active AS active_6, t0.test_card_allowed AS test_card_allowed_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.is_single_place AS is_single_place_10, t0.title AS title_11, t0.provider_url AS provider_url_12, t0.slug AS slug_13, t0.duration AS duration_14, t0.thumbnail_type AS thumbnail_type_15, t0.css_thumbnail_center AS css_thumbnail_center_16, t0.short_description AS short_description_17, t0.description AS description_18, t0.meta_title AS meta_title_19, t0.created_by AS created_by_20, t0.show_in_libraries_page AS show_in_libraries_page_21, t0.meta_description AS meta_description_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.image AS image_25, t0.booking_page_image AS booking_page_image_26, t0.price_amd AS price_amd_27, t0.price_usd AS price_usd_28, t0.price_euro AS price_euro_29, t0.price_ruble AS price_ruble_30, t0.rating AS rating_31, t0.total_reviews AS total_reviews_32, t0.lonely_planet_id AS lonely_planet_id_33, t0.gyg_id AS gyg_id_34, t0.tiqets_id AS tiqets_id_35, t0.headout_id AS headout_id_36, t0.path AS path_37, t0.provider_id AS provider_id_38, t0.tour_id AS tour_id_39, t0.created_by_user_id AS created_by_user_id_40, t0.video_id AS video_id_41, t0.new_category_id AS new_category_id_42, t43.name AS name_44, t43.description AS description_45, t43.is_menu AS is_menu_46, t43.is_menu_web AS is_menu_web_47, t43.is_menu_app AS is_menu_app_48, t43.is_menu_vr AS is_menu_vr_49, t43.included_by_default_in_web AS included_by_default_in_web_50, t43.included_by_default_in_app AS included_by_default_in_app_51, t43.included_by_default_in_vr AS included_by_default_in_vr_52, t43.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_53, t43.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_54, t43.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_55, t43.id AS id_56, t43.parent_category_id AS parent_category_id_57, t0.city_id AS city_id_58, t0.selected_city_id AS selected_city_id_59 FROM experience t0 LEFT JOIN category t43 ON t0.new_category_id = t43.id INNER JOIN experience_story ON t0.id = experience_story.experience_id WHERE experience_story.story_id = 5648;

SELECT 
  t0.id AS id_1, 
  t0.thumbnail_image AS thumbnail_image_2, 
  t0.type AS type_3, 
  t0.data AS data_4, 
  t0.game_data AS game_data_5, 
  t0.active AS active_6, 
  t0.test_card_allowed AS test_card_allowed_7, 
  t0.latitude AS latitude_8, 
  t0.longitude AS longitude_9, 
  t0.is_single_place AS is_single_place_10, 
  t0.title AS title_11, 
  t0.provider_url AS provider_url_12, 
  t0.slug AS slug_13, 
  t0.duration AS duration_14, 
  t0.thumbnail_type AS thumbnail_type_15, 
  t0.css_thumbnail_center AS css_thumbnail_center_16, 
  t0.short_description AS short_description_17, 
  t0.description AS description_18, 
  t0.meta_title AS meta_title_19, 
  t0.created_by AS created_by_20, 
  t0.show_in_libraries_page AS show_in_libraries_page_21, 
  t0.meta_description AS meta_description_22, 
  t0.created_at AS created_at_23, 
  t0.updated_at AS updated_at_24, 
  t0.image AS image_25, 
  t0.booking_page_image AS booking_page_image_26, 
  t0.price_amd AS price_amd_27, 
  t0.price_usd AS price_usd_28, 
  t0.price_euro AS price_euro_29, 
  t0.price_ruble AS price_ruble_30, 
  t0.rating AS rating_31, 
  t0.total_reviews AS total_reviews_32, 
  t0.lonely_planet_id AS lonely_planet_id_33, 
  t0.gyg_id AS gyg_id_34, 
  t0.tiqets_id AS tiqets_id_35, 
  t0.headout_id AS headout_id_36, 
  t0.path AS path_37, 
  t0.provider_id AS provider_id_38, 
  t0.tour_id AS tour_id_39, 
  t0.created_by_user_id AS created_by_user_id_40, 
  t0.video_id AS video_id_41, 
  t0.new_category_id AS new_category_id_42, 
  t43.name AS name_44, 
  t43.description AS description_45, 
  t43.is_menu AS is_menu_46, 
  t43.is_menu_web AS is_menu_web_47, 
  t43.is_menu_app AS is_menu_app_48, 
  t43.is_menu_vr AS is_menu_vr_49, 
  t43.included_by_default_in_web AS included_by_default_in_web_50, 
  t43.included_by_default_in_app AS included_by_default_in_app_51, 
  t43.included_by_default_in_vr AS included_by_default_in_vr_52, 
  t43.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_53, 
  t43.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_54, 
  t43.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_55, 
  t43.id AS id_56, 
  t43.parent_category_id AS parent_category_id_57, 
  t0.city_id AS city_id_58, 
  t0.selected_city_id AS selected_city_id_59 
FROM 
  experience t0 
  LEFT JOIN category t43 ON t0.new_category_id = t43.id 
WHERE 
  t0.city_id = ? 
  AND t0.active = ? 
  AND t0.type = ? 
LIMIT 
  1 OFFSET 0

SELECT t0.id AS id_1, t0.thumbnail_image AS thumbnail_image_2, t0.type AS type_3, t0.data AS data_4, t0.game_data AS game_data_5, t0.active AS active_6, t0.test_card_allowed AS test_card_allowed_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.is_single_place AS is_single_place_10, t0.title AS title_11, t0.provider_url AS provider_url_12, t0.slug AS slug_13, t0.duration AS duration_14, t0.thumbnail_type AS thumbnail_type_15, t0.css_thumbnail_center AS css_thumbnail_center_16, t0.short_description AS short_description_17, t0.description AS description_18, t0.meta_title AS meta_title_19, t0.created_by AS created_by_20, t0.show_in_libraries_page AS show_in_libraries_page_21, t0.meta_description AS meta_description_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.image AS image_25, t0.booking_page_image AS booking_page_image_26, t0.price_amd AS price_amd_27, t0.price_usd AS price_usd_28, t0.price_euro AS price_euro_29, t0.price_ruble AS price_ruble_30, t0.rating AS rating_31, t0.total_reviews AS total_reviews_32, t0.lonely_planet_id AS lonely_planet_id_33, t0.gyg_id AS gyg_id_34, t0.tiqets_id AS tiqets_id_35, t0.headout_id AS headout_id_36, t0.path AS path_37, t0.provider_id AS provider_id_38, t0.tour_id AS tour_id_39, t0.created_by_user_id AS created_by_user_id_40, t0.video_id AS video_id_41, t0.new_category_id AS new_category_id_42, t43.name AS name_44, t43.description AS description_45, t43.is_menu AS is_menu_46, t43.is_menu_web AS is_menu_web_47, t43.is_menu_app AS is_menu_app_48, t43.is_menu_vr AS is_menu_vr_49, t43.included_by_default_in_web AS included_by_default_in_web_50, t43.included_by_default_in_app AS included_by_default_in_app_51, t43.included_by_default_in_vr AS included_by_default_in_vr_52, t43.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_53, t43.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_54, t43.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_55, t43.id AS id_56, t43.parent_category_id AS parent_category_id_57, t0.city_id AS city_id_58, t0.selected_city_id AS selected_city_id_59 FROM experience t0 LEFT JOIN category t43 ON t0.new_category_id = t43.id WHERE t0.city_id = 1 AND t0.active = 1 AND t0.type = 1 LIMIT 1 OFFSET 0;

SELECT 
  t0.id AS id_1, 
  t0.created_at AS created_at_2, 
  t0.starts_at AS starts_at_3, 
  t0.started_at AS started_at_4, 
  t0.ended_at AS ended_at_5, 
  t0.duration AS duration_6, 
  t0.data AS data_7, 
  t0.timezone AS timezone_8, 
  t0.title AS title_9, 
  t0.room AS room_10, 
  t0.type AS type_11, 
  t0.redirect_url AS redirect_url_12, 
  t0.game_data AS game_data_13, 
  t0.show_in_libraries_page AS show_in_libraries_page_14, 
  t0.user_id AS user_id_15, 
  t0.experience_id AS experience_id_16, 
  t17.id AS id_18, 
  t17.created_at AS created_at_19, 
  t17.name AS name_20, 
  t17.email AS email_21, 
  t17.group_id AS group_id_22, 
  t17.participant_id AS participant_id_23, 
  t17.exited_at AS exited_at_24, 
  t17.live_tour_id AS live_tour_id_25, 
  t26.id AS id_27, 
  t26.rating AS rating_28, 
  t26.comment AS comment_29, 
  t26.created_at AS created_at_30, 
  t26.updated_at AS updated_at_31, 
  t26.enabled AS enabled_32, 
  t26.participant_id AS participant_id_33, 
  t26.live_tour_id AS live_tour_id_34 
FROM 
  live_tour t0 
  LEFT JOIN live_tour_participant t17 ON t17.live_tour_id = t0.id 
  LEFT JOIN review t26 ON t26.live_tour_id = t0.id 
WHERE 
  t0.experience_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.starts_at AS starts_at_3, t0.started_at AS started_at_4, t0.ended_at AS ended_at_5, t0.duration AS duration_6, t0.data AS data_7, t0.timezone AS timezone_8, t0.title AS title_9, t0.room AS room_10, t0.type AS type_11, t0.redirect_url AS redirect_url_12, t0.game_data AS game_data_13, t0.show_in_libraries_page AS show_in_libraries_page_14, t0.user_id AS user_id_15, t0.experience_id AS experience_id_16, t17.id AS id_18, t17.created_at AS created_at_19, t17.name AS name_20, t17.email AS email_21, t17.group_id AS group_id_22, t17.participant_id AS participant_id_23, t17.exited_at AS exited_at_24, t17.live_tour_id AS live_tour_id_25, t26.id AS id_27, t26.rating AS rating_28, t26.comment AS comment_29, t26.created_at AS created_at_30, t26.updated_at AS updated_at_31, t26.enabled AS enabled_32, t26.participant_id AS participant_id_33, t26.live_tour_id AS live_tour_id_34 FROM live_tour t0 LEFT JOIN live_tour_participant t17 ON t17.live_tour_id = t0.id LEFT JOIN review t26 ON t26.live_tour_id = t0.id WHERE t0.experience_id = 574;

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.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 = 824;

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