Query Metrics
40
Database Queries
15
Different statements
10.07 ms
Query time
0
Invalid entities
99
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
2.09 ms (20.71%) |
8 |
SELECT t0.id AS id_1, t0.appointment_date AS appointment_date_2, t0.start_time AS start_time_3, t0.end_time AS end_time_4, t0.status AS status_5, t0.refusal_reason AS refusal_reason_6, t0.client_notes AS client_notes_7, t0.qr_code_token AS qr_code_token_8, t0.created_at AS created_at_9, t0.client_id AS client_id_10, t0.barber_profile_id AS barber_profile_id_11, t0.service_id AS service_id_12, t13.id AS id_14, t13.rating AS rating_15, t13.rating_ambiance AS rating_ambiance_16, t13.rating_rapport_qp AS rating_rapport_qp_17, t13.rating_resultats AS rating_resultats_18, t13.comment AS comment_19, t13.is_hidden AS is_hidden_20, t13.is_reported AS is_reported_21, t13.professional_reply AS professional_reply_22, t13.replied_at AS replied_at_23, t13.created_at AS created_at_24, t13.client_id AS client_id_25, t13.barber_profile_id AS barber_profile_id_26, t13.appointment_id AS appointment_id_27 FROM appointment t0 LEFT JOIN review t13 ON t13.appointment_id = t0.id WHERE t0.id = ?
Parameters:
[
248
]
|
||||||||||||||||||||||||||||||
|
1.26 ms (12.48%) |
8 |
SELECT t0.id AS id_1, t0.salon_name AS salon_name_2, t0.slug AS slug_3, t0.description AS description_4, t0.address AS address_5, t0.city AS city_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.languages AS languages_9, t0.transport_info AS transport_info_10, t0.payment_methods AS payment_methods_11, t0.subscription_plan AS subscription_plan_12, t0.salon_type AS salon_type_13, t0.salon_categories AS salon_categories_14, t0.is_verified AS is_verified_15, t0.is_active AS is_active_16, t0.offer_home_visit AS offer_home_visit_17, t0.home_visit_radius AS home_visit_radius_18, t0.phone AS phone_19, t0.website AS website_20, t0.instagram AS instagram_21, t0.facebook AS facebook_22, t0.tiktok AS tiktok_23, t0.created_at AS created_at_24, t0.user_id AS user_id_25 FROM barber_profile t0 WHERE t0.user_id = ?
Parameters:
[
10
]
|
||||||||||||||||||||||||||||||
|
1.20 ms (11.92%) |
5 |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_cover AS is_cover_3, t0.sort_order AS sort_order_4, t0.barber_profile_id AS barber_profile_id_5 FROM profile_photo t0 WHERE t0.barber_profile_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
33
]
|
||||||||||||||||||||||||||||||
|
0.86 ms (8.57%) |
3 |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_10 FROM (SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.rating_ambiance AS rating_ambiance_2, r0_.rating_rapport_qp AS rating_rapport_qp_3, r0_.rating_resultats AS rating_resultats_4, r0_.comment AS comment_5, r0_.is_hidden AS is_hidden_6, r0_.is_reported AS is_reported_7, r0_.professional_reply AS professional_reply_8, r0_.replied_at AS replied_at_9, r0_.created_at AS created_at_10, u1_.id AS id_11, u1_.email AS email_12, u1_.roles AS roles_13, u1_.password AS password_14, u1_.first_name AS first_name_15, u1_.last_name AS last_name_16, u1_.phone AS phone_17, u1_.avatar AS avatar_18, u1_.preferred_language AS preferred_language_19, u1_.created_at AS created_at_20, u1_.is_active AS is_active_21, u1_.is_verified AS is_verified_22 FROM review r0_ LEFT JOIN `user` u1_ ON r0_.client_id = u1_.id WHERE r0_.barber_profile_id = ? AND r0_.is_hidden = 0) dctrn_result_inner ORDER BY created_at_10 DESC) dctrn_result LIMIT 10
Parameters:
[
33
]
|
||||||||||||||||||||||||||||||
|
0.72 ms (7.12%) |
4 |
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.rating_ambiance AS rating_ambiance_3, t0.rating_rapport_qp AS rating_rapport_qp_4, t0.rating_resultats AS rating_resultats_5, t0.comment AS comment_6, t0.is_hidden AS is_hidden_7, t0.is_reported AS is_reported_8, t0.professional_reply AS professional_reply_9, t0.replied_at AS replied_at_10, t0.created_at AS created_at_11, t0.client_id AS client_id_12, t0.barber_profile_id AS barber_profile_id_13, t0.appointment_id AS appointment_id_14 FROM review t0 WHERE t0.barber_profile_id = ?
Parameters:
[
4
]
|
||||||||||||||||||||||||||||||
|
0.64 ms (6.38%) |
3 |
SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.rating_ambiance AS rating_ambiance_2, r0_.rating_rapport_qp AS rating_rapport_qp_3, r0_.rating_resultats AS rating_resultats_4, r0_.comment AS comment_5, r0_.is_hidden AS is_hidden_6, r0_.is_reported AS is_reported_7, r0_.professional_reply AS professional_reply_8, r0_.replied_at AS replied_at_9, r0_.created_at AS created_at_10, u1_.id AS id_11, u1_.email AS email_12, u1_.roles AS roles_13, u1_.password AS password_14, u1_.first_name AS first_name_15, u1_.last_name AS last_name_16, u1_.phone AS phone_17, u1_.avatar AS avatar_18, u1_.preferred_language AS preferred_language_19, u1_.created_at AS created_at_20, u1_.is_active AS is_active_21, u1_.is_verified AS is_verified_22, r0_.client_id AS client_id_23, r0_.barber_profile_id AS barber_profile_id_24, r0_.appointment_id AS appointment_id_25 FROM review r0_ LEFT JOIN `user` u1_ ON r0_.client_id = u1_.id WHERE r0_.barber_profile_id = ? AND r0_.is_hidden = 0 AND r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?) ORDER BY r0_.created_at DESC
Parameters:
[ 33 93 92 91 90 89 88 87 86 ] |
||||||||||||||||||||||||||||||
|
0.57 ms (5.61%) |
1 |
SELECT AVG(r0_.rating) AS sclr_0 FROM review r0_ WHERE r0_.barber_profile_id = ? AND r0_.is_hidden = 0
Parameters:
[
33
]
|
||||||||||||||||||||||||||||||
|
0.56 ms (5.54%) |
1 |
SELECT t0.id AS id_1, t0.salon_name AS salon_name_2, t0.slug AS slug_3, t0.description AS description_4, t0.address AS address_5, t0.city AS city_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.languages AS languages_9, t0.transport_info AS transport_info_10, t0.payment_methods AS payment_methods_11, t0.subscription_plan AS subscription_plan_12, t0.salon_type AS salon_type_13, t0.salon_categories AS salon_categories_14, t0.is_verified AS is_verified_15, t0.is_active AS is_active_16, t0.offer_home_visit AS offer_home_visit_17, t0.home_visit_radius AS home_visit_radius_18, t0.phone AS phone_19, t0.website AS website_20, t0.instagram AS instagram_21, t0.facebook AS facebook_22, t0.tiktok AS tiktok_23, t0.created_at AS created_at_24, t0.user_id AS user_id_25 FROM barber_profile t0 WHERE t0.slug = ? AND t0.is_active = ? LIMIT 1
Parameters:
[ "institut-camy" 1 ]
|
||||||||||||||||||||||||||||||
|
0.42 ms (4.19%) |
1 |
SELECT b0_.id AS id_0, b0_.salon_name AS salon_name_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.address AS address_4, b0_.city AS city_5, b0_.latitude AS latitude_6, b0_.longitude AS longitude_7, b0_.languages AS languages_8, b0_.transport_info AS transport_info_9, b0_.payment_methods AS payment_methods_10, b0_.subscription_plan AS subscription_plan_11, b0_.salon_type AS salon_type_12, b0_.salon_categories AS salon_categories_13, b0_.is_verified AS is_verified_14, b0_.is_active AS is_active_15, b0_.offer_home_visit AS offer_home_visit_16, b0_.home_visit_radius AS home_visit_radius_17, b0_.phone AS phone_18, b0_.website AS website_19, b0_.instagram AS instagram_20, b0_.facebook AS facebook_21, b0_.tiktok AS tiktok_22, b0_.created_at AS created_at_23, b0_.user_id AS user_id_24 FROM barber_profile b0_ WHERE b0_.is_active = 1 AND b0_.id <> ? AND b0_.city = ? ORDER BY b0_.subscription_plan DESC LIMIT 4
Parameters:
[ 33 "Montreal" ]
|
||||||||||||||||||||||||||||||
|
0.34 ms (3.41%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.sub_category AS sub_category_4, t0.duration_minutes AS duration_minutes_5, t0.duration_max_minutes AS duration_max_minutes_6, t0.price AS price_7, t0.description AS description_8, t0.happy_hours_discount AS happy_hours_discount_9, t0.happy_hours_slot AS happy_hours_slot_10, t0.is_active AS is_active_11, t0.barber_profile_id AS barber_profile_id_12 FROM service t0 WHERE t0.barber_profile_id = ?
Parameters:
[
33
]
|
||||||||||||||||||||||||||||||
|
0.33 ms (3.28%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.rating_ambiance AS rating_ambiance_2, r0_.rating_rapport_qp AS rating_rapport_qp_3, r0_.rating_resultats AS rating_resultats_4, r0_.comment AS comment_5, r0_.is_hidden AS is_hidden_6, r0_.is_reported AS is_reported_7, r0_.professional_reply AS professional_reply_8, r0_.replied_at AS replied_at_9, r0_.created_at AS created_at_10, u1_.id AS id_11, u1_.email AS email_12, u1_.roles AS roles_13, u1_.password AS password_14, u1_.first_name AS first_name_15, u1_.last_name AS last_name_16, u1_.phone AS phone_17, u1_.avatar AS avatar_18, u1_.preferred_language AS preferred_language_19, u1_.created_at AS created_at_20, u1_.is_active AS is_active_21, u1_.is_verified AS is_verified_22 FROM review r0_ LEFT JOIN `user` u1_ ON r0_.client_id = u1_.id WHERE r0_.barber_profile_id = ? AND r0_.is_hidden = 0 ORDER BY r0_.created_at DESC) dctrn_result) dctrn_table
Parameters:
[
33
]
|
||||||||||||||||||||||||||||||
|
0.30 ms (3.03%) |
1 |
SELECT COUNT(r0_.id) AS sclr_0 FROM review r0_ WHERE r0_.barber_profile_id = ? AND r0_.is_hidden = 0
Parameters:
[
33
]
|
||||||||||||||||||||||||||||||
|
0.28 ms (2.80%) |
1 |
SELECT r0_.rating AS rating_0, COUNT(r0_.id) AS sclr_1 FROM review r0_ WHERE r0_.barber_profile_id = ? AND r0_.is_hidden = 0 GROUP BY r0_.rating
Parameters:
[
33
]
|
||||||||||||||||||||||||||||||
|
0.25 ms (2.50%) |
1 |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.setting_type AS setting_type_4, t0.setting_group AS setting_group_5, t0.label AS label_6, t0.description AS description_7, t0.updated_at AS updated_at_8 FROM setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
"maintenance_mode"
]
|
||||||||||||||||||||||||||||||
|
0.25 ms (2.44%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.avatar AS avatar_8, t0.preferred_language AS preferred_language_9, t0.created_at AS created_at_10, t0.is_active AS is_active_11, t0.is_verified AS is_verified_12, t13.id AS id_14, t13.salon_name AS salon_name_15, t13.slug AS slug_16, t13.description AS description_17, t13.address AS address_18, t13.city AS city_19, t13.latitude AS latitude_20, t13.longitude AS longitude_21, t13.languages AS languages_22, t13.transport_info AS transport_info_23, t13.payment_methods AS payment_methods_24, t13.subscription_plan AS subscription_plan_25, t13.salon_type AS salon_type_26, t13.salon_categories AS salon_categories_27, t13.is_verified AS is_verified_28, t13.is_active AS is_active_29, t13.offer_home_visit AS offer_home_visit_30, t13.home_visit_radius AS home_visit_radius_31, t13.phone AS phone_32, t13.website AS website_33, t13.instagram AS instagram_34, t13.facebook AS facebook_35, t13.tiktok AS tiktok_36, t13.created_at AS created_at_37, t13.user_id AS user_id_38 FROM `user` t0 LEFT JOIN barber_profile t13 ON t13.user_id = t0.id WHERE t0.id = ?
Parameters:
[
63
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Service | 31 |
| App\Entity\Review | 19 |
| App\Entity\Appointment | 19 |
| App\Entity\User | 17 |
| App\Entity\ProfilePhoto | 7 |
| App\Entity\BarberProfile | 5 |
| App\Entity\Setting | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Setting | No errors. |
| App\Entity\BarberProfile | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Service | No errors. |
| App\Entity\Availability | No errors. |
| App\Entity\SpecialClosure | No errors. |
| App\Entity\Appointment | No errors. |
| App\Entity\Review | No errors. |
| App\Entity\ProfilePhoto | No errors. |
| App\Entity\Notification | No errors. |