Query Metrics
22
Database Queries
13
Different statements
24.18 ms
Query time
0
Invalid entities
Queries
#▲ | 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. |