Query Metrics
8
Database Queries
8
Different statements
12.99 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.51 ms (27.01%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.slug AS slug_4, t0.image_deroulement AS image_deroulement_5, t0.image AS image_6, t0.description_deroulement AS description_deroulement_7, t0.price AS price_8, t0.category_id AS category_id_9, t0.coach_id AS coach_id_10 FROM coaching_session t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"formation-saco-hair-x-partoo"
]
|
2.96 ms (22.76%) |
1 |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.slug AS slug_5, t0.password AS password_6, t0.activation_key AS activation_key_7, t0.status AS status_8, t0.roles AS roles_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.stripe_customer_id AS stripe_customer_id_12, t0.is_accept_newsletter AS is_accept_newsletter_13, t0.is_accept_promos AS is_accept_promos_14, t15.id AS id_16, t15.description AS description_17, t15.picture AS picture_18, t15.hour_price AS hour_price_19, t15.is_referent_coach AS is_referent_coach_20, t15.utilisateur_id AS utilisateur_id_21, t22.id AS id_23, t22.stripe_subscription_id AS stripe_subscription_id_24, t22.stripe_plan_id AS stripe_plan_id_25, t22.stripe_source_id AS stripe_source_id_26, t22.type AS type_27, t22.created_at AS created_at_28, t22.ends_at AS ends_at_29, t22.canceled_at AS canceled_at_30, t22.attached_account_limit AS attached_account_limit_31, t22.attached_account AS attached_account_32, t22.attached_account_code AS attached_account_code_33, t22.is_add_option AS is_add_option_34, t22.code_promos AS code_promos_35, t22.shop_code_promos AS shop_code_promos_36, t22.modality AS modality_37, t22.customer_stripe_id AS customer_stripe_id_38, t22.transaction_stripe_id AS transaction_stripe_id_39, t22.utilisateur_id AS utilisateur_id_40 FROM users t0 LEFT JOIN coach t15 ON t15.utilisateur_id = t0.id LEFT JOIN subscription t22 ON t22.utilisateur_id = t0.id WHERE t0.id = ?
Parameters:
[
106
]
|
1.44 ms (11.08%) |
1 |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.slug AS slug_3, c0_.image_deroulement AS image_deroulement_4, c0_.image AS image_5, c0_.description_deroulement AS description_deroulement_6, c0_.price AS price_7, c0_.category_id AS category_id_8, c0_.coach_id AS coach_id_9 FROM coaching_session c0_ WHERE c0_.slug <> ? AND c0_.category_id = ? LIMIT 3
Parameters:
[ "formation-saco-hair-x-partoo" 94 ] |
1.30 ms (10.00%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.excerpt AS excerpt_5, t0.status AS status_6, t0.publish_at AS publish_at_7, t0.type AS type_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image AS image_11, t0.video AS video_12, t0.author_id AS author_id_13, t0.category_id AS category_id_14 FROM post t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"nos-formations-coaching"
]
|
1.16 ms (8.93%) |
1 |
SELECT t0.id AS id_1, t0.question AS question_2, t0.response AS response_3, t0.show_in_footer AS show_in_footer_4, t0.ordre AS ordre_5 FROM faq t0 WHERE t0.show_in_footer = ? ORDER BY t0.ordre ASC
Parameters:
[
1
]
|
1.06 ms (8.18%) |
1 |
SELECT t0.id AS id_1, t0.description AS description_2, t0.picture AS picture_3, t0.hour_price AS hour_price_4, t0.is_referent_coach AS is_referent_coach_5, t0.utilisateur_id AS utilisateur_id_6 FROM coach t0 WHERE t0.id = ?
Parameters:
[
22
]
|
0.91 ms (6.97%) |
1 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.slug AS slug_4, t0.post_type AS post_type_5, t0.parent_id AS parent_id_6 FROM post_category t0 WHERE t0.id = ?
Parameters:
[
94
]
|
0.66 ms (5.06%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.slug AS slug_4, t0.image AS image_5, t0.post_id AS post_id_6 FROM page_bloc t0 WHERE t0.post_id = ?
Parameters:
[
73
]
|
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\CoachingSession | No errors. |
App\Entity\PostCategory | No errors. |
App\Entity\Coach | No errors. |
App\Entity\Post | No errors. |
App\Entity\User | No errors. |
App\Entity\PostMeta | No errors. |
App\Entity\PageBloc | No errors. |
App\Entity\CoachPack | No errors. |
App\Entity\Reservation | No errors. |
App\Entity\Subscription | No errors. |
App\Entity\Faq | No errors. |