Query Metrics
12
Database Queries
6
Different statements
16.80 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.90 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image_name AS image_name_5, t0.image_size AS image_size_6, t0.capacity AS capacity_7, t0.price_per_half_hour AS price_per_half_hour_8, t0.price_per_hour AS price_per_hour_9, t0.price_per_half_day AS price_per_half_day_10, t0.price_per_day AS price_per_day_11, t0.price_per_evening AS price_per_evening_12, t0.content AS content_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.meta_description AS meta_description_16, t0.content_description AS content_description_17 FROM space t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"la-salle-des-machines"
]
|
2 | 1.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM space_feature t0 INNER JOIN space_space_feature ON t0.id = space_space_feature.space_feature_id WHERE space_space_feature.space_id = ?
Parameters:
[
9
]
|
3 | 0.96 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image_name AS image_name_5, t0.image_size AS image_size_6, t0.capacity AS capacity_7, t0.price_per_half_hour AS price_per_half_hour_8, t0.price_per_hour AS price_per_hour_9, t0.price_per_half_day AS price_per_half_day_10, t0.price_per_day AS price_per_day_11, t0.price_per_evening AS price_per_evening_12, t0.content AS content_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.meta_description AS meta_description_16, t0.content_description AS content_description_17, t18.id AS id_19, t18.title AS title_20, t18.slug AS slug_21, t18.begin_at AS begin_at_22, t18.end_at AS end_at_23, t18.description AS description_24, t18.image_name AS image_name_25, t18.image_size AS image_size_26, t18.created_at AS created_at_27, t18.updated_at AS updated_at_28, t18.ticket_quantity AS ticket_quantity_29, t18.price AS price_30, t18.category_id AS category_id_31, t18.space_id AS space_id_32, t18.organizer_id AS organizer_id_33 FROM space t0 LEFT JOIN local_event t18 ON t18.space_id = t0.id INNER JOIN space_space_feature ON t0.id = space_space_feature.space_id WHERE space_space_feature.space_feature_id = ?
Parameters:
[
1
]
|
4 | 0.66 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image_name AS image_name_5, t0.image_size AS image_size_6, t0.capacity AS capacity_7, t0.price_per_half_hour AS price_per_half_hour_8, t0.price_per_hour AS price_per_hour_9, t0.price_per_half_day AS price_per_half_day_10, t0.price_per_day AS price_per_day_11, t0.price_per_evening AS price_per_evening_12, t0.content AS content_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.meta_description AS meta_description_16, t0.content_description AS content_description_17, t18.id AS id_19, t18.title AS title_20, t18.slug AS slug_21, t18.begin_at AS begin_at_22, t18.end_at AS end_at_23, t18.description AS description_24, t18.image_name AS image_name_25, t18.image_size AS image_size_26, t18.created_at AS created_at_27, t18.updated_at AS updated_at_28, t18.ticket_quantity AS ticket_quantity_29, t18.price AS price_30, t18.category_id AS category_id_31, t18.space_id AS space_id_32, t18.organizer_id AS organizer_id_33 FROM space t0 LEFT JOIN local_event t18 ON t18.space_id = t0.id INNER JOIN space_space_feature ON t0.id = space_space_feature.space_id WHERE space_space_feature.space_feature_id = ?
Parameters:
[
2
]
|
5 | 0.58 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image_name AS image_name_5, t0.image_size AS image_size_6, t0.capacity AS capacity_7, t0.price_per_half_hour AS price_per_half_hour_8, t0.price_per_hour AS price_per_hour_9, t0.price_per_half_day AS price_per_half_day_10, t0.price_per_day AS price_per_day_11, t0.price_per_evening AS price_per_evening_12, t0.content AS content_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.meta_description AS meta_description_16, t0.content_description AS content_description_17, t18.id AS id_19, t18.title AS title_20, t18.slug AS slug_21, t18.begin_at AS begin_at_22, t18.end_at AS end_at_23, t18.description AS description_24, t18.image_name AS image_name_25, t18.image_size AS image_size_26, t18.created_at AS created_at_27, t18.updated_at AS updated_at_28, t18.ticket_quantity AS ticket_quantity_29, t18.price AS price_30, t18.category_id AS category_id_31, t18.space_id AS space_id_32, t18.organizer_id AS organizer_id_33 FROM space t0 LEFT JOIN local_event t18 ON t18.space_id = t0.id INNER JOIN space_space_feature ON t0.id = space_space_feature.space_id WHERE space_space_feature.space_feature_id = ?
Parameters:
[
3
]
|
6 | 0.66 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image_name AS image_name_5, t0.image_size AS image_size_6, t0.capacity AS capacity_7, t0.price_per_half_hour AS price_per_half_hour_8, t0.price_per_hour AS price_per_hour_9, t0.price_per_half_day AS price_per_half_day_10, t0.price_per_day AS price_per_day_11, t0.price_per_evening AS price_per_evening_12, t0.content AS content_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.meta_description AS meta_description_16, t0.content_description AS content_description_17, t18.id AS id_19, t18.title AS title_20, t18.slug AS slug_21, t18.begin_at AS begin_at_22, t18.end_at AS end_at_23, t18.description AS description_24, t18.image_name AS image_name_25, t18.image_size AS image_size_26, t18.created_at AS created_at_27, t18.updated_at AS updated_at_28, t18.ticket_quantity AS ticket_quantity_29, t18.price AS price_30, t18.category_id AS category_id_31, t18.space_id AS space_id_32, t18.organizer_id AS organizer_id_33 FROM space t0 LEFT JOIN local_event t18 ON t18.space_id = t0.id INNER JOIN space_space_feature ON t0.id = space_space_feature.space_id WHERE space_space_feature.space_feature_id = ?
Parameters:
[
4
]
|
7 | 0.45 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM space_feature t0 INNER JOIN space_space_feature ON t0.id = space_space_feature.space_feature_id WHERE space_space_feature.space_id = ?
Parameters:
[
10
]
|
8 | 1.00 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.begin_at AS begin_at_4, t0.end_at AS end_at_5, t0.description AS description_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.ticket_quantity AS ticket_quantity_11, t0.price AS price_12, t0.category_id AS category_id_13, t14.id AS id_15, t14.name AS name_16, t14.slug AS slug_17, t14.meta_description AS meta_description_18, t14.content_description AS content_description_19, t0.space_id AS space_id_20, t21.id AS id_22, t21.name AS name_23, t21.slug AS slug_24, t21.description AS description_25, t21.image_name AS image_name_26, t21.image_size AS image_size_27, t21.capacity AS capacity_28, t21.price_per_half_hour AS price_per_half_hour_29, t21.price_per_hour AS price_per_hour_30, t21.price_per_half_day AS price_per_half_day_31, t21.price_per_day AS price_per_day_32, t21.price_per_evening AS price_per_evening_33, t21.content AS content_34, t21.created_at AS created_at_35, t21.updated_at AS updated_at_36, t21.meta_description AS meta_description_37, t21.content_description AS content_description_38, t0.organizer_id AS organizer_id_39, t40.id AS id_41, t40.email AS email_42, t40.roles AS roles_43, t40.password AS password_44, t40.username AS username_45, t40.firstname AS firstname_46, t40.lastname AS lastname_47, t40.gender AS gender_48, t40.phone AS phone_49, t40.created_at AS created_at_50, t40.born_at AS born_at_51, t40.updated_at AS updated_at_52, t40.is_pro AS is_pro_53, t54.id AS id_55, t54.quantity AS quantity_56, t54.created_at AS created_at_57, t54.customer_id AS customer_id_58, t54.local_event_id AS local_event_id_59 FROM local_event t0 INNER JOIN local_event_category t14 ON t0.category_id = t14.id LEFT JOIN space t21 ON t0.space_id = t21.id LEFT JOIN user t40 ON t0.organizer_id = t40.id LEFT JOIN ticketing t54 ON t54.local_event_id = t0.id WHERE t0.space_id = ?
Parameters:
[
9
]
|
9 | 5.23 ms |
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.slug AS slug_2, l0_.begin_at AS begin_at_3, l0_.end_at AS end_at_4, l0_.description AS description_5, l0_.image_name AS image_name_6, l0_.image_size AS image_size_7, l0_.created_at AS created_at_8, l0_.updated_at AS updated_at_9, l0_.ticket_quantity AS ticket_quantity_10, l0_.price AS price_11, l0_.category_id AS category_id_12, l0_.space_id AS space_id_13, l0_.organizer_id AS organizer_id_14 FROM local_event l0_ WHERE l0_.space_id = ? AND l0_.end_at <= ? ORDER BY l0_.end_at DESC LIMIT 2
Parameters:
[ 9 "2025-08-12 17:24:22" ] |
10 | 1.58 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image_name AS image_name_5, t0.image_size AS image_size_6, t0.capacity AS capacity_7, t0.price_per_half_hour AS price_per_half_hour_8, t0.price_per_hour AS price_per_hour_9, t0.price_per_half_day AS price_per_half_day_10, t0.price_per_day AS price_per_day_11, t0.price_per_evening AS price_per_evening_12, t0.content AS content_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.meta_description AS meta_description_16, t0.content_description AS content_description_17, t18.id AS id_19, t18.title AS title_20, t18.slug AS slug_21, t18.begin_at AS begin_at_22, t18.end_at AS end_at_23, t18.description AS description_24, t18.image_name AS image_name_25, t18.image_size AS image_size_26, t18.created_at AS created_at_27, t18.updated_at AS updated_at_28, t18.ticket_quantity AS ticket_quantity_29, t18.price AS price_30, t18.category_id AS category_id_31, t18.space_id AS space_id_32, t18.organizer_id AS organizer_id_33 FROM space t0 LEFT JOIN local_event t18 ON t18.space_id = t0.id
Parameters:
[] |
11 | 3.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM space_feature t0 INNER JOIN space_space_feature ON t0.id = space_space_feature.space_feature_id WHERE space_space_feature.space_id = ?
Parameters:
[
11
]
|
12 | 0.48 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM space_feature t0 INNER JOIN space_space_feature ON t0.id = space_space_feature.space_feature_id WHERE space_space_feature.space_id = ?
Parameters:
[
12
]
|
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\Space | No errors. |
App\Entity\Booking | No errors. |
App\Entity\SpaceFeature | No errors. |
App\Entity\LocalEvent | No errors. |
App\Entity\LocalEventCategory | No errors. |
App\Entity\User | No errors. |
App\Entity\Ticketing | No errors. |
App\Entity\LocalEventTag | No errors. |
App\Entity\Group | No errors. |
App\Entity\Category | No errors. |
App\Entity\Article | No errors. |
App\Entity\Newsletter | No errors. |
App\Entity\Contact | No errors. |
Vich\UploaderBundle\Entity\File | No errors. |