Query Metrics
25
Database Queries
10
Different statements
21.74 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.98 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.name = ? LIMIT 1
Parameters: [0 => armenia]
|
2 | 1.28 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, 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
Parameters: [0 => beeline-startup-incubator, 1 => 1, 2 => 1]
|
3 | 0.71 ms |
SELECT t0.id AS id_1 FROM homepage_content t0 LIMIT 1
Parameters: []
|
4 | 0.73 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]
|
5 | 0.68 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]
|
6 | 0.79 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]
|
7 | 0.64 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]
|
8 | 0.67 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]
|
9 | 0.71 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]
|
10 | 1.22 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 INNER JOIN homepage_content_error_stories ON t0.id = homepage_content_error_stories.place_id WHERE homepage_content_error_stories.homepage_content_id = ?
Parameters: [0 => 1]
|
11 | 0.92 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.id = ?
Parameters: [0 => 2]
|
12 | 0.78 ms |
SELECT t0.path AS path_1, t0.id AS id_2, t0.place_position AS place_position_3, t0.duration_in_slide_show AS duration_in_slide_show_4, t0.story_id AS story_id_5, t0.place_id AS place_id_6 FROM pictures t0 WHERE t0.place_id = ? ORDER BY t0.place_position ASC
Parameters: [0 => 2925]
|
13 | 0.80 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.id = ?
Parameters: [0 => 7]
|
14 | 0.71 ms |
SELECT t0.path AS path_1, t0.id AS id_2, t0.place_position AS place_position_3, t0.duration_in_slide_show AS duration_in_slide_show_4, t0.story_id AS story_id_5, t0.place_id AS place_id_6 FROM pictures t0 WHERE t0.place_id = ? ORDER BY t0.place_position ASC
Parameters: [0 => 3135]
|
15 | 0.75 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.id = ?
Parameters: [0 => 10]
|
16 | 0.73 ms |
SELECT t0.path AS path_1, t0.id AS id_2, t0.place_position AS place_position_3, t0.duration_in_slide_show AS duration_in_slide_show_4, t0.story_id AS story_id_5, t0.place_id AS place_id_6 FROM pictures t0 WHERE t0.place_id = ? ORDER BY t0.place_position ASC
Parameters: [0 => 3384]
|
17 | 0.82 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.id = ?
Parameters: [0 => 12]
|
18 | 0.70 ms |
SELECT t0.path AS path_1, t0.id AS id_2, t0.place_position AS place_position_3, t0.duration_in_slide_show AS duration_in_slide_show_4, t0.story_id AS story_id_5, t0.place_id AS place_id_6 FROM pictures t0 WHERE t0.place_id = ? ORDER BY t0.place_position ASC
Parameters: [0 => 3519]
|
19 | 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 => copyright_text]
|
20 | 1.12 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]
|
21 | 1.06 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]
|
22 | 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]
|
23 | 1.04 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]
|
24 | 0.92 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]
|
25 | 1.22 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\City | No errors. |
DemoBakery\MainBundle\Entity\Point | 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\Story | No errors. |
DemoBakery\MainBundle\Entity\Place | No errors. |
DemoBakery\MainBundle\Entity\ActionVideo | No errors. |
DemoBakery\MainBundle\Entity\Experience | No errors. |
DemoBakery\MainBundle\Entity\AgencyExperience | No errors. |
DemoBakery\MainBundle\Entity\Tour | No errors. |
DemoBakery\MainBundle\Entity\TourAgency | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation | No errors. |
DemoBakery\MainBundle\Entity\Translations\CityTranslation | No errors. |
DemoBakery\MainBundle\Entity\HomepageContent | No errors. |
DemoBakery\MainBundle\Entity\Category | No errors. |
DemoBakery\MainBundle\Entity\Dictionary | No errors. |
DemoBakery\MainBundle\Entity\Translations\DictionaryTranslation | No errors. |
DemoBakery\MainBundle\Entity\Comment | No errors. |
DemoBakery\MainBundle\Entity\Pictures | No errors. |
DemoBakery\MainBundle\Entity\FavoritePlace | No errors. |
DemoBakery\MainBundle\Entity\TourSteps | No errors. |
DemoBakery\MainBundle\Entity\LiveTourPlace | No errors. |
DemoBakery\MainBundle\Entity\Translations\CategoryTranslation | No errors. |
DemoBakery\BlogBundle\Entity\Post | No errors. |