https://saco-preprod.kwantic.fr/faq-footer

Query Metrics

8 Database Queries
8 Different statements
12.99 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.