Query Metrics
54
Database Queries
29
Different statements
35.93 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.16 ms |
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:
[
"anaispro-rouas-83145"
]
|
| 2 | 0.71 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.owner_id AS owner_id_6, t0.address_id AS address_id_7, t0.created_by_club_id AS created_by_club_id_8, t0.created_by_operator_id AS created_by_operator_id_9 FROM coach_info t0 WHERE t0.owner_id = ?
Parameters:
[
207
]
|
| 3 | 0.52 ms |
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:
[
161
]
|
| 4 | 0.62 ms |
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:
[
161
]
|
| 5 | 0.60 ms |
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" 207 ] |
| 6 | 0.51 ms |
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.id IN (?)
Parameters:
[
78
]
|
| 7 | 0.41 ms |
SELECT c0_.id AS id_0, c0_.begin AS begin_1, c0_.end AS end_2, c0_.price AS price_3, c0_.start_date AS start_date_4, c0_.duration AS duration_5, c0_.recurrence AS recurrence_6, c0_.day_position AS day_position_7, c0_.formatted_date AS formatted_date_8, c0_.course_id AS course_id_9 FROM course_availability c0_ WHERE c0_.course_id = ? ORDER BY c0_.begin ASC
Parameters:
[
294
]
|
| 8 | 0.46 ms |
SELECT c0_.id AS id_0, c0_.begin AS begin_1, c0_.end AS end_2, c0_.price AS price_3, c0_.start_date AS start_date_4, c0_.duration AS duration_5, c0_.recurrence AS recurrence_6, c0_.day_position AS day_position_7, c0_.formatted_date AS formatted_date_8, c0_.course_id AS course_id_9 FROM course_availability c0_ WHERE c0_.course_id = ? ORDER BY c0_.begin ASC
Parameters:
[
295
]
|
| 9 | 0.46 ms |
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.243" 207 ] |
| 10 | 0.46 ms |
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:
[
207
]
|
| 11 | 0.33 ms |
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:
[
678
]
|
| 12 | 0.42 ms |
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:
[
678
]
|
| 13 | 0.54 ms |
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:
[ 80 80 80 "active" 207 ] |
| 14 | 0.30 ms |
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:
[ 207 "es" ] |
| 15 | 0.42 ms |
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" 207 "accepted" 207 ] |
| 16 | 0.55 ms |
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" 207 "accepted" 207 ] |
| 17 | 0.22 ms |
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:
[] |
| 18 | 0.85 ms |
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:
[ 161 207 ] |
| 19 | 0.77 ms |
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:
[
207
]
|
| 20 | 2.54 ms |
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:
[
161
]
|
| 21 | 0.44 ms |
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:
[
161
]
|
| 22 | 0.38 ms |
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 INNER JOIN pro_info_sport ON t0.id = pro_info_sport.sport_id WHERE pro_info_sport.pro_info_id = ?
Parameters:
[
161
]
|
| 23 | 0.30 ms |
SELECT t0.id AS id_1, t0.job_title AS job_title_2, t0.sector AS sector_3, t0.address AS address_4, t0.description AS description_5, t0.begin AS begin_6, t0.end AS end_7, t0.company AS company_8, t0.coach_id AS coach_id_9 FROM experience t0 WHERE t0.coach_id = ?
Parameters:
[
80
]
|
| 24 | 0.27 ms |
SELECT t0.id AS id_1, t0.organisation AS organisation_2, t0.diploma AS diploma_3, t0.begin AS begin_4, t0.end AS end_5, t0.coach_id AS coach_id_6 FROM formation t0 WHERE t0.coach_id = ?
Parameters:
[
80
]
|
| 25 | 0.31 ms |
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:
[
161
]
|
| 26 | 0.70 ms |
SELECT c0_.id AS id_0, c0_.begin AS begin_1, c0_.end AS end_2, c0_.price AS price_3, c0_.start_date AS start_date_4, c0_.duration AS duration_5, c0_.recurrence AS recurrence_6, c0_.day_position AS day_position_7, c0_.formatted_date AS formatted_date_8, c0_.course_id AS course_id_9 FROM course_availability c0_ WHERE c0_.course_id = ? ORDER BY c0_.begin ASC
Parameters:
[
294
]
|
| 27 | 0.35 ms |
SELECT c0_.id AS id_0, c0_.begin AS begin_1, c0_.end AS end_2, c0_.price AS price_3, c0_.start_date AS start_date_4, c0_.duration AS duration_5, c0_.recurrence AS recurrence_6, c0_.day_position AS day_position_7, c0_.formatted_date AS formatted_date_8, c0_.course_id AS course_id_9 FROM course_availability c0_ WHERE c0_.course_id = ? ORDER BY c0_.begin ASC
Parameters:
[
294
]
|
| 28 | 0.36 ms |
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 INNER JOIN course_sport ON t0.id = course_sport.sport_id WHERE course_sport.course_id = ?
Parameters:
[
294
]
|
| 29 | 2.62 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.language AS language_4, t0.others AS others_5, t0.course_id AS course_id_6 FROM translated_course t0 WHERE t0.course_id = ?
Parameters:
[
294
]
|
| 30 | 1.59 ms |
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:
[ 161 207 ] |
| 31 | 0.86 ms |
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:
[
684
]
|
| 32 | 0.65 ms |
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:
[
684
]
|
| 33 | 0.73 ms |
SELECT t0.id AS id_1, t0.begin AS begin_2, t0.end AS end_3, t0.price AS price_4, t0.start_date AS start_date_5, t0.duration AS duration_6, t0.recurrence AS recurrence_7, t0.day_position AS day_position_8, t0.formatted_date AS formatted_date_9, t0.course_id AS course_id_10 FROM course_availability t0 WHERE t0.course_id = ?
Parameters:
[
294
]
|
| 34 | 0.65 ms |
SELECT c0_.id AS id_0, c0_.begin AS begin_1, c0_.end AS end_2, c0_.price AS price_3, c0_.start_date AS start_date_4, c0_.duration AS duration_5, c0_.recurrence AS recurrence_6, c0_.day_position AS day_position_7, c0_.formatted_date AS formatted_date_8, c0_.course_id AS course_id_9 FROM course_availability c0_ WHERE c0_.course_id = ? ORDER BY c0_.begin ASC
Parameters:
[
294
]
|
| 35 | 0.48 ms |
SELECT c0_.id AS id_0, c0_.begin AS begin_1, c0_.end AS end_2, c0_.price AS price_3, c0_.start_date AS start_date_4, c0_.duration AS duration_5, c0_.recurrence AS recurrence_6, c0_.day_position AS day_position_7, c0_.formatted_date AS formatted_date_8, c0_.course_id AS course_id_9 FROM course_availability c0_ WHERE c0_.course_id = ? ORDER BY c0_.begin ASC
Parameters:
[
294
]
|
| 36 | 0.82 ms |
SELECT c0_.id AS id_0, c0_.begin AS begin_1, c0_.end AS end_2, c0_.price AS price_3, c0_.start_date AS start_date_4, c0_.duration AS duration_5, c0_.recurrence AS recurrence_6, c0_.day_position AS day_position_7, c0_.formatted_date AS formatted_date_8, c0_.course_id AS course_id_9 FROM course_availability c0_ WHERE c0_.course_id = ? ORDER BY c0_.begin ASC
Parameters:
[
294
]
|
| 37 | 1.49 ms |
SELECT c0_.id AS id_0, c0_.begin AS begin_1, c0_.end AS end_2, c0_.price AS price_3, c0_.start_date AS start_date_4, c0_.duration AS duration_5, c0_.recurrence AS recurrence_6, c0_.day_position AS day_position_7, c0_.formatted_date AS formatted_date_8, c0_.course_id AS course_id_9 FROM course_availability c0_ WHERE c0_.course_id = ? ORDER BY c0_.begin ASC
Parameters:
[
294
]
|
| 38 | 1.46 ms |
SELECT c0_.id AS id_0, c0_.begin AS begin_1, c0_.end AS end_2, c0_.price AS price_3, c0_.start_date AS start_date_4, c0_.duration AS duration_5, c0_.recurrence AS recurrence_6, c0_.day_position AS day_position_7, c0_.formatted_date AS formatted_date_8, c0_.course_id AS course_id_9 FROM course_availability c0_ WHERE c0_.course_id = ? ORDER BY c0_.begin ASC
Parameters:
[
295
]
|
| 39 | 2.99 ms |
SELECT c0_.id AS id_0, c0_.begin AS begin_1, c0_.end AS end_2, c0_.price AS price_3, c0_.start_date AS start_date_4, c0_.duration AS duration_5, c0_.recurrence AS recurrence_6, c0_.day_position AS day_position_7, c0_.formatted_date AS formatted_date_8, c0_.course_id AS course_id_9 FROM course_availability c0_ WHERE c0_.course_id = ? ORDER BY c0_.begin ASC
Parameters:
[
295
]
|
| 40 | 0.40 ms |
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 INNER JOIN course_sport ON t0.id = course_sport.sport_id WHERE course_sport.course_id = ?
Parameters:
[
295
]
|
| 41 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.language AS language_4, t0.others AS others_5, t0.course_id AS course_id_6 FROM translated_course t0 WHERE t0.course_id = ?
Parameters:
[
295
]
|
| 42 | 0.40 ms |
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:
[ 161 207 ] |
| 43 | 0.45 ms |
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:
[
685
]
|
| 44 | 0.48 ms |
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:
[
685
]
|
| 45 | 0.32 ms |
SELECT t0.id AS id_1, t0.begin AS begin_2, t0.end AS end_3, t0.price AS price_4, t0.start_date AS start_date_5, t0.duration AS duration_6, t0.recurrence AS recurrence_7, t0.day_position AS day_position_8, t0.formatted_date AS formatted_date_9, t0.course_id AS course_id_10 FROM course_availability t0 WHERE t0.course_id = ?
Parameters:
[
295
]
|
| 46 | 0.31 ms |
SELECT c0_.id AS id_0, c0_.begin AS begin_1, c0_.end AS end_2, c0_.price AS price_3, c0_.start_date AS start_date_4, c0_.duration AS duration_5, c0_.recurrence AS recurrence_6, c0_.day_position AS day_position_7, c0_.formatted_date AS formatted_date_8, c0_.course_id AS course_id_9 FROM course_availability c0_ WHERE c0_.course_id = ? ORDER BY c0_.begin ASC
Parameters:
[
295
]
|
| 47 | 0.29 ms |
SELECT c0_.id AS id_0, c0_.begin AS begin_1, c0_.end AS end_2, c0_.price AS price_3, c0_.start_date AS start_date_4, c0_.duration AS duration_5, c0_.recurrence AS recurrence_6, c0_.day_position AS day_position_7, c0_.formatted_date AS formatted_date_8, c0_.course_id AS course_id_9 FROM course_availability c0_ WHERE c0_.course_id = ? ORDER BY c0_.begin ASC
Parameters:
[
295
]
|
| 48 | 0.28 ms |
SELECT c0_.id AS id_0, c0_.begin AS begin_1, c0_.end AS end_2, c0_.price AS price_3, c0_.start_date AS start_date_4, c0_.duration AS duration_5, c0_.recurrence AS recurrence_6, c0_.day_position AS day_position_7, c0_.formatted_date AS formatted_date_8, c0_.course_id AS course_id_9 FROM course_availability c0_ WHERE c0_.course_id = ? ORDER BY c0_.begin ASC
Parameters:
[
295
]
|
| 49 | 0.30 ms |
SELECT c0_.id AS id_0, c0_.begin AS begin_1, c0_.end AS end_2, c0_.price AS price_3, c0_.start_date AS start_date_4, c0_.duration AS duration_5, c0_.recurrence AS recurrence_6, c0_.day_position AS day_position_7, c0_.formatted_date AS formatted_date_8, c0_.course_id AS course_id_9 FROM course_availability c0_ WHERE c0_.course_id = ? ORDER BY c0_.begin ASC
Parameters:
[
295
]
|
| 50 | 0.44 ms |
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:
[ 161 207 ] |
| 51 | 0.57 ms |
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:
[ 161 207 ] |
| 52 | 0.38 ms |
SELECT t1.id AS id_2, t1.firstname AS firstname_3, t1.lastname AS lastname_4, t1.telephone AS telephone_5, t1.email AS email_6, t1.password AS password_7, t1.activated AS activated_8, t1.notification AS notification_9, t1.registered_at AS registered_at_10, t1.token AS token_11, t1.photo AS photo_12, t1.slug AS slug_13, t1.is_pro AS is_pro_14, t1.has_access AS has_access_15, t1.status AS status_16, t1.has_accepted_terms AS has_accepted_terms_17, t1.is_ambassador AS is_ambassador_18, t1.language AS language_19, t1.timezone AS timezone_20, t1.phone_code AS phone_code_21, t1.newsletter AS newsletter_22, t0.birth_date AS birth_date_23, t0.country AS country_24, t1.address_id AS address_id_25, t1.pro_info_id AS pro_info_id_26, t1.stripe_info_id AS stripe_info_id_27, t1.type FROM trainee t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
205
]
|
| 53 | 0.42 ms |
SELECT t0.id AS id_1, t0.logistic AS logistic_2, t0.frequency AS frequency_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.token AS token_6, t0.country_code AS country_code_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.hide_club_info AS hide_club_info_10, t0.hide_coach_info AS hide_coach_info_11, t0.step_saved AS step_saved_12, t0.sended_alert AS sended_alert_13, t0.cover AS cover_14, t0.visible_to_club AS visible_to_club_15, t0.visible_to_coach AS visible_to_coach_16, t0.visible_to_operator AS visible_to_operator_17, t0.published_at AS published_at_18, t0.updated_at AS updated_at_19, t0.club_id AS club_id_20, t21.id AS id_22, t21.name AS name_23, t21.swimmingpool AS swimmingpool_24, t21.gym AS gym_25, t21.restaurant AS restaurant_26, t21.bar AS bar_27, t21.seminar_room AS seminar_room_28, t21.insurance AS insurance_29, t21.description AS description_30, t21.created_at AS created_at_31, t21.image AS image_32, t21.owner_id AS owner_id_33, t21.address_id AS address_id_34, t21.created_by_coach_id AS created_by_coach_id_35, t21.created_by_operator_id AS created_by_operator_id_36, t0.address_id AS address_id_37, t0.owner_id AS owner_id_38, t0.operator_id AS operator_id_39 FROM course t0 LEFT JOIN club_info t21 ON t0.club_id = t21.id WHERE t0.id = ?
Parameters:
[
290
]
|
| 54 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.language AS language_4, t0.others AS others_5, t0.course_id AS course_id_6 FROM translated_course t0 WHERE t0.course_id = ?
Parameters:
[
290
]
|
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.