https://racket-trip.eu/fr/courses-details/7b2302c22c34551e?page=1

Query Metrics

1 Database Queries
1 Different statements
1.13 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.13 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:
[
  "7b2302c22c34551e"
]

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\Course No errors.
App\Entity\ClubInfo No errors.
App\Entity\User No errors.
App\Entity\Club No errors.
App\Entity\Address No errors.
App\Entity\Coach No errors.
App\Entity\Operator No errors.
App\Entity\OperatorInfo 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\Sport No errors.
App\Entity\CourseAvailability No errors.
App\Entity\Language No errors.
App\Entity\FeaturedCourse No errors.
App\Entity\Age No errors.
App\Entity\Level No errors.
App\Entity\Trainee No errors.
App\Entity\TranslatedCourse No errors.
App\Entity\Booking No errors.
App\Entity\CourseViewsStat No errors.
App\Entity\CoachInfo No errors.
App\Entity\PriceBundle No errors.
App\Entity\NoteRequest 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\CourtInfo No errors.
App\Entity\Role No errors.
App\Entity\Subscription No errors.
App\Entity\ProInfo No errors.
App\Entity\StripeInfo 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\Availability No errors.
App\Entity\Partnership No errors.