Query Metrics
9
Database Queries
3
Different statements
5.49 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.11 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:
[] |
| 2 | 0.78 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.65 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.61 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.54 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.64 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.41 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 | 0.37 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
]
|
| 9 | 0.37 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\LocalEvent | No errors. |
| App\Entity\LocalEventCategory | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Booking | No errors. |
| App\Entity\SpaceFeature | No errors. |
| App\Entity\LocalEventTag | No errors. |
| App\Entity\Ticketing | No errors. |
| App\Entity\Group | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Article | No errors. |
| App\Entity\Newsletter | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |