https://zv.slapp.me/praticiens/conseiller-en-bilan-de-competence

Query Metrics

21 Database Queries
10 Different statements
13.00 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.60 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 WHERE t0.slug_job = ? LIMIT 1
Parameters:
[
  "conseiller-en-bilan-de-competence"
]
2 1.61 ms
SELECT p0_.id AS id_0, p0_.last_name AS last_name_1, p0_.first_name AS first_name_2, p0_.public_email AS public_email_3, p0_.phone AS phone_4, p0_.avatar AS avatar_5, p0_.slogan AS slogan_6, p0_.address_name AS address_name_7, p0_.address AS address_8, p0_.address2 AS address2_9, p0_.zip_code AS zip_code_10, p0_.city AS city_11, p0_.country AS country_12, p0_.address_coord_y AS address_coord_y_13, p0_.address_coord_x AS address_coord_x_14, p0_.siret AS siret_15, p0_.legal_form AS legal_form_16, p0_.assurance_name AS assurance_name_17, p0_.isCoach AS isCoach_18, p0_.isPractitioner AS isPractitioner_19, p0_.allow_teleconsultation AS allow_teleconsultation_20, p0_.allow_office AS allow_office_21, p0_.allow_home_visit AS allow_home_visit_22, p0_.nb_days_before_reservation AS nb_days_before_reservation_23, p0_.nb_days_available AS nb_days_available_24, p0_.stripe_account_id AS stripe_account_id_25, p0_.stripe_account_verified AS stripe_account_verified_26, p0_.stripe_charges_enabled AS stripe_charges_enabled_27, p0_.stripe_payouts_enabled AS stripe_payouts_enabled_28, p0_.subscription_discount AS subscription_discount_29, p0_.subscription_discount_type AS subscription_discount_type_30, p0_.subscription_discount_duration AS subscription_discount_duration_31, p0_.validated_practitioner AS validated_practitioner_32, p0_.validated_coach AS validated_coach_33, p0_.slug AS slug_34, p0_.google_calendar_status AS google_calendar_status_35, p0_.partnership_code AS partnership_code_36, 0 AS sclr_37, p0_.monday AS monday_38, p0_.sunday AS sunday_39, p0_.wednesday AS wednesday_40, p0_.partner_page_id AS partner_page_id_41, p0_.thursday AS thursday_42, p0_.friday AS friday_43, p0_.saturday AS saturday_44, p0_.tuesday AS tuesday_45 FROM partner p0_ LEFT JOIN partner_has_need p2_ ON p0_.id = p2_.partner_id LEFT JOIN need n1_ ON n1_.id = p2_.need_id LEFT JOIN partner_has_speciality p4_ ON p0_.id = p4_.partner_id LEFT JOIN speciality s3_ ON s3_.id = p4_.speciality_id LEFT JOIN partner_page p5_ ON p0_.partner_page_id = p5_.id WHERE p0_.isPractitioner = 1 AND ((p0_.last_name LIKE ? OR p0_.first_name LIKE ? OR p0_.slogan LIKE ? OR n1_.label LIKE ? OR n1_.tags LIKE ? OR s3_.label LIKE ? OR s3_.tags LIKE ? OR p5_.description LIKE ?) AND (p0_.last_name LIKE ? OR p0_.first_name LIKE ? OR p0_.slogan LIKE ? OR n1_.label LIKE ? OR n1_.tags LIKE ? OR s3_.label LIKE ? OR s3_.tags LIKE ? OR p5_.description LIKE ?) AND (p0_.last_name LIKE ? OR p0_.first_name LIKE ? OR p0_.slogan LIKE ? OR n1_.label LIKE ? OR n1_.tags LIKE ? OR s3_.label LIKE ? OR s3_.tags LIKE ? OR p5_.description LIKE ?)) ORDER BY RAND() ASC
Parameters:
[
  "%Bilan%"
  "%Bilan%"
  "%Bilan%"
  "%Bilan%"
  "%Bilan%"
  "%Bilan%"
  "%Bilan%"
  "%Bilan%"
  "%de%"
  "%de%"
  "%de%"
  "%de%"
  "%de%"
  "%de%"
  "%de%"
  "%de%"
  "%compétences%"
  "%compétences%"
  "%compétences%"
  "%compétences%"
  "%compétences%"
  "%compétences%"
  "%compétences%"
  "%compétences%"
]
3 0.23 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.salt AS salt_4, t0.enabled AS enabled_5, t0.roles AS roles_6, t0.registration_date AS registration_date_7, t0.last_login AS last_login_8, t0.password_request_date AS password_request_date_9, t0.password_request AS password_request_10, t0.stripe_customer_id AS stripe_customer_id_11, t0.user_id AS user_id_12, t0.partner_id AS partner_id_13 FROM account t0 WHERE t0.partner_id = ?
Parameters:
[
  30
]
4 0.24 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.salt AS salt_4, t0.enabled AS enabled_5, t0.roles AS roles_6, t0.registration_date AS registration_date_7, t0.last_login AS last_login_8, t0.password_request_date AS password_request_date_9, t0.password_request AS password_request_10, t0.stripe_customer_id AS stripe_customer_id_11, t0.user_id AS user_id_12, t0.partner_id AS partner_id_13 FROM account t0 WHERE t0.partner_id = ?
Parameters:
[
  7
]
5 0.18 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.salt AS salt_4, t0.enabled AS enabled_5, t0.roles AS roles_6, t0.registration_date AS registration_date_7, t0.last_login AS last_login_8, t0.password_request_date AS password_request_date_9, t0.password_request AS password_request_10, t0.stripe_customer_id AS stripe_customer_id_11, t0.user_id AS user_id_12, t0.partner_id AS partner_id_13 FROM account t0 WHERE t0.partner_id = ?
Parameters:
[
  32
]
6 0.17 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.salt AS salt_4, t0.enabled AS enabled_5, t0.roles AS roles_6, t0.registration_date AS registration_date_7, t0.last_login AS last_login_8, t0.password_request_date AS password_request_date_9, t0.password_request AS password_request_10, t0.stripe_customer_id AS stripe_customer_id_11, t0.user_id AS user_id_12, t0.partner_id AS partner_id_13 FROM account t0 WHERE t0.partner_id = ?
Parameters:
[
  41
]
7 0.16 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:
[
  30
]
8 0.14 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:
[
  7
]
9 0.27 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
]
10 0.22 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:
[
  41
]
11 0.51 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
Parameters:
[]
12 0.20 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:
[
  30
]
13 0.17 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:
[
  30
]
14 0.43 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:
[
  30
]
15 6.84 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:
[
  30
]
16 0.20 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:
[
  30
]
17 0.15 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
]
18 0.15 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
]
19 0.16 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
]
20 0.20 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
]
21 0.15 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
]

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.