Query Metrics
14
Database Queries
4
Different statements
8.44 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.25 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.city AS city_3, t0.postal_code AS postal_code_4, t0.country_code AS country_code_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.accommodation AS accommodation_8, t0.date_insert AS date_insert_9, t0.title AS title_10, t0.presentation AS presentation_11, t0.description AS description_12, t0.max_guests AS max_guests_13, t0.nb_bedrooms AS nb_bedrooms_14, t0.nb_double_beds AS nb_double_beds_15, t0.nb_single_beds AS nb_single_beds_16, t0.nb_sofa_beds AS nb_sofa_beds_17, t0.nb_bathrooms_bathtub AS nb_bathrooms_bathtub_18, t0.nb_bathrooms_shower AS nb_bathrooms_shower_19, t0.nb_wc AS nb_wc_20, t0.accommodation_type AS accommodation_type_21, t0.accommodation_category AS accommodation_category_22, t0.accommodation_mood AS accommodation_mood_23, t0.total_floor AS total_floor_24, t0.floor AS floor_25, t0.year_old AS year_old_26, t0.inside_size AS inside_size_27, t0.equipments AS equipments_28, t0.bathroom_equipments AS bathroom_equipments_29, t0.bedroom_equipments AS bedroom_equipments_30, t0.entertainment_equipments AS entertainment_equipments_31, t0.family_equipments AS family_equipments_32, t0.climate_control AS climate_control_33, t0.safety_equipments AS safety_equipments_34, t0.office_equipments AS office_equipments_35, t0.kitchen_dining_equipments AS kitchen_dining_equipments_36, t0.location_features AS location_features_37, t0.outdoor_equipments AS outdoor_equipments_38, t0.facilities AS facilities_39, t0.services AS services_40, t0.accessibility_features AS accessibility_features_41, t0.night_price AS night_price_42, t0.night_price_we AS night_price_we_43, t0.discount_7 AS discount_7_44, t0.discount_28 AS discount_28_45, t0.min_night_booking AS min_night_booking_46, t0.max_night_booking AS max_night_booking_47, t0.before_booking AS before_booking_48, t0.cancellation_rules AS cancellation_rules_49, t0.guide AS guide_50, t0.warnings AS warnings_51, t0.security_devices AS security_devices_52, t0.property_info AS property_info_53, t0.time_arrival AS time_arrival_54, t0.time_departure AS time_departure_55, t0.itinerary AS itinerary_56, t0.arrival_procedure AS arrival_procedure_57, t0.house_manual AS house_manual_58, t0.house_rules AS house_rules_59, t0.other_rules AS other_rules_60, t0.checkout_instructions AS checkout_instructions_61, t0.other_checkout_instructions AS other_checkout_instructions_62, t0.registration_type AS registration_type_63, t0.registration_number AS registration_number_64, t0.fr_tax_collection_type AS fr_tax_collection_type_65, t0.fr_tax_collection_rating AS fr_tax_collection_rating_66, t0.default_calendar AS default_calendar_67, t0.currency AS currency_68, t0.cleaning_fees AS cleaning_fees_69, t0.extra_guest_fees AS extra_guest_fees_70, t0.extra_guest_limit AS extra_guest_limit_71, t0.fr_tax_insee AS fr_tax_insee_72, t0.status AS status_73, t0.user_id AS user_id_74 FROM listing t0 WHERE t0.id = ?
Parameters:
[
13
]
|
2 | 2.12 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.availability AS availability_3, t0.pricing AS pricing_4, t0.sync AS sync_5, t0.listing_id AS listing_id_6 FROM listing_unavailability t0 WHERE t0.listing_id = ? AND t0.availability = ? ORDER BY t0.date ASC
Parameters:
[ 13 1 ] |
3 | 1.76 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.availability AS availability_3, t0.pricing AS pricing_4, t0.sync AS sync_5, t0.listing_id AS listing_id_6 FROM listing_unavailability t0 WHERE t0.listing_id = ? AND t0.availability = ? ORDER BY t0.date ASC
Parameters:
[ 13 0 ] |
4 | 0.49 ms |
SELECT t0.id AS id_1, t0.language AS language_2, t0.name AS name_3, t0.value AS value_4 FROM text_front t0 WHERE t0.language = ? AND t0.name = ? LIMIT 1
Parameters:
[ "fr" "entire_home" ] |
5 | 0.41 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.date_insert AS date_insert_3, t0.spec AS spec_4, t0.ia AS ia_5, t0.ia_place AS ia_place_6, t0.ia_detected_labels AS ia_detected_labels_7, t0.ia_scoring AS ia_scoring_8, t0.listing_id AS listing_id_9 FROM listing_photo t0 WHERE t0.listing_id = ? ORDER BY t0.ia_scoring DESC
Parameters:
[
13
]
|
6 | 0.33 ms |
SELECT t0.id AS id_1, t0.language AS language_2, t0.name AS name_3, t0.value AS value_4 FROM text_front t0 WHERE t0.language = ? AND t0.name = ? LIMIT 1
Parameters:
[ "fr" "apartment" ] |
7 | 0.28 ms |
SELECT t0.id AS id_1, t0.language AS language_2, t0.name AS name_3, t0.value AS value_4 FROM text_front t0 WHERE t0.language = ? AND t0.name = ? LIMIT 1
Parameters:
[ "fr" "entire_home" ] |
8 | 0.28 ms |
SELECT t0.id AS id_1, t0.language AS language_2, t0.name AS name_3, t0.value AS value_4 FROM text_front t0 WHERE t0.language = ? AND t0.name = ? LIMIT 1
Parameters:
[ "fr" "sheets" ] |
9 | 0.32 ms |
SELECT t0.id AS id_1, t0.language AS language_2, t0.name AS name_3, t0.value AS value_4 FROM text_front t0 WHERE t0.language = ? AND t0.name = ? LIMIT 1
Parameters:
[ "fr" "hot_water" ] |
10 | 0.27 ms |
SELECT t0.id AS id_1, t0.language AS language_2, t0.name AS name_3, t0.value AS value_4 FROM text_front t0 WHERE t0.language = ? AND t0.name = ? LIMIT 1
Parameters:
[ "fr" "kitchen" ] |
11 | 0.25 ms |
SELECT t0.id AS id_1, t0.language AS language_2, t0.name AS name_3, t0.value AS value_4 FROM text_front t0 WHERE t0.language = ? AND t0.name = ? LIMIT 1
Parameters:
[ "fr" "hot_water" ] |
12 | 0.24 ms |
SELECT t0.id AS id_1, t0.language AS language_2, t0.name AS name_3, t0.value AS value_4 FROM text_front t0 WHERE t0.language = ? AND t0.name = ? LIMIT 1
Parameters:
[ "fr" "tv" ] |
13 | 0.24 ms |
SELECT t0.id AS id_1, t0.language AS language_2, t0.name AS name_3, t0.value AS value_4 FROM text_front t0 WHERE t0.language = ? AND t0.name = ? LIMIT 1
Parameters:
[ "fr" "wifi" ] |
14 | 0.22 ms |
SELECT t0.id AS id_1, t0.language AS language_2, t0.name AS name_3, t0.value AS value_4 FROM text_front t0 WHERE t0.language = ? AND t0.name = ? LIMIT 1
Parameters:
[ "fr" "flexible" ] |
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\Listing |
|
App\Entity\User | No errors. |
App\Entity\ListingPhoto | No errors. |
App\Entity\ListingUnavailability | No errors. |
App\Entity\TextFront | No errors. |