https://zv.slapp.me/praticien/slapp-webmaster

Query Metrics

14 Database Queries
12 Different statements
46.51 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.88 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:
[
  "slapp-webmaster"
]
2 24.50 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:
[
  1
]
3 9.52 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:
[
  1
  "2025-12-06 05:22:50"
]
4 4.34 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:
[
  1
]
5 0.21 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:
[
  1
]
6 0.26 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:
[
  1
]
7 0.53 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:
[
  1
]
8 0.18 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:
[
  1
]
9 0.16 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:
[
  1
]
10 1.29 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:
[
  1
]
11 0.34 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:
[
  1
]
12 1.24 ms
SELECT t0.id AS id_1, t0.last_name AS last_name_2, t0.first_name AS first_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.zip_code AS zip_code_6, t0.city AS city_7, t0.country AS country_8, t0.phone AS phone_9, t0.concours_ete_2024 AS concours_ete_2024_10, t11.id AS id_12, t11.email AS email_13, t11.password AS password_14, t11.salt AS salt_15, t11.enabled AS enabled_16, t11.roles AS roles_17, t11.registration_date AS registration_date_18, t11.last_login AS last_login_19, t11.password_request_date AS password_request_date_20, t11.password_request AS password_request_21, t11.stripe_customer_id AS stripe_customer_id_22, t11.user_id AS user_id_23, t11.partner_id AS partner_id_24 FROM user t0 LEFT JOIN account t11 ON t11.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  19
]
13 2.64 ms
SELECT t0.id AS id_1, t0.last_name AS last_name_2, t0.first_name AS first_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.zip_code AS zip_code_6, t0.city AS city_7, t0.country AS country_8, t0.phone AS phone_9, t0.concours_ete_2024 AS concours_ete_2024_10, t11.id AS id_12, t11.email AS email_13, t11.password AS password_14, t11.salt AS salt_15, t11.enabled AS enabled_16, t11.roles AS roles_17, t11.registration_date AS registration_date_18, t11.last_login AS last_login_19, t11.password_request_date AS password_request_date_20, t11.password_request AS password_request_21, t11.stripe_customer_id AS stripe_customer_id_22, t11.user_id AS user_id_23, t11.partner_id AS partner_id_24 FROM user t0 LEFT JOIN account t11 ON t11.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  17
]
14 0.40 ms
SELECT t0.id AS id_1, t0.last_name AS last_name_2, t0.first_name AS first_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.zip_code AS zip_code_6, t0.city AS city_7, t0.country AS country_8, t0.phone AS phone_9, t0.concours_ete_2024 AS concours_ete_2024_10, t11.id AS id_12, t11.email AS email_13, t11.password AS password_14, t11.salt AS salt_15, t11.enabled AS enabled_16, t11.roles AS roles_17, t11.registration_date AS registration_date_18, t11.last_login AS last_login_19, t11.password_request_date AS password_request_date_20, t11.password_request AS password_request_21, t11.stripe_customer_id AS stripe_customer_id_22, t11.user_id AS user_id_23, t11.partner_id AS partner_id_24 FROM user t0 LEFT JOIN account t11 ON t11.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  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.