Query Metrics
46
Database Queries
33
Different statements
23.43 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.88 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.token = ? LIMIT 1
Parameters:
[
"6aebedef68363bc7"
]
|
2 | 0.98 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.id = ?
Parameters:
[
207
]
|
3 | 0.73 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
]
|
4 | 0.78 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
]
|
5 | 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
]
|
6 | 1.03 ms |
SELECT c0_.id AS id_0, c0_.ip AS ip_1, c0_.views AS views_2, c0_.date AS date_3, c0_.course_id AS course_id_4 FROM course_views_stat c0_ WHERE c0_.ip = ? AND c0_.course_id = ?
Parameters:
[ "216.73.216.166" 294 ] |
7 | 1.07 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 ] |
8 | 0.84 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 ] |
9 | 0.67 ms |
SELECT t0.id AS id_1, t0.begin AS begin_2, t0.end AS end_3, t0.adult AS adult_4, t0.teen AS teen_5, t0.child AS child_6, t0.total AS total_7, t0.asked_at AS asked_at_8, t0.status AS status_9, t0.payment_method AS payment_method_10, t0.is_paid AS is_paid_11, t0.week AS week_12, t0.reason AS reason_13, t0.is_noted AS is_noted_14, t0.ref AS ref_15, t0.month AS month_16, t0.year AS year_17, t0.course_id AS course_id_18, t0.trainee_id AS trainee_id_19, t20.id AS id_21, t20.amount AS amount_22, t20.created_at AS created_at_23, t20.status AS status_24, t20.booking_id AS booking_id_25, t26.id AS id_27, t26.organization AS organization_28, t26.education AS education_29, t26.comment AS comment_30, t26.created_at AS created_at_31, t26.response AS response_32, t26.replied_at AS replied_at_33, t26.last_reminder AS last_reminder_34, t26.booking_id AS booking_id_35, t26.pro_id AS pro_id_36, t26.course_id AS course_id_37, t26.trainee_id AS trainee_id_38, t26.note_request_id AS note_request_id_39 FROM booking t0 LEFT JOIN payment_request t20 ON t20.booking_id = t0.id LEFT JOIN note t26 ON t26.booking_id = t0.id WHERE t0.id = ?
Parameters:
[
150
]
|
10 | 0.60 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
]
|
11 | 0.71 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
]
|
12 | 0.52 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
]
|
13 | 0.42 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.course_id = ?
Parameters:
[
294
]
|
14 | 0.43 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
]
|
15 | 0.64 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
]
|
16 | 0.49 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 ] |
17 | 0.37 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.course_id = ?
Parameters:
[
294
]
|
18 | 0.50 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.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:
[
294
]
|
20 | 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:
[
684
]
|
21 | 0.50 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
]
|
22 | 0.41 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM language t0 INNER JOIN course_language ON t0.id = course_language.language_id WHERE course_language.course_id = ?
Parameters:
[
294
]
|
23 | 0.36 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
]
|
24 | 0.36 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
]
|
25 | 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
]
|
26 | 0.34 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.34 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 FROM age t0 INNER JOIN course_age ON t0.id = course_age.age_id WHERE course_age.course_id = ?
Parameters:
[
294
]
|
29 | 0.43 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM LEVEL t0 INNER JOIN course_level ON t0.id = course_level.level_id WHERE course_level.course_id = ?
Parameters:
[
294
]
|
30 | 0.35 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
]
|
31 | 0.34 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.translated_course_id AS translated_course_id_4 FROM planning t0 WHERE t0.translated_course_id = ?
Parameters:
[
1237
]
|
32 | 0.30 ms |
SELECT t0.id AS id_1, t0.persons AS persons_2, t0.price_per_person AS price_per_person_3, t0.course_id AS course_id_4 FROM price_bundle t0 WHERE t0.course_id = ?
Parameters:
[
294
]
|
33 | 0.36 ms |
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:
[
78
]
|
34 | 0.34 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 WHERE t0.id = ?
Parameters:
[
1
]
|
35 | 0.48 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 INNER JOIN course_coach_info ON t0.id = course_coach_info.coach_info_id WHERE course_coach_info.course_id = ?
Parameters:
[
294
]
|
36 | 0.55 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 ] |
37 | 0.47 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
]
|
38 | 0.57 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
]
|
39 | 0.34 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
]
|
40 | 0.40 ms |
SELECT COUNT(c0_.id) AS sclr_0 FROM course c0_ WHERE c0_.status = ? AND c0_.owner_id = ?
Parameters:
[ "active" 207 ] |
41 | 0.41 ms |
SELECT COUNT(c0_.id) AS sclr_0 FROM course c0_ WHERE c0_.status = ? AND c0_.owner_id = ?
Parameters:
[ "active" 207 ] |
42 | 0.38 ms |
SELECT t0.id AS id_1, t0.address_id AS address_id_2, t0.course_id AS course_id_3 FROM airport t0 WHERE t0.course_id = ?
Parameters:
[
294
]
|
43 | 0.30 ms |
SELECT t0.id AS id_1, t0.address_id AS address_id_2, t0.course_id AS course_id_3 FROM beach t0 WHERE t0.course_id = ?
Parameters:
[
294
]
|
44 | 0.37 ms |
SELECT t0.id AS id_1, t0.address_id AS address_id_2, t0.course_id AS course_id_3 FROM station t0 WHERE t0.course_id = ?
Parameters:
[
294
]
|
45 | 0.32 ms |
SELECT t0.id AS id_1, t0.address_id AS address_id_2, t0.course_id AS course_id_3 FROM restaurant t0 WHERE t0.course_id = ?
Parameters:
[
294
]
|
46 | 0.30 ms |
SELECT t0.id AS id_1, t0.address_id AS address_id_2, t0.course_id AS course_id_3 FROM accommodation t0 WHERE t0.course_id = ?
Parameters:
[
294
]
|
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.