Query Metrics
39
Database Queries
8
Different statements
34.36 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.12 ms |
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.id = ? LIMIT 1
Parameters: [0 => 974]
|
2 | 1.44 ms |
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, t33.id AS id_34, t33.text AS text_35, t33.created_at AS created_at_36, t33.audio_path AS audio_path_37, t33.story_id AS story_id_38, t33.place_id AS place_id_39, t33.user_id AS user_id_40, t0.category_id AS category_id_41, t42.name AS name_43, t42.description AS description_44, t42.is_menu AS is_menu_45, t42.is_menu_web AS is_menu_web_46, t42.is_menu_app AS is_menu_app_47, t42.is_menu_vr AS is_menu_vr_48, t42.included_by_default_in_web AS included_by_default_in_web_49, t42.included_by_default_in_app AS included_by_default_in_app_50, t42.included_by_default_in_vr AS included_by_default_in_vr_51, t42.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_52, t42.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_53, t42.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_54, t42.id AS id_55, t42.parent_category_id AS parent_category_id_56, t0.new_category_id AS new_category_id_57, t58.name AS name_59, t58.description AS description_60, t58.is_menu AS is_menu_61, t58.is_menu_web AS is_menu_web_62, t58.is_menu_app AS is_menu_app_63, t58.is_menu_vr AS is_menu_vr_64, t58.included_by_default_in_web AS included_by_default_in_web_65, t58.included_by_default_in_app AS included_by_default_in_app_66, t58.included_by_default_in_vr AS included_by_default_in_vr_67, t58.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_68, t58.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_69, t58.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_70, t58.id AS id_71, t58.parent_category_id AS parent_category_id_72, t0.category2_id AS category2_id_73, t74.name AS name_75, t74.description AS description_76, t74.is_menu AS is_menu_77, t74.is_menu_web AS is_menu_web_78, t74.is_menu_app AS is_menu_app_79, t74.is_menu_vr AS is_menu_vr_80, t74.included_by_default_in_web AS included_by_default_in_web_81, t74.included_by_default_in_app AS included_by_default_in_app_82, t74.included_by_default_in_vr AS included_by_default_in_vr_83, t74.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_84, t74.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_85, t74.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_86, t74.id AS id_87, t74.parent_category_id AS parent_category_id_88, t0.category3_id AS category3_id_89, t90.name AS name_91, t90.description AS description_92, t90.is_menu AS is_menu_93, t90.is_menu_web AS is_menu_web_94, t90.is_menu_app AS is_menu_app_95, t90.is_menu_vr AS is_menu_vr_96, t90.included_by_default_in_web AS included_by_default_in_web_97, t90.included_by_default_in_app AS included_by_default_in_app_98, t90.included_by_default_in_vr AS included_by_default_in_vr_99, t90.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_100, t90.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_101, t90.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_102, t90.id AS id_103, t90.parent_category_id AS parent_category_id_104, t105.id AS id_106, t105.first_fly_through_video AS first_fly_through_video_107, t105.second_fly_through_video AS second_fly_through_video_108, t105.first_walk_through_video AS first_walk_through_video_109, t105.second_walk_through_video AS second_walk_through_video_110, t105.walk_through_thumbnail AS walk_through_thumbnail_111, t105.fly_through_thumbnail AS fly_through_thumbnail_112, t105.walk_through_view_angle AS walk_through_view_angle_113, t105.fly_through_view_angle AS fly_through_view_angle_114, t105.city_id AS city_id_115, t105.place_id AS place_id_116, t0.second_point_id AS second_point_id_117, t0.third_point_id AS third_point_id_118, t0.point_id AS point_id_119, t0.story_id AS story_id_120, t0.inner_point_id AS inner_point_id_121 FROM place t0 LEFT JOIN comment t33 ON t33.place_id = t0.id LEFT JOIN category t42 ON t0.category_id = t42.id LEFT JOIN category t58 ON t0.new_category_id = t58.id LEFT JOIN category t74 ON t0.category2_id = t74.id LEFT JOIN category t90 ON t0.category3_id = t90.id LEFT JOIN action_video t105 ON t105.place_id = t0.id WHERE t0.id = ?
Parameters: [0 => 3496]
|
3 | 1.43 ms |
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, t33.id AS id_34, t33.text AS text_35, t33.created_at AS created_at_36, t33.audio_path AS audio_path_37, t33.story_id AS story_id_38, t33.place_id AS place_id_39, t33.user_id AS user_id_40, t0.category_id AS category_id_41, t42.name AS name_43, t42.description AS description_44, t42.is_menu AS is_menu_45, t42.is_menu_web AS is_menu_web_46, t42.is_menu_app AS is_menu_app_47, t42.is_menu_vr AS is_menu_vr_48, t42.included_by_default_in_web AS included_by_default_in_web_49, t42.included_by_default_in_app AS included_by_default_in_app_50, t42.included_by_default_in_vr AS included_by_default_in_vr_51, t42.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_52, t42.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_53, t42.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_54, t42.id AS id_55, t42.parent_category_id AS parent_category_id_56, t0.new_category_id AS new_category_id_57, t58.name AS name_59, t58.description AS description_60, t58.is_menu AS is_menu_61, t58.is_menu_web AS is_menu_web_62, t58.is_menu_app AS is_menu_app_63, t58.is_menu_vr AS is_menu_vr_64, t58.included_by_default_in_web AS included_by_default_in_web_65, t58.included_by_default_in_app AS included_by_default_in_app_66, t58.included_by_default_in_vr AS included_by_default_in_vr_67, t58.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_68, t58.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_69, t58.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_70, t58.id AS id_71, t58.parent_category_id AS parent_category_id_72, t0.category2_id AS category2_id_73, t74.name AS name_75, t74.description AS description_76, t74.is_menu AS is_menu_77, t74.is_menu_web AS is_menu_web_78, t74.is_menu_app AS is_menu_app_79, t74.is_menu_vr AS is_menu_vr_80, t74.included_by_default_in_web AS included_by_default_in_web_81, t74.included_by_default_in_app AS included_by_default_in_app_82, t74.included_by_default_in_vr AS included_by_default_in_vr_83, t74.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_84, t74.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_85, t74.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_86, t74.id AS id_87, t74.parent_category_id AS parent_category_id_88, t0.category3_id AS category3_id_89, t90.name AS name_91, t90.description AS description_92, t90.is_menu AS is_menu_93, t90.is_menu_web AS is_menu_web_94, t90.is_menu_app AS is_menu_app_95, t90.is_menu_vr AS is_menu_vr_96, t90.included_by_default_in_web AS included_by_default_in_web_97, t90.included_by_default_in_app AS included_by_default_in_app_98, t90.included_by_default_in_vr AS included_by_default_in_vr_99, t90.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_100, t90.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_101, t90.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_102, t90.id AS id_103, t90.parent_category_id AS parent_category_id_104, t105.id AS id_106, t105.first_fly_through_video AS first_fly_through_video_107, t105.second_fly_through_video AS second_fly_through_video_108, t105.first_walk_through_video AS first_walk_through_video_109, t105.second_walk_through_video AS second_walk_through_video_110, t105.walk_through_thumbnail AS walk_through_thumbnail_111, t105.fly_through_thumbnail AS fly_through_thumbnail_112, t105.walk_through_view_angle AS walk_through_view_angle_113, t105.fly_through_view_angle AS fly_through_view_angle_114, t105.city_id AS city_id_115, t105.place_id AS place_id_116, t0.second_point_id AS second_point_id_117, t0.third_point_id AS third_point_id_118, t0.point_id AS point_id_119, t0.story_id AS story_id_120, t0.inner_point_id AS inner_point_id_121 FROM place t0 LEFT JOIN comment t33 ON t33.place_id = t0.id LEFT JOIN category t42 ON t0.category_id = t42.id LEFT JOIN category t58 ON t0.new_category_id = t58.id LEFT JOIN category t74 ON t0.category2_id = t74.id LEFT JOIN category t90 ON t0.category3_id = t90.id LEFT JOIN action_video t105 ON t105.place_id = t0.id WHERE t0.id = ?
Parameters: [0 => 3519]
|
4 | 1.17 ms |
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, t33.id AS id_34, t33.text AS text_35, t33.created_at AS created_at_36, t33.audio_path AS audio_path_37, t33.story_id AS story_id_38, t33.place_id AS place_id_39, t33.user_id AS user_id_40, t0.category_id AS category_id_41, t42.name AS name_43, t42.description AS description_44, t42.is_menu AS is_menu_45, t42.is_menu_web AS is_menu_web_46, t42.is_menu_app AS is_menu_app_47, t42.is_menu_vr AS is_menu_vr_48, t42.included_by_default_in_web AS included_by_default_in_web_49, t42.included_by_default_in_app AS included_by_default_in_app_50, t42.included_by_default_in_vr AS included_by_default_in_vr_51, t42.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_52, t42.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_53, t42.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_54, t42.id AS id_55, t42.parent_category_id AS parent_category_id_56, t0.new_category_id AS new_category_id_57, t58.name AS name_59, t58.description AS description_60, t58.is_menu AS is_menu_61, t58.is_menu_web AS is_menu_web_62, t58.is_menu_app AS is_menu_app_63, t58.is_menu_vr AS is_menu_vr_64, t58.included_by_default_in_web AS included_by_default_in_web_65, t58.included_by_default_in_app AS included_by_default_in_app_66, t58.included_by_default_in_vr AS included_by_default_in_vr_67, t58.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_68, t58.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_69, t58.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_70, t58.id AS id_71, t58.parent_category_id AS parent_category_id_72, t0.category2_id AS category2_id_73, t74.name AS name_75, t74.description AS description_76, t74.is_menu AS is_menu_77, t74.is_menu_web AS is_menu_web_78, t74.is_menu_app AS is_menu_app_79, t74.is_menu_vr AS is_menu_vr_80, t74.included_by_default_in_web AS included_by_default_in_web_81, t74.included_by_default_in_app AS included_by_default_in_app_82, t74.included_by_default_in_vr AS included_by_default_in_vr_83, t74.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_84, t74.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_85, t74.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_86, t74.id AS id_87, t74.parent_category_id AS parent_category_id_88, t0.category3_id AS category3_id_89, t90.name AS name_91, t90.description AS description_92, t90.is_menu AS is_menu_93, t90.is_menu_web AS is_menu_web_94, t90.is_menu_app AS is_menu_app_95, t90.is_menu_vr AS is_menu_vr_96, t90.included_by_default_in_web AS included_by_default_in_web_97, t90.included_by_default_in_app AS included_by_default_in_app_98, t90.included_by_default_in_vr AS included_by_default_in_vr_99, t90.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_100, t90.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_101, t90.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_102, t90.id AS id_103, t90.parent_category_id AS parent_category_id_104, t105.id AS id_106, t105.first_fly_through_video AS first_fly_through_video_107, t105.second_fly_through_video AS second_fly_through_video_108, t105.first_walk_through_video AS first_walk_through_video_109, t105.second_walk_through_video AS second_walk_through_video_110, t105.walk_through_thumbnail AS walk_through_thumbnail_111, t105.fly_through_thumbnail AS fly_through_thumbnail_112, t105.walk_through_view_angle AS walk_through_view_angle_113, t105.fly_through_view_angle AS fly_through_view_angle_114, t105.city_id AS city_id_115, t105.place_id AS place_id_116, t0.second_point_id AS second_point_id_117, t0.third_point_id AS third_point_id_118, t0.point_id AS point_id_119, t0.story_id AS story_id_120, t0.inner_point_id AS inner_point_id_121 FROM place t0 LEFT JOIN comment t33 ON t33.place_id = t0.id LEFT JOIN category t42 ON t0.category_id = t42.id LEFT JOIN category t58 ON t0.new_category_id = t58.id LEFT JOIN category t74 ON t0.category2_id = t74.id LEFT JOIN category t90 ON t0.category3_id = t90.id LEFT JOIN action_video t105 ON t105.place_id = t0.id WHERE t0.id = ?
Parameters: [0 => 3491]
|
5 | 1.07 ms |
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 = ?
Parameters: [0 => 974]
|
6 | 0.94 ms |
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 = ?
Parameters: [0 => 2561]
|
7 | 0.78 ms |
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 = ?
Parameters: [0 => 2562]
|
8 | 0.82 ms |
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 = ?
Parameters: [0 => 2563]
|
9 | 0.72 ms |
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 = ?
Parameters: [0 => 2564]
|
10 | 0.68 ms |
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 = ?
Parameters: [0 => 2565]
|
11 | 0.71 ms |
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 = ?
Parameters: [0 => 2566]
|
12 | 0.73 ms |
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 = ?
Parameters: [0 => 2567]
|
13 | 0.75 ms |
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 = ?
Parameters: [0 => 2568]
|
14 | 0.71 ms |
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 = ?
Parameters: [0 => 3434]
|
15 | 0.68 ms |
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 = ?
Parameters: [0 => 3435]
|
16 | 0.69 ms |
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 = ?
Parameters: [0 => 3436]
|
17 | 0.65 ms |
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 = ?
Parameters: [0 => 3437]
|
18 | 0.66 ms |
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 = ?
Parameters: [0 => 4226]
|
19 | 0.71 ms |
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 = ?
Parameters: [0 => 4227]
|
20 | 0.69 ms |
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 = ?
Parameters: [0 => 4228]
|
21 | 0.69 ms |
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 = ?
Parameters: [0 => 4229]
|
22 | 0.73 ms |
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 = ?
Parameters: [0 => 4230]
|
23 | 0.75 ms |
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 = ?
Parameters: [0 => 4231]
|
24 | 0.68 ms |
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 = ?
Parameters: [0 => 4232]
|
25 | 0.67 ms |
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 = ?
Parameters: [0 => 4233]
|
26 | 0.72 ms |
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 = ?
Parameters: [0 => 4234]
|
27 | 0.93 ms |
SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = ? LIMIT 1
Parameters: [0 => site_title]
|
28 | 0.76 ms |
SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = ? LIMIT 1
Parameters: [0 => google_tag_manager_head]
|
29 | 0.69 ms |
SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = ? LIMIT 1
Parameters: [0 => google_tag_manager_head]
|
30 | 0.69 ms |
SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = ? LIMIT 1
Parameters: [0 => google_tag_manager_body]
|
31 | 0.65 ms |
SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = ? LIMIT 1
Parameters: [0 => google_tag_manager_body]
|
32 | 0.77 ms |
SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = ? LIMIT 1
Parameters: [0 => Become a host]
|
33 | 0.74 ms |
SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = ? LIMIT 1
Parameters: [0 => copyright_text]
|
34 | 1.65 ms |
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.position ASC
Parameters: [0 => 1]
|
35 | 1.31 ms |
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.position ASC
Parameters: [0 => 1]
|
36 | 1.28 ms |
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.position ASC
Parameters: [0 => 1]
|
37 | 1.08 ms |
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.position ASC
Parameters: [0 => 1]
|
38 | 1.15 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.content AS content_5, t0.url AS url_6, t0.tags AS tags_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.published AS published_10, t0.featured AS featured_11, t0.published_at AS published_at_12, t0.image AS image_13, t0.views AS views_14, t0.author_id AS author_id_15 FROM post t0 WHERE t0.published = ? ORDER BY t0.created_at DESC LIMIT 3 OFFSET 0
Parameters: [0 => 1]
|
39 | 1.23 ms |
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
Parameters: [0 => 1]
|
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.
Entities Mapping
Class | Mapping errors |
---|---|
FOS\UserBundle\Entity\User | No errors. |
DemoBakery\MainBundle\Entity\User | No errors. |
DemoBakery\MainBundle\Entity\Experience | No errors. |
DemoBakery\MainBundle\Entity\ExperienceProvider | No errors. |
DemoBakery\MainBundle\Entity\ExperienceTour | No errors. |
DemoBakery\MainBundle\Entity\TourVideo | No errors. |
DemoBakery\MainBundle\Entity\Category | No errors. |
DemoBakery\MainBundle\Entity\City | No errors. |
DemoBakery\MainBundle\Entity\Booking | No errors. |
DemoBakery\MainBundle\Entity\LiveTour | No errors. |
DemoBakery\MainBundle\Entity\Place | No errors. |
DemoBakery\MainBundle\Entity\Story | No errors. |
DemoBakery\MainBundle\Entity\ExperienceCategory | No errors. |
DemoBakery\MainBundle\Entity\HomepageContent | No errors. |
DemoBakery\MainBundle\Entity\Portal | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation | No errors. |
DemoBakery\MainBundle\Entity\Translations\CategoryTranslation | No errors. |
DemoBakery\MainBundle\Entity\Comment | No errors. |
DemoBakery\MainBundle\Entity\ActionVideo | No errors. |
DemoBakery\MainBundle\Entity\Point | No errors. |
DemoBakery\MainBundle\Entity\Pictures | No errors. |
DemoBakery\MainBundle\Entity\FavoritePlace | No errors. |
DemoBakery\MainBundle\Entity\TourSteps | No errors. |
DemoBakery\MainBundle\Entity\TourAgency | No errors. |
DemoBakery\MainBundle\Entity\LiveTourPlace | No errors. |
DemoBakery\MainBundle\Entity\LiveTourParticipant | No errors. |
DemoBakery\MainBundle\Entity\Review | No errors. |
DemoBakery\MainBundle\Entity\Dictionary | No errors. |
DemoBakery\MainBundle\Entity\Translations\DictionaryTranslation | No errors. |
DemoBakery\MainBundle\Entity\Weather | No errors. |
DemoBakery\MainBundle\Entity\Continent | No errors. |
DemoBakery\MainBundle\Entity\VoiceConfiguration | No errors. |
DemoBakery\MainBundle\Entity\Country | No errors. |
DemoBakery\MainBundle\Entity\AgencyExperience | No errors. |
DemoBakery\MainBundle\Entity\Tour | No errors. |
DemoBakery\MainBundle\Entity\Translations\CityTranslation | No errors. |
DemoBakery\BlogBundle\Entity\Post | No errors. |