https://racket-trip.eu/en

Query Metrics

39 Database Queries
21 Different statements
21.09 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

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.

Entities Mapping

Class Mapping errors
App\Entity\Sport No errors.
App\Entity\CourtInfo No errors.
App\Entity\ProInfo No errors.
App\Entity\SportTrainee No errors.
App\Entity\Course No errors.
App\Entity\Availability No errors.
App\Entity\Age No errors.
App\Entity\Level No errors.
App\Entity\Language No errors.
App\Entity\User No errors.
App\Entity\Article No errors.
App\Entity\WebsiteLanguage No errors.
App\Entity\Admin No errors.
App\Entity\HomeSlider No errors.
App\Entity\FeaturedCourse No errors.
App\Entity\FeaturedOffer No errors.
App\Entity\ClubInfo No errors.
App\Entity\Address No errors.
App\Entity\OperatorInfo No errors.
App\Entity\Coach No errors.
App\Entity\Club No errors.
App\Entity\Operator No errors.
App\Entity\Trainee No errors.
App\Entity\Photo No errors.
App\Entity\Video No errors.
App\Entity\Airport No errors.
App\Entity\Beach No errors.
App\Entity\Station No errors.
App\Entity\Restaurant No errors.
App\Entity\Accommodation No errors.
App\Entity\StripeInfo No errors.
App\Entity\Role No errors.
App\Entity\Subscription No errors.
App\Entity\Message No errors.
App\Entity\Participant No errors.
App\Entity\Conversation No errors.
App\Entity\ProViewsStat No errors.
App\Entity\Invoice No errors.
App\Entity\ProDescription No errors.
App\Entity\Note
  • The mappings App\Entity\Note#trainee and App\Entity\Trainee#notes are inconsistent with each other.
  • If association App\Entity\Note#trainee is many-to-one, then the inversed side App\Entity\Trainee#notes has to be one-to-many.
App\Entity\NoteRequest No errors.
App\Entity\CoachInfo No errors.
App\Entity\Formation No errors.
App\Entity\Experience No errors.
App\Entity\Partnership No errors.
App\Entity\CourseAvailability No errors.
App\Entity\TranslatedCourse No errors.
App\Entity\Booking No errors.
App\Entity\CourseViewsStat No errors.
App\Entity\PriceBundle No errors.
App\Entity\Media No errors.
App\Entity\Planning No errors.
App\Entity\Sponsor No errors.
App\Entity\Label No errors.