https://360stories.com/app_dev.php/blog/360stories-top-picks-three-best-360-cameras-for-travel

Query Metrics

22 Database Queries
13 Different statements
24.18 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.84 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.url = ? LIMIT 1
Parameters: [0 => 360stories-top-picks-three-best-360-cameras-for-travel]
2 0.65 ms
"START TRANSACTION"
Parameters: []
3 0.72 ms
UPDATE post SET views = ? WHERE id = ?
Parameters: [0 => 4536, 1 => 6]
4 5.25 ms
"COMMIT"
Parameters: []
5 1.54 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 = ? AND t0.author_id = ? ORDER BY t0.views DESC LIMIT 4 OFFSET 0
Parameters: [0 => 1, 1 => 7716]
6 0.97 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 4 OFFSET 0
Parameters: [0 => 1]
7 0.79 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.meta_title AS meta_title_2, p0_.meta_description AS meta_description_3, p0_.content AS content_4, p0_.url AS url_5, p0_.tags AS tags_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.published AS published_9, p0_.featured AS featured_10, p0_.published_at AS published_at_11, p0_.image AS image_12, p0_.views AS views_13, p0_.author_id AS author_id_14 FROM post p0_ WHERE p0_.id > ? ORDER BY p0_.id ASC LIMIT 1
Parameters: [0 => 6]
8 0.75 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.meta_title AS meta_title_2, p0_.meta_description AS meta_description_3, p0_.content AS content_4, p0_.url AS url_5, p0_.tags AS tags_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.published AS published_9, p0_.featured AS featured_10, p0_.published_at AS published_at_11, p0_.image AS image_12, p0_.views AS views_13, p0_.author_id AS author_id_14 FROM post p0_ WHERE p0_.id < ? ORDER BY p0_.id DESC LIMIT 1
Parameters: [0 => 6]
9 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 => site_title]
10 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]
11 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_head]
12 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]
13 0.87 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]
14 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 => Become a host]
15 1.01 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.locked AS locked_9, t0.expired AS expired_10, t0.expires_at AS expires_at_11, t0.confirmation_token AS confirmation_token_12, t0.password_requested_at AS password_requested_at_13, t0.roles AS roles_14, t0.credentials_expired AS credentials_expired_15, t0.credentials_expire_at AS credentials_expire_at_16, t0.id AS id_17, t0.full_name AS full_name_18, t0.city2 AS city2_19, t0.first_name AS first_name_20, t0.last_name AS last_name_21, t0.company AS company_22, t0.image AS image_23, t0.video_quality AS video_quality_24, t0.updated_at AS updated_at_25, t0.created_at AS created_at_26, t0.biography AS biography_27, t0.vr_pin AS vr_pin_28, t0.vr_pin_generated_at AS vr_pin_generated_at_29, t0.location AS location_30, t0.work AS work_31, t0.website AS website_32, t0.headline AS headline_33, t0.company_name AS company_name_34, t0.phone_numbers AS phone_numbers_35, t0.phone AS phone_36, t0.address AS address_37, t0.contact_name AS contact_name_38, t0.default_playback_sound AS default_playback_sound_39, t0.is_paid AS is_paid_40, t0.is_email_subscribed AS is_email_subscribed_41, t0.is_email_verified AS is_email_verified_42, t0.is_profile_public AS is_profile_public_43, t0.is_business AS is_business_44, t0.twitter AS twitter_45, t0.utm_source AS utm_source_46, t0.utm_medium AS utm_medium_47, t0.linkedin AS linkedin_48, t0.facebook AS facebook_49, t0.fb_data AS fb_data_50, t0.partner_data AS partner_data_51, t0.languages AS languages_52, t0.payment_data AS payment_data_53, t0.billing_address AS billing_address_54, t0.registration_source AS registration_source_55, t0.unsubscription_token AS unsubscription_token_56, t0.bonus_minutes AS bonus_minutes_57, t0.free_minutes AS free_minutes_58, t0.booking_commission AS booking_commission_59, t0.facebook_id AS facebook_id_60, t0.facebook_access_token AS facebook_access_token_61, t0.google_id AS google_id_62, t0.google_access_token AS google_access_token_63, t0.allow_game_access AS allow_game_access_64, t0.allow_broadcast_experiences_access AS allow_broadcast_experiences_access_65, t66.id AS id_67, t66.company_name AS company_name_68, t66.logo AS logo_69, t66.address AS address_70, t66.email AS email_71, t66.description AS description_72, t66.company_website AS company_website_73, t66.facebook_link AS facebook_link_74, t66.twitter_link AS twitter_link_75, t66.instagram_link AS instagram_link_76, t66.customer_contacts AS customer_contacts_77, t66.city_id AS city_id_78, t66.user_id AS user_id_79, t0.city_id AS city_id_80, t0.plan_id AS plan_id_81 FROM user t0 LEFT JOIN tour_agency t66 ON t66.user_id = t0.id WHERE t0.id = ?
Parameters: [0 => 7716]
16 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 => copyright_text]
17 1.10 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]
18 1.13 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]
19 1.13 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]
20 1.09 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.02 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]
22 1.10 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\BlogBundle\Entity\Post No errors.
DemoBakery\MainBundle\Entity\City No errors.
DemoBakery\MainBundle\Entity\Plan 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\Place No errors.
DemoBakery\MainBundle\Entity\Category No errors.
DemoBakery\MainBundle\Entity\Story No errors.
DemoBakery\MainBundle\Entity\Dictionary No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation No errors.
DemoBakery\MainBundle\Entity\Translations\DictionaryTranslation No errors.
DemoBakery\MainBundle\Entity\TourAgency No errors.
DemoBakery\MainBundle\Entity\Experience No errors.
DemoBakery\MainBundle\Entity\AgencyExperience No errors.
DemoBakery\MainBundle\Entity\Booking No errors.
DemoBakery\MainBundle\Entity\Subscription No errors.
DemoBakery\MainBundle\Entity\Invoice No errors.
DemoBakery\MainBundle\Entity\PartnerUpload No errors.
DemoBakery\MainBundle\Entity\Tour No errors.
DemoBakery\MainBundle\Entity\UserApiTokens No errors.
DemoBakery\MainBundle\Entity\FavoritePlace No errors.
DemoBakery\MainBundle\Entity\LiveTour No errors.
DemoBakery\MainBundle\Entity\ActionVideo No errors.
DemoBakery\MainBundle\Entity\Translations\CityTranslation No errors.
DemoBakery\MainBundle\Entity\HomepageContent No errors.