Query Metrics
4
Database Queries
4
Different statements
1.44 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.41 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.logo AS logo_4, t0.website_url AS website_url_5, t0.facebook_url AS facebook_url_6, t0.twitter_url AS twitter_url_7, t0.instagram_url AS instagram_url_8, t0.dailymotion_url AS dailymotion_url_9, t0.youtube_url AS youtube_url_10, t0.mailing_list AS mailing_list_11, t0.active AS active_12, t0.contact_emails AS contact_emails_13, t0.contact_phone AS contact_phone_14, t0.price_cenacle_joining AS price_cenacle_joining_15, t0.price_base_subscribe AS price_base_subscribe_16 FROM club t0 WHERE t0.uuid = ?
Parameters:
[
"sudouest"
]
|
| 2 | 0.51 ms |
SELECT les.club_id AS club_id, loc.* FROM club_lesson les JOIN club_location loc ON les.club_location_id = loc.id WHERE les.club_id IN (?) GROUP BY 1, 2
Parameters:
[
41
]
|
| 3 | 0.31 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.discipline AS discipline_3, t0.category AS category_4, t0.comment AS comment_5, t0.price_child_1 AS price_child_1_6, t0.price_child_2 AS price_child_2_7, t0.price_child_3 AS price_child_3_8, t0.price_adult AS price_adult_9, t0.club_id AS club_id_10 FROM club_price t0 WHERE t0.club_id IN (?)
Parameters:
[
41
]
|
| 4 | 0.21 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.value AS value_4, t0.club_id AS club_id_5 FROM club_property t0 WHERE t0.club_id IN (?)
Parameters:
[
41
]
|
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\Club | No errors. |
| App\Entity\ClubLesson | No errors. |
| App\Entity\UserClubSubscribe | No errors. |
| App\Entity\ClubProperty | No errors. |
| App\Entity\ClubLocation | No errors. |
| App\Entity\ClubPrice | No errors. |