Query Metrics
39
Database Queries
21
Different statements
21.09 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
4.86 ms (23.04%) |
12 |
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
]
|
1.39 ms (6.60%) |
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_ INNER JOIN user u1_ ON c0_.owner_id = u1_.id LEFT JOIN coach c2_ ON u1_.id = c2_.id LEFT JOIN club c3_ ON u1_.id = c3_.id LEFT JOIN operator o4_ ON u1_.id = o4_.id LEFT JOIN trainee t5_ ON u1_.id = t5_.id LEFT JOIN admin a6_ ON u1_.id = a6_.id INNER JOIN pro_info p7_ ON u1_.pro_info_id = p7_.id INNER JOIN featured_course f8_ ON c0_.id = f8_.course_id INNER JOIN featured_offer f9_ ON f8_.featured_offer_id = f9_.id WHERE c0_.status LIKE 'active' AND u1_.status = ? AND p7_.have_subscription = ? AND p7_.is_hidden = ? AND f9_.type = ? AND f8_.status = ? ORDER BY c0_.created_at DESC LIMIT 12
Parameters:
[ "online" 1 0 "homepage" "active" ] |
1.22 ms (5.78%) |
2 |
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
]
|
1.13 ms (5.37%) |
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_ INNER JOIN user u1_ ON c0_.owner_id = u1_.id LEFT JOIN coach c2_ ON u1_.id = c2_.id LEFT JOIN club c3_ ON u1_.id = c3_.id LEFT JOIN operator o4_ ON u1_.id = o4_.id LEFT JOIN trainee t5_ ON u1_.id = t5_.id LEFT JOIN admin a6_ ON u1_.id = a6_.id INNER JOIN pro_info p7_ ON u1_.pro_info_id = p7_.id WHERE u1_.status = ? AND p7_.is_hidden = ? AND p7_.have_subscription = ? AND c0_.status LIKE 'active' ORDER BY c0_.created_at DESC LIMIT 12
Parameters:
[ "online" 0 1 ] |
1.13 ms (5.34%) |
2 |
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
]
|
1.10 ms (5.20%) |
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.id = ?
Parameters:
[
207
]
|
0.96 ms (4.53%) |
1 |
SELECT h0_.id AS id_0, h0_.title AS title_1, h0_.description AS description_2, h0_.image AS image_3, h0_.link AS link_4, h0_.unit AS unit_5, h0_.original AS original_6, h0_.number AS number_7, h0_.website_language_id AS website_language_id_8 FROM home_slider h0_ INNER JOIN website_language w1_ ON h0_.website_language_id = w1_.id WHERE w1_.slug = ? ORDER BY h0_.number + 0 ASC
Parameters:
[
"en"
]
|
0.91 ms (4.33%) |
1 |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.created_date AS created_date_3, a0_.slug AS slug_4, a0_.cover AS cover_5, a0_.views AS views_6, a0_.published AS published_7, a0_.status AS status_8, a0_.featured AS featured_9, a0_.featured_at AS featured_at_10, a0_.original AS original_11, a0_.unit AS unit_12, a0_.alt_cover AS alt_cover_13, a0_.title_seo AS title_seo_14, a0_.description_seo AS description_seo_15, a0_.published_at AS published_at_16, a0_.author_id AS author_id_17, a0_.reviewer_id AS reviewer_id_18, a0_.website_language_id AS website_language_id_19 FROM article a0_ INNER JOIN website_language w1_ ON a0_.website_language_id = w1_.id WHERE a0_.published = ? AND w1_.slug = ? ORDER BY a0_.created_date DESC LIMIT 4
Parameters:
[ 1 "en" ] |
0.91 ms (4.33%) |
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:
[ 161 207 ] |
0.91 ms (4.33%) |
2 |
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.image AS image_2, m0_.original AS original_3, m0_.unit AS unit_4, m0_.link AS link_5, m0_.website_language_id AS website_language_id_6 FROM media m0_ INNER JOIN website_language w1_ ON m0_.website_language_id = w1_.id WHERE w1_.slug = ?
Parameters:
[
"en"
]
|
0.83 ms (3.92%) |
2 |
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
]
|
0.77 ms (3.64%) |
1 |
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
]
|
0.76 ms (3.61%) |
2 |
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
]
|
0.70 ms (3.32%) |
2 |
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
]
|
0.68 ms (3.21%) |
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.id IN (?)
Parameters:
[
78
]
|
0.62 ms (2.93%) |
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:
[
161
]
|
0.58 ms (2.73%) |
1 |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.icon AS icon_3, s0_.status AS status_4, s0_.appearance AS appearance_5 FROM sport s0_ WHERE s0_.status = ? ORDER BY s0_.appearance ASC
Parameters:
[
"visible"
]
|
0.52 ms (2.46%) |
1 |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2 FROM age a0_
Parameters:
[] |
0.46 ms (2.19%) |
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:
[
161
]
|
0.37 ms (1.73%) |
1 |
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.slug AS slug_2 FROM LEVEL l0_
Parameters:
[] |
0.30 ms (1.41%) |
1 |
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.slug AS slug_2 FROM language l0_
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.