Symfony Profiler

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

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 = 'fr' AND t0.name = 'FR' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.action AS action_2,
  t0.data AS data_3,
  t0.date_insert AS date_insert_4,
  t0.booking_id AS booking_id_5,
  t0.user_id AS user_id_6
FROM
  booking_action t0
WHERE
  t0.booking_id = ?
ORDER BY
  t0.date_insert ASC

SELECT t0.id AS id_1, t0.action AS action_2, t0.data AS data_3, t0.date_insert AS date_insert_4, t0.booking_id AS booking_id_5, t0.user_id AS user_id_6 FROM booking_action t0 WHERE t0.booking_id = 13 ORDER BY t0.date_insert ASC;

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
FROM
  `user` t0
WHERE
  t0.id = ?

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 FROM `user` t0 WHERE t0.id = 2;

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 = ?

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 = 1;

SELECT
  t0.id AS id_1,
  t0.message AS message_2,
  t0.date_insert AS date_insert_3,
  t0.date_seen AS date_seen_4,
  t0.booking_id AS booking_id_5,
  t0.sender_id AS sender_id_6,
  t0.recipient_id AS recipient_id_7
FROM
  booking_message t0
WHERE
  t0.booking_id = ?
ORDER BY
  t0.date_insert ASC

SELECT t0.id AS id_1, t0.message AS message_2, t0.date_insert AS date_insert_3, t0.date_seen AS date_seen_4, t0.booking_id AS booking_id_5, t0.sender_id AS sender_id_6, t0.recipient_id AS recipient_id_7 FROM booking_message t0 WHERE t0.booking_id = 13 ORDER BY t0.date_insert ASC;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.date_checkin AS date_checkin_3,
  t0.date_checkout AS date_checkout_4,
  t0.date_insert AS date_insert_5,
  t0.pricing AS pricing_6,
  t0.date_confirmation AS date_confirmation_7,
  t0.cancellation_policy AS cancellation_policy_8,
  t0.guest_adults AS guest_adults_9,
  t0.guest_children AS guest_children_10,
  t0.date_checkin_mod AS date_checkin_mod_11,
  t0.date_checkout_mod AS date_checkout_mod_12,
  t0.guest_adults_mod AS guest_adults_mod_13,
  t0.guest_children_mod AS guest_children_mod_14,
  t0.date_mod AS date_mod_15,
  t0.pricing_mod AS pricing_mod_16,
  t0.pricing_confirmed AS pricing_confirmed_17,
  t0.guest_id AS guest_id_18,
  t0.host_id AS host_id_19,
  t0.listing_id AS listing_id_20
FROM
  booking t0
WHERE
  t0.id = ?
  AND t0.guest_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.status AS status_2, t0.date_checkin AS date_checkin_3, t0.date_checkout AS date_checkout_4, t0.date_insert AS date_insert_5, t0.pricing AS pricing_6, t0.date_confirmation AS date_confirmation_7, t0.cancellation_policy AS cancellation_policy_8, t0.guest_adults AS guest_adults_9, t0.guest_children AS guest_children_10, t0.date_checkin_mod AS date_checkin_mod_11, t0.date_checkout_mod AS date_checkout_mod_12, t0.guest_adults_mod AS guest_adults_mod_13, t0.guest_children_mod AS guest_children_mod_14, t0.date_mod AS date_mod_15, t0.pricing_mod AS pricing_mod_16, t0.pricing_confirmed AS pricing_confirmed_17, t0.guest_id AS guest_id_18, t0.host_id AS host_id_19, t0.listing_id AS listing_id_20 FROM booking t0 WHERE t0.id = 13 AND t0.guest_id = 2 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.date_checkin AS date_checkin_3,
  t0.date_checkout AS date_checkout_4,
  t0.date_insert AS date_insert_5,
  t0.pricing AS pricing_6,
  t0.date_confirmation AS date_confirmation_7,
  t0.cancellation_policy AS cancellation_policy_8,
  t0.guest_adults AS guest_adults_9,
  t0.guest_children AS guest_children_10,
  t0.date_checkin_mod AS date_checkin_mod_11,
  t0.date_checkout_mod AS date_checkout_mod_12,
  t0.guest_adults_mod AS guest_adults_mod_13,
  t0.guest_children_mod AS guest_children_mod_14,
  t0.date_mod AS date_mod_15,
  t0.pricing_mod AS pricing_mod_16,
  t0.pricing_confirmed AS pricing_confirmed_17,
  t0.guest_id AS guest_id_18,
  t0.host_id AS host_id_19,
  t0.listing_id AS listing_id_20
FROM
  booking t0
WHERE
  t0.id = ?
  AND t0.host_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.status AS status_2, t0.date_checkin AS date_checkin_3, t0.date_checkout AS date_checkout_4, t0.date_insert AS date_insert_5, t0.pricing AS pricing_6, t0.date_confirmation AS date_confirmation_7, t0.cancellation_policy AS cancellation_policy_8, t0.guest_adults AS guest_adults_9, t0.guest_children AS guest_children_10, t0.date_checkin_mod AS date_checkin_mod_11, t0.date_checkout_mod AS date_checkout_mod_12, t0.guest_adults_mod AS guest_adults_mod_13, t0.guest_children_mod AS guest_children_mod_14, t0.date_mod AS date_mod_15, t0.pricing_mod AS pricing_mod_16, t0.pricing_confirmed AS pricing_confirmed_17, t0.guest_id AS guest_id_18, t0.host_id AS host_id_19, t0.listing_id AS listing_id_20 FROM booking t0 WHERE t0.id = 13 AND t0.host_id = 2 LIMIT 1;