https://360stories.com/app_dev.php/blog?p=%27

Query Metrics

11 Database Queries
6 Different statements
10.73 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.09 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.featured = ? ORDER BY t0.created_at DESC LIMIT 1
Parameters: [0 => 1, 1 => 1]
2 2.35 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 10 OFFSET 0
Parameters: [0 => 1]
3 1.05 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.views DESC LIMIT 4 OFFSET 0
Parameters: [0 => 1]
4 0.85 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 1
Parameters: [0 => 1]
5 0.78 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]
6 0.72 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_head]
8 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]
9 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]
10 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 => Become a host]
11 1.11 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]

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\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\City No errors.
DemoBakery\MainBundle\Entity\Plan No errors.
DemoBakery\MainBundle\Entity\Story 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.