GET https://api.le-nautilus.org/espace-coworking-perpignan/la-salle-des-machines

Query Metrics

12 Database Queries
6 Different statements
16.80 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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