Query Metrics
3
Database Queries
3
Different statements
6.45 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.96 ms (45.89%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.validation_token AS validation_token_6, t0.validation_token_expire_at AS validation_token_expire_at_7, t0.api_token AS api_token_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.country AS country_11, t0.address AS address_12, t0.city AS city_13, t0.postal_code AS postal_code_14, t0.phone AS phone_15, t0.stripe_customer_id AS stripe_customer_id_16, t0.trackerid AS trackerid_17, t0.mailchimp_synced AS mailchimp_synced_18, t0.mailchimp_exists AS mailchimp_exists_19, t0.newsletter_daily AS newsletter_daily_20, t0.newsletter_weekly AS newsletter_weekly_21, t0.newsletter_quaterly AS newsletter_quaterly_22 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
1
]
|
1.96 ms (30.36%) |
1 |
SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.title AS title_2, a0_.content AS content_3, a0_.alt AS alt_4, a0_.header_video AS header_video_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.status AS status_8, a0_.broadcast_at AS broadcast_at_9, m1_.name AS name_10, m1_.description AS description_11, m1_.enabled AS enabled_12, m1_.provider_name AS provider_name_13, m1_.provider_status AS provider_status_14, m1_.provider_reference AS provider_reference_15, m1_.provider_metadata AS provider_metadata_16, m1_.width AS width_17, m1_.height AS height_18, m1_.length AS length_19, m1_.content_type AS content_type_20, m1_.content_size AS content_size_21, m1_.copyright AS copyright_22, m1_.author_name AS author_name_23, m1_.context AS context_24, m1_.cdn_is_flushable AS cdn_is_flushable_25, m1_.cdn_flush_identifier AS cdn_flush_identifier_26, m1_.cdn_flush_at AS cdn_flush_at_27, m1_.cdn_status AS cdn_status_28, m1_.updated_at AS updated_at_29, m1_.created_at AS created_at_30, m1_.id AS id_31, a0_.header_image_id AS header_image_id_32, a0_.user_id AS user_id_33 FROM article a0_ LEFT JOIN media__media m1_ ON a0_.header_image_id = m1_.id WHERE a0_.status = ? AND (a0_.broadcast_at IS NULL OR a0_.broadcast_at <= CURRENT_TIMESTAMP) ORDER BY a0_.created_at DESC LIMIT 15
Parameters:
[
1
]
|
1.53 ms (23.75%) |
1 |
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.value AS value_3 FROM parameter t0 WHERE t0.`key` = ? LIMIT 1
Parameters:
[
"currentVideoProvider"
]
|
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 |
---|---|
App\Entity\Article | No errors. |
Sonata\MediaBundle\Entity\BaseMedia | No errors. |
App\Entity\SonataMediaMedia | No errors. |
App\Entity\User | No errors. |
App\Entity\Tag | No errors. |
Sonata\MediaBundle\Entity\BaseGalleryItem | No errors. |
App\Entity\SonataMediaGalleryItem | No errors. |
App\Entity\Parameter | No errors. |
App\Entity\Donation | No errors. |
App\Entity\UserPlaylist | No errors. |
App\Entity\UserLike | No errors. |