Query Metrics
11
Database Queries
11
Different statements
94.34 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 15.87 ms |
SELECT t0.id AS id_1, t0.last_name AS last_name_2, t0.first_name AS first_name_3, t0.public_email AS public_email_4, t0.phone AS phone_5, t0.avatar AS avatar_6, t0.slogan AS slogan_7, t0.address_name AS address_name_8, t0.address AS address_9, t0.address2 AS address2_10, t0.zip_code AS zip_code_11, t0.city AS city_12, t0.country AS country_13, t0.address_coord_y AS address_coord_y_14, t0.address_coord_x AS address_coord_x_15, t0.siret AS siret_16, t0.legal_form AS legal_form_17, t0.assurance_name AS assurance_name_18, t0.isCoach AS isCoach_19, t0.isPractitioner AS isPractitioner_20, t0.allow_teleconsultation AS allow_teleconsultation_21, t0.allow_office AS allow_office_22, t0.allow_home_visit AS allow_home_visit_23, t0.nb_days_before_reservation AS nb_days_before_reservation_24, t0.nb_days_available AS nb_days_available_25, t0.stripe_account_id AS stripe_account_id_26, t0.stripe_account_verified AS stripe_account_verified_27, t0.stripe_charges_enabled AS stripe_charges_enabled_28, t0.stripe_payouts_enabled AS stripe_payouts_enabled_29, t0.subscription_discount AS subscription_discount_30, t0.subscription_discount_type AS subscription_discount_type_31, t0.subscription_discount_duration AS subscription_discount_duration_32, t0.validated_practitioner AS validated_practitioner_33, t0.validated_coach AS validated_coach_34, t0.slug AS slug_35, t0.google_calendar_status AS google_calendar_status_36, t0.partnership_code AS partnership_code_37, t0.monday AS monday_38, t0.sunday AS sunday_39, t0.wednesday AS wednesday_40, t0.partner_page_id AS partner_page_id_41, t0.thursday AS thursday_42, t0.friday AS friday_43, t0.saturday AS saturday_44, t0.tuesday AS tuesday_45, t46.id AS id_47, t46.email AS email_48, t46.password AS password_49, t46.salt AS salt_50, t46.enabled AS enabled_51, t46.roles AS roles_52, t46.registration_date AS registration_date_53, t46.last_login AS last_login_54, t46.password_request_date AS password_request_date_55, t46.password_request AS password_request_56, t46.stripe_customer_id AS stripe_customer_id_57, t46.user_id AS user_id_58, t46.partner_id AS partner_id_59 FROM partner t0 LEFT JOIN account t46 ON t46.partner_id = t0.id WHERE t0.slug = ? LIMIT 1
Parameters:
[
"gaby-jerome-1"
]
|
| 2 | 3.56 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.canceled AS canceled_5, t0.duration AS duration_6, t0.payment_type AS payment_type_7, t0.stripe_sub_id AS stripe_sub_id_8, t0.partner_id AS partner_id_9 FROM partner_subscription t0 WHERE t0.partner_id = ?
Parameters:
[
32
]
|
| 3 | 1.18 ms |
SELECT g0_.id AS id_0, g0_.title AS title_1, g0_.picture AS picture_2, g0_.start_date AS start_date_3, g0_.end_date AS end_date_4, g0_.description AS description_5, g0_.url AS url_6, g0_.price AS price_7, g0_.group_max AS group_max_8, g0_.location AS location_9, g0_.open AS open_10, g0_.partner_id AS partner_id_11 FROM group_session g0_ WHERE g0_.open = 1 AND g0_.partner_id = ? AND g0_.start_date > ? ORDER BY g0_.start_date ASC
Parameters:
[ 32 "2025-12-06 05:19:40" ] |
| 4 | 40.49 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.job AS job_3, t0.jobs AS jobs_4, t0.picture AS picture_5, t0.page_content AS page_content_6, t0.tags AS tags_7, t0.slug AS slug_8, t0.slug_job AS slug_job_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11 FROM speciality t0 INNER JOIN partner_has_speciality ON t0.id = partner_has_speciality.speciality_id WHERE partner_has_speciality.partner_id = ?
Parameters:
[
32
]
|
| 5 | 0.17 ms |
SELECT t0.id AS id_1, t0.note AS note_2, t0.opinion AS opinion_3, t0.created_at AS created_at_4, t0.partner_id AS partner_id_5, t0.user_id AS user_id_6 FROM partner_note t0 WHERE t0.partner_id = ?
Parameters:
[
32
]
|
| 6 | 0.15 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.price AS price_3, t0.discount AS discount_4, t0.duration AS duration_5, t0.enabled AS enabled_6, t0.is_coaching AS is_coaching_7, t0.first_reservation_only AS first_reservation_only_8, t0.second_reservation_only AS second_reservation_only_9, t0.partner_id AS partner_id_10, t0.history_service_id AS history_service_id_11 FROM service_delivery t0 WHERE t0.partner_id = ?
Parameters:
[
32
]
|
| 7 | 12.73 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.logo AS logo_3, t0.image1 AS image1_4, t0.image2 AS image2_5, t0.image3 AS image3_6, t0.image4 AS image4_7, t0.image5 AS image5_8, t0.image6 AS image6_9, t0.image7 AS image7_10, t0.image8 AS image8_11, t0.page_google AS page_google_12, t0.video_presentation AS video_presentation_13, t0.results_content AS results_content_14, t0.troubles_content AS troubles_content_15, t0.working_content AS working_content_16, t0.public_type_content AS public_type_content_17, t0.website AS website_18, t0.facebook_link AS facebook_link_19, t0.twitter_link AS twitter_link_20, t0.instagram_link AS instagram_link_21, t0.linkedin_link AS linkedin_link_22, t0.youtube_link AS youtube_link_23, t0.diploma_content AS diploma_content_24, t0.other_formations_content AS other_formations_content_25, t0.experience_content AS experience_content_26 FROM partner_page t0 WHERE t0.id = ?
Parameters:
[
26
]
|
| 8 | 18.34 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.picture AS picture_3, t0.page_content AS page_content_4, t0.tags AS tags_5, t0.slug AS slug_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8 FROM need t0 INNER JOIN partner_has_need ON t0.id = partner_has_need.need_id WHERE partner_has_need.partner_id = ?
Parameters:
[
32
]
|
| 9 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.address2 AS address2_4, t0.zip_code AS zip_code_5, t0.city AS city_6, t0.country AS country_7, t0.address_coord_y AS address_coord_y_8, t0.address_coord_x AS address_coord_x_9, t0.active AS active_10, t0.partner_id AS partner_id_11 FROM partner_secondary_location t0 WHERE t0.partner_id = ?
Parameters:
[
32
]
|
| 10 | 0.88 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.max_date AS max_date_3, t0.partner_page_id AS partner_page_id_4 FROM partner_page_promotion t0 WHERE t0.partner_page_id = ?
Parameters:
[
26
]
|
| 11 | 0.70 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.file AS file_4, t0.dates AS dates_5, t0.description AS description_6, t0.link AS link_7, t0.partner_page_id AS partner_page_id_8 FROM partner_page_event t0 WHERE t0.partner_page_id = ?
Parameters:
[
26
]
|
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\Partner | No errors. |
| App\Entity\DaySlot | No errors. |
| App\Entity\PartnerPage | No errors. |
| App\Entity\Account | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Speciality | No errors. |
| App\Entity\Need | No errors. |
| App\Entity\PartnerHasUser | No errors. |
| App\Entity\ServiceDelivery | No errors. |
| App\Entity\PartnerSubscription | No errors. |
| App\Entity\PartnerNote | No errors. |
| App\Entity\PartnerIcal | No errors. |
| App\Entity\PartnerSecondaryLocation | No errors. |
| App\Entity\GroupSession | No errors. |
| App\Entity\ServiceDeliveryPlace | No errors. |
| App\Entity\ServiceDeliveryHasPlace | No errors. |
| App\Entity\PartnerPagePromotion | No errors. |
| App\Entity\PartnerPageEvent | No errors. |