Query Metrics
22
Database Queries
21
Different statements
9.77 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.17 ms (12.02%) |
2 |
SELECT n0_.id AS id_0, n0_.organization AS organization_1, n0_.education AS education_2, n0_.comment AS comment_3, n0_.created_at AS created_at_4, n0_.response AS response_5, n0_.replied_at AS replied_at_6, n0_.last_reminder AS last_reminder_7, n0_.booking_id AS booking_id_8, n0_.pro_id AS pro_id_9, n0_.course_id AS course_id_10, n0_.trainee_id AS trainee_id_11, n0_.note_request_id AS note_request_id_12 FROM note n0_ WHERE n0_.pro_id = ? OR EXISTS (SELECT 1 FROM note_user n1_ WHERE n1_.note_id = n0_.id AND n1_.user_id IN (?)) ORDER BY n0_.id DESC
Parameters:
[ 162 209 ] |
1.03 ms (10.59%) |
1 |
SELECT t0.id AS id_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.telephone AS telephone_9, t0.email AS email_10, t0.password AS password_11, t0.activated AS activated_12, t0.notification AS notification_13, t0.registered_at AS registered_at_14, t0.token AS token_15, t0.photo AS photo_16, t0.slug AS slug_17, t0.is_pro AS is_pro_18, t0.has_access AS has_access_19, t0.status AS status_20, t0.has_accepted_terms AS has_accepted_terms_21, t0.is_ambassador AS is_ambassador_22, t0.language AS language_23, t0.timezone AS timezone_24, t0.phone_code AS phone_code_25, t0.newsletter AS newsletter_26, t0.address_id AS address_id_27, t0.pro_info_id AS pro_info_id_28, t0.stripe_info_id AS stripe_info_id_29, t0.type, t1.is_mobile AS is_mobile_30, t3.is_mobile AS is_mobile_31, t4.birth_date AS birth_date_32, t4.country AS country_33, t5.has_already_logged_in AS has_already_logged_in_34, t5.need_review AS need_review_35, t5.is_editor AS is_editor_36 FROM user t0 LEFT JOIN coach t1 ON t0.id = t1.id LEFT JOIN club t2 ON t0.id = t2.id LEFT JOIN operator t3 ON t0.id = t3.id LEFT JOIN trainee t4 ON t0.id = t4.id LEFT JOIN admin t5 ON t0.id = t5.id WHERE t0.slug = ? LIMIT 1
Parameters:
[
"ar-62207"
]
|
0.60 ms (6.16%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.swimmingpool AS swimmingpool_2, c0_.gym AS gym_3, c0_.restaurant AS restaurant_4, c0_.bar AS bar_5, c0_.seminar_room AS seminar_room_6, c0_.insurance AS insurance_7, c0_.description AS description_8, c0_.created_at AS created_at_9, c0_.image AS image_10, c0_.owner_id AS owner_id_11, c0_.address_id AS address_id_12, c0_.created_by_coach_id AS created_by_coach_id_13, c0_.created_by_operator_id AS created_by_operator_id_14 FROM club_info c0_ LEFT JOIN club c1_ ON c0_.owner_id = c1_.id LEFT JOIN user u2_ ON c1_.id = u2_.id LEFT JOIN club c3_ ON c0_.owner_id = c3_.id LEFT JOIN user u4_ ON c3_.id = u4_.id LEFT JOIN partnership p5_ ON c1_.id = p5_.club_id LEFT JOIN partnership p6_ ON c3_.id = p6_.club_id WHERE (p5_.status = ? AND p5_.coach_id = ?) OR (p6_.status = ? AND p6_.operator_id = ?)
Parameters:
[ "accepted" 209 "accepted" 209 ] |
0.59 ms (6.03%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.swimmingpool AS swimmingpool_3, t0.gym AS gym_4, t0.restaurant AS restaurant_5, t0.bar AS bar_6, t0.seminar_room AS seminar_room_7, t0.insurance AS insurance_8, t0.description AS description_9, t0.created_at AS created_at_10, t0.image AS image_11, t0.owner_id AS owner_id_12, t0.address_id AS address_id_13, t0.created_by_coach_id AS created_by_coach_id_14, t0.created_by_operator_id AS created_by_operator_id_15 FROM club_info t0 WHERE t0.owner_id = ?
Parameters:
[
209
]
|
0.57 ms (5.87%) |
1 |
SELECT c0_.id AS id_0, c0_.logistic AS logistic_1, c0_.frequency AS frequency_2, c0_.status AS status_3, c0_.created_at AS created_at_4, c0_.token AS token_5, c0_.country_code AS country_code_6, c0_.latitude AS latitude_7, c0_.longitude AS longitude_8, c0_.hide_club_info AS hide_club_info_9, c0_.hide_coach_info AS hide_coach_info_10, c0_.step_saved AS step_saved_11, c0_.sended_alert AS sended_alert_12, c0_.cover AS cover_13, c0_.visible_to_club AS visible_to_club_14, c0_.visible_to_coach AS visible_to_coach_15, c0_.visible_to_operator AS visible_to_operator_16, c0_.published_at AS published_at_17, c0_.updated_at AS updated_at_18, c0_.club_id AS club_id_19, c0_.address_id AS address_id_20, c0_.owner_id AS owner_id_21, c0_.operator_id AS operator_id_22 FROM course c0_ LEFT JOIN club_info c1_ ON c0_.club_id = c1_.id LEFT JOIN course_coach_info c3_ ON c0_.id = c3_.course_id LEFT JOIN coach_info c2_ ON c2_.id = c3_.coach_info_id LEFT JOIN operator_info o4_ ON c0_.operator_id = o4_.id WHERE (c1_.id = ? OR EXISTS (SELECT 1 FROM course_coach_info c5_ WHERE c5_.course_id = c0_.id AND c5_.coach_info_id IN (?)) OR o4_.id = ?) AND c0_.status = ? AND c0_.owner_id <> ? AND (c0_.visible_to_club = 1 OR c0_.visible_to_coach = 1 OR c0_.visible_to_operator = 1) LIMIT 3
Parameters:
[ 79 79 79 "active" 209 ] |
0.56 ms (5.77%) |
1 |
SELECT t0.id AS id_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.telephone AS telephone_9, t0.email AS email_10, t0.password AS password_11, t0.activated AS activated_12, t0.notification AS notification_13, t0.registered_at AS registered_at_14, t0.token AS token_15, t0.photo AS photo_16, t0.slug AS slug_17, t0.is_pro AS is_pro_18, t0.has_access AS has_access_19, t0.status AS status_20, t0.has_accepted_terms AS has_accepted_terms_21, t0.is_ambassador AS is_ambassador_22, t0.language AS language_23, t0.timezone AS timezone_24, t0.phone_code AS phone_code_25, t0.newsletter AS newsletter_26, t0.address_id AS address_id_27, t0.pro_info_id AS pro_info_id_28, t0.stripe_info_id AS stripe_info_id_29, t0.type, t1.is_mobile AS is_mobile_30, t3.is_mobile AS is_mobile_31, t4.birth_date AS birth_date_32, t4.country AS country_33, t5.has_already_logged_in AS has_already_logged_in_34, t5.need_review AS need_review_35, t5.is_editor AS is_editor_36 FROM user t0 LEFT JOIN coach t1 ON t0.id = t1.id LEFT JOIN club t2 ON t0.id = t2.id LEFT JOIN operator t3 ON t0.id = t3.id LEFT JOIN trainee t4 ON t0.id = t4.id LEFT JOIN admin t5 ON t0.id = t5.id WHERE t0.pro_info_id = ?
Parameters:
[
162
]
|
0.49 ms (5.07%) |
1 |
SELECT t0.id AS id_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.telephone AS telephone_9, t0.email AS email_10, t0.password AS password_11, t0.activated AS activated_12, t0.notification AS notification_13, t0.registered_at AS registered_at_14, t0.token AS token_15, t0.photo AS photo_16, t0.slug AS slug_17, t0.is_pro AS is_pro_18, t0.has_access AS has_access_19, t0.status AS status_20, t0.has_accepted_terms AS has_accepted_terms_21, t0.is_ambassador AS is_ambassador_22, t0.language AS language_23, t0.timezone AS timezone_24, t0.phone_code AS phone_code_25, t0.newsletter AS newsletter_26, t0.address_id AS address_id_27, t0.pro_info_id AS pro_info_id_28, t0.stripe_info_id AS stripe_info_id_29, t0.type, t1.is_mobile AS is_mobile_30, t3.is_mobile AS is_mobile_31, t4.birth_date AS birth_date_32, t4.country AS country_33, t5.has_already_logged_in AS has_already_logged_in_34, t5.need_review AS need_review_35, t5.is_editor AS is_editor_36 FROM user t0 LEFT JOIN coach t1 ON t0.id = t1.id LEFT JOIN club t2 ON t0.id = t2.id LEFT JOIN operator t3 ON t0.id = t3.id LEFT JOIN trainee t4 ON t0.id = t4.id LEFT JOIN admin t5 ON t0.id = t5.id WHERE t0.address_id = ?
Parameters:
[
686
]
|
0.46 ms (4.68%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.created_at AS created_at_3, c0_.image AS image_4, c0_.owner_id AS owner_id_5, c0_.address_id AS address_id_6, c0_.created_by_club_id AS created_by_club_id_7, c0_.created_by_operator_id AS created_by_operator_id_8 FROM coach_info c0_ LEFT JOIN coach c1_ ON c0_.owner_id = c1_.id LEFT JOIN user u2_ ON c1_.id = u2_.id LEFT JOIN coach c3_ ON c0_.owner_id = c3_.id LEFT JOIN user u4_ ON c3_.id = u4_.id LEFT JOIN partnership p5_ ON c1_.id = p5_.coach_id LEFT JOIN partnership p6_ ON c3_.id = p6_.coach_id WHERE (p5_.status = ? AND p5_.club_id = ?) OR (p6_.status = ? AND p6_.operator_id = ?)
Parameters:
[ "accepted" 209 "accepted" 209 ] |
0.45 ms (4.57%) |
1 |
SELECT c0_.id AS id_0, c0_.logistic AS logistic_1, c0_.frequency AS frequency_2, c0_.status AS status_3, c0_.created_at AS created_at_4, c0_.token AS token_5, c0_.country_code AS country_code_6, c0_.latitude AS latitude_7, c0_.longitude AS longitude_8, c0_.hide_club_info AS hide_club_info_9, c0_.hide_coach_info AS hide_coach_info_10, c0_.step_saved AS step_saved_11, c0_.sended_alert AS sended_alert_12, c0_.cover AS cover_13, c0_.visible_to_club AS visible_to_club_14, c0_.visible_to_coach AS visible_to_coach_15, c0_.visible_to_operator AS visible_to_operator_16, c0_.published_at AS published_at_17, c0_.updated_at AS updated_at_18, c0_.club_id AS club_id_19, c0_.address_id AS address_id_20, c0_.owner_id AS owner_id_21, c0_.operator_id AS operator_id_22 FROM course c0_ WHERE c0_.status = ? AND c0_.owner_id = ?
Parameters:
[ "active" 209 ] |
0.43 ms (4.40%) |
1 |
SELECT t0.id AS id_1, t0.cover_photo AS cover_photo_2, t0.fullname AS fullname_3, t0.website AS website_4, t0.facebook AS facebook_5, t0.twitter AS twitter_6, t0.instagram AS instagram_7, t0.linkedin AS linkedin_8, t0.youtube AS youtube_9, t0.use_stripe AS use_stripe_10, t0.have_subscription AS have_subscription_11, t0.page_visible AS page_visible_12, t0.is_hidden AS is_hidden_13, t0.twitch AS twitch_14, t0.tiktok AS tiktok_15, t0.auto_renew AS auto_renew_16, t0.contact_email AS contact_email_17, t0.is_free_subscription AS is_free_subscription_18, t0.have_payment_issue AS have_payment_issue_19, t0.payment_deadline AS payment_deadline_20 FROM pro_info t0 WHERE t0.id = ?
Parameters:
[
162
]
|
0.40 ms (4.10%) |
1 |
SELECT t0.id AS id_1, t0.city AS city_2, t0.longitude AS longitude_3, t0.latitude AS latitude_4, t0.country_code AS country_code_5, t0.full_address AS full_address_6, t0.place_id AS place_id_7, t8.id AS id_9, t8.logistic AS logistic_10, t8.frequency AS frequency_11, t8.status AS status_12, t8.created_at AS created_at_13, t8.token AS token_14, t8.country_code AS country_code_15, t8.latitude AS latitude_16, t8.longitude AS longitude_17, t8.hide_club_info AS hide_club_info_18, t8.hide_coach_info AS hide_coach_info_19, t8.step_saved AS step_saved_20, t8.sended_alert AS sended_alert_21, t8.cover AS cover_22, t8.visible_to_club AS visible_to_club_23, t8.visible_to_coach AS visible_to_coach_24, t8.visible_to_operator AS visible_to_operator_25, t8.published_at AS published_at_26, t8.updated_at AS updated_at_27, t8.club_id AS club_id_28, t8.address_id AS address_id_29, t8.owner_id AS owner_id_30, t8.operator_id AS operator_id_31, t0.pro_id AS pro_id_32 FROM address t0 LEFT JOIN course t8 ON t8.address_id = t0.id WHERE t0.pro_id = ?
Parameters:
[
209
]
|
0.40 ms (4.10%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM language t0 INNER JOIN user_language ON t0.id = user_language.language_id WHERE user_language.user_id = ?
Parameters:
[
209
]
|
0.34 ms (3.45%) |
1 |
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.views AS views_2, p0_.ip AS ip_3, p0_.pro_id AS pro_id_4 FROM pro_views_stat p0_ WHERE p0_.ip = ? AND p0_.pro_id = ?
Parameters:
[ "216.73.216.81" 209 ] |
0.33 ms (3.35%) |
1 |
SELECT t0.id AS id_1, t0.city AS city_2, t0.longitude AS longitude_3, t0.latitude AS latitude_4, t0.country_code AS country_code_5, t0.full_address AS full_address_6, t0.place_id AS place_id_7, t8.id AS id_9, t8.logistic AS logistic_10, t8.frequency AS frequency_11, t8.status AS status_12, t8.created_at AS created_at_13, t8.token AS token_14, t8.country_code AS country_code_15, t8.latitude AS latitude_16, t8.longitude AS longitude_17, t8.hide_club_info AS hide_club_info_18, t8.hide_coach_info AS hide_coach_info_19, t8.step_saved AS step_saved_20, t8.sended_alert AS sended_alert_21, t8.cover AS cover_22, t8.visible_to_club AS visible_to_club_23, t8.visible_to_coach AS visible_to_coach_24, t8.visible_to_operator AS visible_to_operator_25, t8.published_at AS published_at_26, t8.updated_at AS updated_at_27, t8.club_id AS club_id_28, t8.address_id AS address_id_29, t8.owner_id AS owner_id_30, t8.operator_id AS operator_id_31, t0.pro_id AS pro_id_32 FROM address t0 LEFT JOIN course t8 ON t8.address_id = t0.id WHERE t0.id = ?
Parameters:
[
686
]
|
0.32 ms (3.30%) |
1 |
SELECT t0.id AS id_1, t0.availabilities AS availabilities_2, t0.club_id AS club_id_3, t0.sport_id AS sport_id_4 FROM availability t0 WHERE t0.club_id = ?
Parameters:
[
209
]
|
0.30 ms (3.04%) |
1 |
SELECT t0.id AS id_1, t0.video_id AS video_id_2, t0.type AS type_3, t0.path AS path_4, t0.pro_id AS pro_id_5, t0.course_id AS course_id_6 FROM video t0 WHERE t0.pro_id = ?
Parameters:
[
162
]
|
0.29 ms (2.98%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.pro_id AS pro_id_3, t0.course_id AS course_id_4 FROM photo t0 WHERE t0.pro_id = ?
Parameters:
[
162
]
|
0.28 ms (2.87%) |
1 |
SELECT t0.id AS id_1, t0.description AS description_2, t0.language AS language_3, t0.is_original AS is_original_4, t0.pro_id AS pro_id_5 FROM pro_description t0 WHERE t0.pro_id = ? AND t0.language = ? LIMIT 1
Parameters:
[ 209 "es" ] |
0.27 ms (2.80%) |
1 |
SELECT t0.id AS id_1, t0.nb_open AS nb_open_2, t0.nb_covered AS nb_covered_3, t0.nb_semi_open AS nb_semi_open_4, t0.club_info_id AS club_info_id_5, t0.sport_id AS sport_id_6 FROM court_info t0 WHERE t0.club_info_id = ?
Parameters:
[
79
]
|
0.25 ms (2.59%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.owner_id AS owner_id_4 FROM sponsor t0 WHERE t0.owner_id = ?
Parameters:
[
162
]
|
0.22 ms (2.27%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.status AS status_5, t0.appearance AS appearance_6 FROM sport t0
Parameters:
[] |
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.