Query Metrics
7
Database Queries
6
Different statements
4.22 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.73 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.path AS path_3 FROM page_template t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
"page/news_page.html.twig"
]
|
2 | 1.32 ms |
SELECT DISTINCT s0_.id AS id_0, s0_.uri AS uri_1, s0_.type AS type_2, s0_.photo AS photo_3, s0_.photo_wide AS photo_wide_4, s0_.photo_background AS photo_background_5, s0_.photo_avatar AS photo_avatar_6, s0_.premium AS premium_7, s0_.font AS font_8, s0_.short_description AS short_description_9, s0_.rating AS rating_10, s0_.rating_vote AS rating_vote_11, s0_.position AS position_12, s0_.in_top_banner AS in_top_banner_13, s0_.created AS created_14, s0_.is_new_face AS is_new_face_15, s0_.description AS description_16, s0_.enabled AS enabled_17, s0_.keywords AS keywords_18, s0_.payment_receiver AS payment_receiver_19, s0_.payment_iban AS payment_iban_20, s0_.payment_ipn AS payment_ipn_21, s0_.payment_bank AS payment_bank_22, s0_.payment_bic AS payment_bic_23, s0_.payment_okpo AS payment_okpo_24, s0_.person_payment_phone AS person_payment_phone_25, s0_.person_payment_card AS person_payment_card_26, s0_.person_payment_bank AS person_payment_bank_27, s0_.premium_detail AS premium_detail_28, s0_.top_banner_expired AS top_banner_expired_29, s0_.premium_expired AS premium_expired_30, s0_.tc_login AS tc_login_31, s0_.tc_pass AS tc_pass_32, s0_.status AS status_33, s0_.promo_video_id AS promo_video_id_34, s0_.user_id AS user_id_35 FROM speaker s0_ LEFT JOIN speaker_category s2_ ON s0_.id = s2_.speaker_id LEFT JOIN category c1_ ON c1_.id = s2_.category_id WHERE s0_.enabled = ? AND s0_.status = ? ORDER BY s0_.top_banner_expired DESC, s0_.position ASC LIMIT 3
Parameters:
[ 1 1 ] |
3 | 0.77 ms |
SELECT COUNT(s0_.id) AS sclr_0 FROM speaker s0_ WHERE s0_.id IN (SELECT DISTINCT s1_.id FROM speaker s1_ LEFT JOIN speaker_category s3_ ON s1_.id = s3_.speaker_id LEFT JOIN category c2_ ON c2_.id = s3_.category_id WHERE s1_.enabled = ? AND s1_.status = ?)
Parameters:
[ 1 1 ] |
4 | 0.41 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.title AS title_1, p0_.uri AS uri_2, p0_.data AS data_3, p0_.updated AS updated_4, p0_.published AS published_5, p0_.created AS created_6, p0_.published_date AS published_date_7, p0_.meta AS meta_8, p0_.menu_title AS menu_title_9, p0_.menu_position AS menu_position_10, p0_.extra_fields AS extra_fields_11, p0_.template_id AS template_id_12 FROM PAGE p0_ WHERE p0_.template_id = ? AND p0_.published = ? ORDER BY p0_.published_date DESC LIMIT 3
Parameters:
[ 2 1 ] |
5 | 0.29 ms |
SELECT COUNT(p0_.id) AS sclr_0 FROM PAGE p0_ WHERE p0_.template_id = ? AND p0_.published = ?
Parameters:
[ 2 1 ] |
6 | 0.27 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.path AS path_3 FROM page_template t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
"page/static_page.html.twig"
]
|
7 | 0.43 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.uri AS uri_3, t0.data AS data_4, t0.updated AS updated_5, t0.published AS published_6, t0.created AS created_7, t0.published_date AS published_date_8, t0.meta AS meta_9, t0.menu_title AS menu_title_10, t0.menu_position AS menu_position_11, t0.extra_fields AS extra_fields_12, t0.template_id AS template_id_13 FROM PAGE t0 WHERE t0.template_id = ? AND t0.published = ? ORDER BY t0.menu_position ASC
Parameters:
[ 1 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 |
---|---|
App\Entity\Speaker | No errors. |
App\Entity\PageTemplate | No errors. |
App\Entity\Page | No errors. |
App\Entity\Category | No errors. |
App\Entity\MediaObject | No errors. |
App\Entity\User |
|
App\Entity\Badge | No errors. |
App\Entity\SpeakerLink | No errors. |
App\Entity\Review | No errors. |
App\Entity\SpeakerCourse | No errors. |
App\Entity\SpeakerConsultation | No errors. |
App\Entity\PromoCode | No errors. |
App\Entity\SpeakerCharity | No errors. |