https://vps.citizens.fr/colocation/36

Query Metrics

144 Database Queries
14 Different statements
52.85 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.96 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.virtual_tour AS virtual_tour_3, t0.pet_friendly AS pet_friendly_4, t0.girls_only AS girls_only_5, t0.surface AS surface_6, t0.type AS type_7, t0.construction_year AS construction_year_8, t0.total_bedrooms AS total_bedrooms_9, t0.total_bathrooms AS total_bathrooms_10, t0.total_kitchens AS total_kitchens_11, t0.total_toilets AS total_toilets_12, t0.garden AS garden_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.disabled AS disabled_16, t0.owner_type AS owner_type_17, t0.square_meter_price AS square_meter_price_18, t0.majored_square_meter_price AS majored_square_meter_price_19, t0.address_id AS address_id_20, t0.description_id AS description_id_21, t0.cover_id AS cover_id_22, t0.plan_id AS plan_id_23, t0.access_id AS access_id_24, t0.district_id AS district_id_25, t0.owner_id AS owner_id_26, t0.owner_info_id AS owner_info_id_27, t0.info_id AS info_id_28, t0.cleaning_recurrence_id AS cleaning_recurrence_id_29, t30.id AS id_31, t30.created_at AS created_at_32, t30.updated_at AS updated_at_33, t30.accommodation_id AS accommodation_id_34 FROM cal_accommodation t0 LEFT JOIN cal_workflow_project t30 ON t30.accommodation_id = t0.id WHERE t0.id = ?
Parameters:
[
  "36"
]
2 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.id = ?
Parameters:
[
  385
]
3 0.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC
Parameters:
[
  36
]
4 0.37 ms
SELECT t0.id AS id_1, t0.auto_lat_lng AS auto_lat_lng_2, t0.alias AS alias_3, t0.name AS name_4, t0.address AS address_5, t0.zipcode AS zipcode_6, t0.city AS city_7, t0.country AS country_8, t0.informations AS informations_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11 FROM cal_address t0 WHERE t0.id = ?
Parameters:
[
  49
]
5 0.60 ms
SELECT t0.id AS id_1, t0.surface AS surface_2, t0.private_bathroom AS private_bathroom_3, t0.private_toilet AS private_toilet_4, t0.private_kitchen AS private_kitchen_5, t0.max_housing_assistance AS max_housing_assistance_6, t0.rent AS rent_7, t0.additional_rent AS additional_rent_8, t0.additional_rent_details AS additional_rent_details_9, t0.entrance_fees AS entrance_fees_10, t0.charges_fees AS charges_fees_11, t0.services_fees AS services_fees_12, t0.cleaning_fees AS cleaning_fees_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.disabled AS disabled_16, t0.ongoing_booking AS ongoing_booking_17, t0.accommodation_id AS accommodation_id_18, t0.name_id AS name_id_19, t0.description_id AS description_id_20, t0.occupancy_id AS occupancy_id_21, t0.stats_id AS stats_id_22 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?
Parameters:
[
  36
]
6 0.84 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?
Parameters:
[
  36
]
7 0.51 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  19
]
8 0.37 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  432
]
9 0.75 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_equipments ON t0.id = cal_accommodations_equipments.property_list_item_id WHERE cal_accommodations_equipments.accommodation_id = ?
Parameters:
[
  36
]
10 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  1
]
11 0.29 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  21
]
12 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  2
]
13 0.29 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  22
]
14 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  3
]
15 0.27 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  23
]
16 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  4
]
17 0.26 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  25
]
18 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  7
]
19 0.27 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  57
]
20 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  13
]
21 0.32 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  244
]
22 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  14
]
23 0.32 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  245
]
24 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  15
]
25 0.28 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  246
]
26 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  16
]
27 0.29 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  267
]
28 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  17
]
29 0.31 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  268
]
30 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  18
]
31 0.29 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  269
]
32 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  19
]
33 0.31 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  270
]
34 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  20
]
35 0.31 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  271
]
36 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  21
]
37 0.28 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  272
]
38 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  22
]
39 0.30 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  273
]
40 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  23
]
41 0.25 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  274
]
42 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  24
]
43 0.31 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  275
]
44 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  25
]
45 0.33 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  276
]
46 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  26
]
47 0.26 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  277
]
48 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  27
]
49 0.27 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  278
]
50 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  28
]
51 0.31 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  279
]
52 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  29
]
53 0.30 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  280
]
54 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  34
]
55 0.28 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  355
]
56 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  35
]
57 0.29 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  356
]
58 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  36
]
59 0.31 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  357
]
60 0.51 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_services ON t0.id = cal_accommodations_services.property_list_item_id WHERE cal_accommodations_services.accommodation_id = ?
Parameters:
[
  36
]
61 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  8
]
62 0.33 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  32
]
63 0.31 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  58
]
64 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  11
]
65 0.35 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  33
]
66 0.37 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  59
]
67 0.64 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_universities ON t0.id = cal_accommodations_universities.property_list_item_id WHERE cal_accommodations_universities.accommodation_id = ?
Parameters:
[
  36
]
68 0.47 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  858
]
69 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.room_id = ? ORDER BY t0.position ASC
Parameters:
[
  118
]
70 0.30 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  433
]
71 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.room_id = ? ORDER BY t0.position ASC
Parameters:
[
  119
]
72 0.29 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  435
]
73 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.room_id = ? ORDER BY t0.position ASC
Parameters:
[
  317
]
74 0.30 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  971
]
75 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.room_id = ? ORDER BY t0.position ASC
Parameters:
[
  318
]
76 0.33 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  973
]
77 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.room_id = ? ORDER BY t0.position ASC
Parameters:
[
  319
]
78 0.28 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  975
]
79 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.room_id = ? ORDER BY t0.position ASC
Parameters:
[
  320
]
80 0.40 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  977
]
81 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.room_id = ? ORDER BY t0.position ASC
Parameters:
[
  321
]
82 0.32 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  979
]
83 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.room_id = ? ORDER BY t0.position ASC
Parameters:
[
  322
]
84 0.36 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  981
]
85 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.room_id = ? ORDER BY t0.position ASC
Parameters:
[
  323
]
86 0.35 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  983
]
87 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.room_id = ? ORDER BY t0.position ASC
Parameters:
[
  324
]
88 0.33 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  985
]
89 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.room_id = ? ORDER BY t0.position ASC
Parameters:
[
  402
]
90 0.32 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  1338
]
91 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.room_id = ? ORDER BY t0.position ASC
Parameters:
[
  403
]
92 0.35 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  1340
]
93 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.room_id = ? ORDER BY t0.position ASC
Parameters:
[
  404
]
94 0.35 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  1342
]
95 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.id = ?
Parameters:
[
  1024
]
96 0.35 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  434
]
97 0.53 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_equipments ON t0.id = cal_accommodation_rooms_equipments.property_list_item_id WHERE cal_accommodation_rooms_equipments.accommodation_room_id = ?
Parameters:
[
  118
]
98 0.52 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_charges_details ON t0.id = cal_accommodation_rooms_charges_details.property_list_item_id WHERE cal_accommodation_rooms_charges_details.accommodation_room_id = ?
Parameters:
[
  118
]
99 0.35 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  52
]
100 0.34 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  53
]
101 0.34 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  54
]
102 0.33 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  55
]
103 0.34 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  56
]
104 0.33 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  219
]
105 0.25 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  220
]
106 0.27 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  221
]
107 0.33 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  436
]
108 0.37 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_equipments ON t0.id = cal_accommodation_rooms_equipments.property_list_item_id WHERE cal_accommodation_rooms_equipments.accommodation_room_id = ?
Parameters:
[
  119
]
109 0.39 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_charges_details ON t0.id = cal_accommodation_rooms_charges_details.property_list_item_id WHERE cal_accommodation_rooms_charges_details.accommodation_room_id = ?
Parameters:
[
  119
]
110 0.33 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  972
]
111 0.39 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_equipments ON t0.id = cal_accommodation_rooms_equipments.property_list_item_id WHERE cal_accommodation_rooms_equipments.accommodation_room_id = ?
Parameters:
[
  317
]
112 0.53 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_charges_details ON t0.id = cal_accommodation_rooms_charges_details.property_list_item_id WHERE cal_accommodation_rooms_charges_details.accommodation_room_id = ?
Parameters:
[
  317
]
113 0.33 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  974
]
114 0.54 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_equipments ON t0.id = cal_accommodation_rooms_equipments.property_list_item_id WHERE cal_accommodation_rooms_equipments.accommodation_room_id = ?
Parameters:
[
  318
]
115 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4 FROM cal_media t0 WHERE t0.id = ?
Parameters:
[
  37
]
116 0.36 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  993
]
117 0.41 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_charges_details ON t0.id = cal_accommodation_rooms_charges_details.property_list_item_id WHERE cal_accommodation_rooms_charges_details.accommodation_room_id = ?
Parameters:
[
  318
]
118 0.36 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  976
]
119 0.47 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_equipments ON t0.id = cal_accommodation_rooms_equipments.property_list_item_id WHERE cal_accommodation_rooms_equipments.accommodation_room_id = ?
Parameters:
[
  319
]
120 0.47 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_charges_details ON t0.id = cal_accommodation_rooms_charges_details.property_list_item_id WHERE cal_accommodation_rooms_charges_details.accommodation_room_id = ?
Parameters:
[
  319
]
121 0.30 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  978
]
122 0.42 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_equipments ON t0.id = cal_accommodation_rooms_equipments.property_list_item_id WHERE cal_accommodation_rooms_equipments.accommodation_room_id = ?
Parameters:
[
  320
]
123 0.42 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_charges_details ON t0.id = cal_accommodation_rooms_charges_details.property_list_item_id WHERE cal_accommodation_rooms_charges_details.accommodation_room_id = ?
Parameters:
[
  320
]
124 0.32 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  980
]
125 0.42 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_equipments ON t0.id = cal_accommodation_rooms_equipments.property_list_item_id WHERE cal_accommodation_rooms_equipments.accommodation_room_id = ?
Parameters:
[
  321
]
126 0.42 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_charges_details ON t0.id = cal_accommodation_rooms_charges_details.property_list_item_id WHERE cal_accommodation_rooms_charges_details.accommodation_room_id = ?
Parameters:
[
  321
]
127 0.31 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  982
]
128 0.44 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_equipments ON t0.id = cal_accommodation_rooms_equipments.property_list_item_id WHERE cal_accommodation_rooms_equipments.accommodation_room_id = ?
Parameters:
[
  322
]
129 0.40 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_charges_details ON t0.id = cal_accommodation_rooms_charges_details.property_list_item_id WHERE cal_accommodation_rooms_charges_details.accommodation_room_id = ?
Parameters:
[
  322
]
130 0.27 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  984
]
131 0.34 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_equipments ON t0.id = cal_accommodation_rooms_equipments.property_list_item_id WHERE cal_accommodation_rooms_equipments.accommodation_room_id = ?
Parameters:
[
  323
]
132 0.39 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_charges_details ON t0.id = cal_accommodation_rooms_charges_details.property_list_item_id WHERE cal_accommodation_rooms_charges_details.accommodation_room_id = ?
Parameters:
[
  323
]
133 0.29 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  986
]
134 0.44 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_equipments ON t0.id = cal_accommodation_rooms_equipments.property_list_item_id WHERE cal_accommodation_rooms_equipments.accommodation_room_id = ?
Parameters:
[
  324
]
135 0.50 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_charges_details ON t0.id = cal_accommodation_rooms_charges_details.property_list_item_id WHERE cal_accommodation_rooms_charges_details.accommodation_room_id = ?
Parameters:
[
  324
]
136 0.34 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  1339
]
137 0.45 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_equipments ON t0.id = cal_accommodation_rooms_equipments.property_list_item_id WHERE cal_accommodation_rooms_equipments.accommodation_room_id = ?
Parameters:
[
  402
]
138 0.43 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_charges_details ON t0.id = cal_accommodation_rooms_charges_details.property_list_item_id WHERE cal_accommodation_rooms_charges_details.accommodation_room_id = ?
Parameters:
[
  402
]
139 0.36 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  1341
]
140 0.40 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_equipments ON t0.id = cal_accommodation_rooms_equipments.property_list_item_id WHERE cal_accommodation_rooms_equipments.accommodation_room_id = ?
Parameters:
[
  403
]
141 0.45 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_charges_details ON t0.id = cal_accommodation_rooms_charges_details.property_list_item_id WHERE cal_accommodation_rooms_charges_details.accommodation_room_id = ?
Parameters:
[
  403
]
142 0.35 ms
SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?
Parameters:
[
  1343
]
143 0.45 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_equipments ON t0.id = cal_accommodation_rooms_equipments.property_list_item_id WHERE cal_accommodation_rooms_equipments.accommodation_room_id = ?
Parameters:
[
  404
]
144 0.44 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodation_rooms_charges_details ON t0.id = cal_accommodation_rooms_charges_details.property_list_item_id WHERE cal_accommodation_rooms_charges_details.accommodation_room_id = ?
Parameters:
[
  404
]

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\User No errors.
App\Entity\Accommodation No errors.
App\Entity\Address No errors.
App\Entity\Translation No errors.
App\Entity\AccommodationImage No errors.
App\Entity\PropertyListItem No errors.
App\Entity\AccommodationOwnerInfo No errors.
App\Entity\AccommodationInfo No errors.
App\Entity\CleaningRecurrence No errors.
App\Entity\WorkflowProject No errors.
App\Entity\AccommodationRoom No errors.
App\Entity\AccommodationReport No errors.
App\Entity\Booking No errors.
App\Entity\AccommodationZone No errors.
App\Entity\Maintenance No errors.
App\Entity\Survey No errors.
App\Entity\CleaningDate No errors.
App\Entity\Insurance No errors.
App\Entity\WorkflowStatus No errors.
App\Entity\WorkflowStatusHistory No errors.
App\Entity\WorkflowStatusDate No errors.
App\Entity\WorkflowData No errors.
App\Entity\AccommodationOccupancy No errors.
App\Entity\RoomStats No errors.
App\Entity\BookingRoom No errors.
App\Entity\UserInfo No errors.
App\Entity\Media No errors.
App\Entity\PropertyList No errors.