https://dev.citizens.fr/contact/25

Query Metrics

4 Database Queries
4 Different statements
2.58 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.85 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.virtual_tour AS virtual_tour_3, t0.eco AS eco_4, t0.pet_friendly AS pet_friendly_5, t0.girls_only AS girls_only_6, t0.surface AS surface_7, t0.type AS type_8, t0.construction_year AS construction_year_9, t0.total_bedrooms AS total_bedrooms_10, t0.total_bathrooms AS total_bathrooms_11, t0.total_kitchens AS total_kitchens_12, t0.total_toilets AS total_toilets_13, t0.garden AS garden_14, t0.availability_date AS availability_date_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.deleted AS deleted_19, t0.owner_type AS owner_type_20, t0.square_meter_price AS square_meter_price_21, t0.majored_square_meter_price AS majored_square_meter_price_22, t0.address_id AS address_id_23, t0.description_id AS description_id_24, t0.cover_id AS cover_id_25, t0.plan_id AS plan_id_26, t0.access_id AS access_id_27, t0.address_area_id AS address_area_id_28, t0.district_id AS district_id_29, t0.owner_id AS owner_id_30, t0.owner_info_id AS owner_info_id_31, t0.info_id AS info_id_32, t0.cleaning_recurrence_id AS cleaning_recurrence_id_33, t34.id AS id_35, t34.created_at AS created_at_36, t34.updated_at AS updated_at_37, t34.accommodation_id AS accommodation_id_38 FROM cal_accommodation t0 LEFT JOIN cal_workflow_project t34 ON t34.accommodation_id = t0.id WHERE t0.id = ?
Parameters:
[
  "25"
]
2 0.76 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:
[
  38
]
3 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.id = ?
Parameters:
[
  130
]
4 0.58 ms
SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?
Parameters:
[
  25
]

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\AddressArea 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\BigBrotherRequest 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.