GET http://57.128.16.253/listing/1

Query Metrics

88 Database Queries
5 Different statements
32.03 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.93 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:
[
  1
]
2 1.92 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:
[
  1
  1
]
3 1.77 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:
[
  1
  0
]
4 0.40 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 2.40 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:
[
  1
]
6 0.38 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"
  "house"
]
7 0.26 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"
  "cottage"
]
8 0.46 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.date_insert AS date_insert_4, t0.stripe_account_id AS stripe_account_id_5, t0.stripe_customer_id AS stripe_customer_id_6, t0.phone AS phone_7, t0.fname AS fname_8, t0.lname AS lname_9, t0.date_of_birth AS date_of_birth_10, t0.gender AS gender_11, t0.nationality AS nationality_12, t0.usual_name AS usual_name_13, t0.veriff_status AS veriff_status_14, t0.profile_presentation AS profile_presentation_15, t0.profile_airbnb AS profile_airbnb_16, t0.profile_linkedin AS profile_linkedin_17, t0.profile_facebook AS profile_facebook_18, t0.profile_instagram AS profile_instagram_19, t0.profile_photo AS profile_photo_20, t0.profile_city AS profile_city_21, t0.profile_country AS profile_country_22, t0.profile_airbnb_score AS profile_airbnb_score_23, t0.profile_airbnb_ratings AS profile_airbnb_ratings_24, t0.profile_airbnb_last_crawl AS profile_airbnb_last_crawl_25, t0.seed AS seed_26, t0.email_status AS email_status_27, t0.pending_email AS pending_email_28, t0.token AS token_29, t0.is_deleted AS is_deleted_30 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  2
]
9 0.29 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"
  "hangers"
]
10 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"
  "sheets"
]
11 0.34 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"
  "wardrobe_storage"
]
12 0.40 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"
  "iron"
]
13 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"
  "washing_machine"
]
14 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"
  "extra_pillows_blankets"
]
15 0.37 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"
  "blinds"
]
16 0.29 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"
  "dryer"
]
17 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"
  "basic_amenities"
]
18 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"
  "clothes_drying_rack"
]
19 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"
  "conditioner"
]
20 0.23 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"
  "bathtub"
]
21 0.21 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"
  "outdoor_shower"
]
22 0.30 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"
]
23 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"
  "body_wash"
]
24 0.31 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"
  "cleaning_products"
]
25 0.38 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"
  "body_soap"
]
26 0.37 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"
  "shampoo"
]
27 0.31 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"
  "hair_dryer"
]
28 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"
  "air_conditioning"
]
29 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"
  "kitchen"
]
30 0.30 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"
]
31 0.29 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"
  "washing_machine"
]
32 0.31 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"
  "dryer"
]
33 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"
  "tv"
]
34 0.35 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"
]
35 0.64 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"
  "blender"
]
36 0.36 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"
  "electric_kettle"
]
37 1.00 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"
  "coffee_maker"
]
38 0.36 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"
  "coffee"
]
39 0.38 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"
  "freezer"
]
40 0.29 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"
  "rice_cooker"
]
41 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"
]
42 0.30 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"
  "oven"
]
43 0.35 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"
  "microwave"
]
44 0.36 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"
  "toaster"
]
45 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"
  "dishwasher"
]
46 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"
  "mini_fridge"
]
47 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"
  "cooktop"
]
48 0.29 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"
  "refrigerator"
]
49 0.34 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"
  "dining_table"
]
50 0.37 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"
  "bbq_utensils"
]
51 0.34 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"
  "dishes_silverware"
]
52 0.35 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"
  "wine_glasses"
]
53 0.31 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"
  "basic_cooking_essentials"
]
54 0.26 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"
  "barbecue"
]
55 0.26 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"
  "sun_loungers"
]
56 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"
  "outdoor_dining_area"
]
57 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"
  "outdoor_furniture"
]
58 0.29 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"
  "swimming_pool"
]
59 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"
  "home_theater"
]
60 0.29 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"
  "piano"
]
61 0.26 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"
  "sound_system"
]
62 0.26 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"
]
63 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"
  "baby_bathtub"
]
64 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"
  "high_chair"
]
65 0.31 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"
  "board_games"
]
66 0.26 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"
  "travel_crib"
]
67 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"
  "baby_bed"
]
68 0.31 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"
  "kids_books_toys"
]
69 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"
  "babysitter_recommendations"
]
70 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"
  "heating"
]
71 0.21 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"
  "fireplace"
]
72 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"
  "air_conditioning"
]
73 0.21 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"
  "smoke_detector"
]
74 0.21 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"
  "carbon_monoxide_detector"
]
75 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"
  "fire_extinguisher"
]
76 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"
  "first_aid_kit"
]
77 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"
  "dedicated_workspace"
]
78 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"
]
79 0.21 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"
  "beach_access"
]
80 0.21 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"
  "free_on_site_parking"
]
81 0.20 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"
  "ev_charging_station"
]
82 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"
  "well_lit_path_to_entrance"
]
83 0.19 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"
  "step_free_access"
]
84 0.19 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"
]
85 0.20 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"
  "commercial_photography_filming_allowed"
]
86 0.21 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"
  "outdoor_security_camera"
]
87 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"
  "carbon_monoxide_detector"
]
88 0.23 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"
  "smoke_detector"
]

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
  • The field App\Entity\Listing#photos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ListingPhoto#listing does not contain the required 'inversedBy="photos"' attribute.
App\Entity\User No errors.
App\Entity\ListingPhoto No errors.
App\Entity\ListingUnavailability No errors.
App\Entity\TextFront No errors.