Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.country_name AS country_name_2,
  t0.created_at AS created_at_3,
  t0.code AS code_4,
  t0.capital AS capital_5,
  t0.calling_code AS calling_code_6,
  t0.region AS region_7,
  t0.population AS population_8,
  t0.time_zone AS time_zone_9,
  t0.latitude AS latitude_10,
  t0.longitude AS longitude_11,
  t0.offset AS offset_12,
  t0.country_flag_id AS country_flag_id_13
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.country_name AS country_name_2, t0.created_at AS created_at_3, t0.code AS code_4, t0.capital AS capital_5, t0.calling_code AS calling_code_6, t0.region AS region_7, t0.population AS population_8, t0.time_zone AS time_zone_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.offset AS offset_12, t0.country_flag_id AS country_flag_id_13 FROM country t0 WHERE t0.id = 182;

SELECT
  t0.id AS id_1,
  t0.file_path AS file_path_2,
  t0.created_at AS created_at_3,
  t0.file_type AS file_type_4,
  t0.directory AS directory_5
FROM
  media_object t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.created_at AS created_at_3, t0.file_type AS file_type_4, t0.directory AS directory_5 FROM media_object t0 WHERE t0.id = 287;

SELECT
  t0.id AS id_1,
  t0.town_name AS town_name_2,
  t0.created_at AS created_at_3,
  t0.is_capital AS is_capital_4,
  t0.population AS population_5,
  t0.latitude AS latitude_6,
  t0.longitude AS longitude_7,
  t0.region AS region_8,
  t0.vues AS vues_9,
  t0.country_id AS country_id_10,
  t0.picture_id AS picture_id_11
FROM
  town t0
ORDER BY
  t0.vues DESC

SELECT t0.id AS id_1, t0.town_name AS town_name_2, t0.created_at AS created_at_3, t0.is_capital AS is_capital_4, t0.population AS population_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.region AS region_8, t0.vues AS vues_9, t0.country_id AS country_id_10, t0.picture_id AS picture_id_11 FROM town t0 ORDER BY t0.vues DESC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.number_of_piece AS number_of_piece_3,
  t0.description AS description_4,
  t0.cost AS cost_5,
  t0.capacity AS capacity_6,
  t0.created_at AS created_at_7,
  t0.is_free AS is_free_8,
  t0.cost_per_month AS cost_per_month_9,
  t0.pay_before AS pay_before_10,
  t0.options_id AS options_id_11,
  t0.building_id AS building_id_12,
  t0.created_by_id AS created_by_id_13,
  t0.room_type_id AS room_type_id_14,
  t0.picture1_id AS picture1_id_15,
  t0.picture_id AS picture_id_16,
  t0.picture2_id AS picture2_id_17
FROM
  room t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.number_of_piece AS number_of_piece_3, t0.description AS description_4, t0.cost AS cost_5, t0.capacity AS capacity_6, t0.created_at AS created_at_7, t0.is_free AS is_free_8, t0.cost_per_month AS cost_per_month_9, t0.pay_before AS pay_before_10, t0.options_id AS options_id_11, t0.building_id AS building_id_12, t0.created_by_id AS created_by_id_13, t0.room_type_id AS room_type_id_14, t0.picture1_id AS picture1_id_15, t0.picture_id AS picture_id_16, t0.picture2_id AS picture2_id_17 FROM room t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.arrival_date AS arrival_date_2,
  t0.departure_date AS departure_date_3,
  t0.child AS child_4,
  t0.adult AS adult_5,
  t0.created_at AS created_at_6,
  t0.has_vue AS has_vue_7,
  t0.payment_as_been_confirmed AS payment_as_been_confirmed_8,
  t0.payment_link AS payment_link_9,
  t0.payment_notification_link AS payment_notification_link_10,
  t0.user_id AS user_id_11,
  t0.coming_from_id AS coming_from_id_12,
  t0.room_id AS room_id_13,
  t14.id AS id_15,
  t14.amount AS amount_16,
  t14.fees AS fees_17,
  t14.created_at AS created_at_18,
  t14.expire_at AS expire_at_19,
  t14.discount AS discount_20,
  t14.payment_token AS payment_token_21,
  t14.id_req_doh AS id_req_doh_22,
  t14.r_dvs AS r_dvs_23,
  t14.transaction_ref AS transaction_ref_24,
  t14.update_at AS update_at_25,
  t14.amount_validated AS amount_validated_26,
  t14.user_id AS user_id_27,
  t14.booking_id AS booking_id_28,
  t14.payment_option_id AS payment_option_id_29
FROM
  booking_room t0
  LEFT JOIN payment t14 ON t14.booking_id = t0.id

SELECT t0.id AS id_1, t0.arrival_date AS arrival_date_2, t0.departure_date AS departure_date_3, t0.child AS child_4, t0.adult AS adult_5, t0.created_at AS created_at_6, t0.has_vue AS has_vue_7, t0.payment_as_been_confirmed AS payment_as_been_confirmed_8, t0.payment_link AS payment_link_9, t0.payment_notification_link AS payment_notification_link_10, t0.user_id AS user_id_11, t0.coming_from_id AS coming_from_id_12, t0.room_id AS room_id_13, t14.id AS id_15, t14.amount AS amount_16, t14.fees AS fees_17, t14.created_at AS created_at_18, t14.expire_at AS expire_at_19, t14.discount AS discount_20, t14.payment_token AS payment_token_21, t14.id_req_doh AS id_req_doh_22, t14.r_dvs AS r_dvs_23, t14.transaction_ref AS transaction_ref_24, t14.update_at AS update_at_25, t14.amount_validated AS amount_validated_26, t14.user_id AS user_id_27, t14.booking_id AS booking_id_28, t14.payment_option_id AS payment_option_id_29 FROM booking_room t0 LEFT JOIN payment t14 ON t14.booking_id = t0.id;

SELECT
  t0.id AS id_1,
  t0.location AS location_2,
  t0.phone AS phone_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.town_id AS town_id_6
FROM
  address t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.location AS location_2, t0.phone AS phone_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.town_id AS town_id_6 FROM address t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.designation AS designation_2,
  t0.area AS area_3,
  t0.number_of_pieces AS number_of_pieces_4,
  t0.code AS code_5,
  t0.created_at AS created_at_6,
  t0.description AS description_7,
  t0.active AS active_8,
  t0.company_id AS company_id_9,
  t0.address_id AS address_id_10,
  t0.picture1_id AS picture1_id_11,
  t0.picture2_id AS picture2_id_12,
  t0.picture3_id AS picture3_id_13,
  t0.type_id AS type_id_14,
  t0.created_by_id AS created_by_id_15,
  t0.options_id AS options_id_16
FROM
  building t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.designation AS designation_2, t0.area AS area_3, t0.number_of_pieces AS number_of_pieces_4, t0.code AS code_5, t0.created_at AS created_at_6, t0.description AS description_7, t0.active AS active_8, t0.company_id AS company_id_9, t0.address_id AS address_id_10, t0.picture1_id AS picture1_id_11, t0.picture2_id AS picture2_id_12, t0.picture3_id AS picture3_id_13, t0.type_id AS type_id_14, t0.created_by_id AS created_by_id_15, t0.options_id AS options_id_16 FROM building t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.client AS client_2,
  t0.message AS message_3,
  t0.contact AS contact_4,
  t0.appreciation AS appreciation_5,
  t0.approved AS approved_6,
  t0.created_at AS created_at_7,
  t0.picture_id AS picture_id_8,
  t0.approved_by_id AS approved_by_id_9
FROM
  testimony t0

SELECT t0.id AS id_1, t0.client AS client_2, t0.message AS message_3, t0.contact AS contact_4, t0.appreciation AS appreciation_5, t0.approved AS approved_6, t0.created_at AS created_at_7, t0.picture_id AS picture_id_8, t0.approved_by_id AS approved_by_id_9 FROM testimony t0;

SELECT
  t0.id AS id_1,
  t0.new_title_fr AS new_title_fr_2,
  t0.content_fr AS content_fr_3,
  t0.content_en AS content_en_4,
  t0.content_es AS content_es_5,
  t0.publish AS publish_6,
  t0.created_at AS created_at_7,
  t0.new_title_en AS new_title_en_8,
  t0.new_title_es AS new_title_es_9,
  t0.liked AS liked_10,
  t0.unliked AS unliked_11,
  t0.created_by_id AS created_by_id_12,
  t0.cover_id AS cover_id_13,
  t0.picture1_id AS picture1_id_14,
  t0.picture2_id AS picture2_id_15
FROM
  actualite t0

SELECT t0.id AS id_1, t0.new_title_fr AS new_title_fr_2, t0.content_fr AS content_fr_3, t0.content_en AS content_en_4, t0.content_es AS content_es_5, t0.publish AS publish_6, t0.created_at AS created_at_7, t0.new_title_en AS new_title_en_8, t0.new_title_es AS new_title_es_9, t0.liked AS liked_10, t0.unliked AS unliked_11, t0.created_by_id AS created_by_id_12, t0.cover_id AS cover_id_13, t0.picture1_id AS picture1_id_14, t0.picture2_id AS picture2_id_15 FROM actualite t0;

SELECT
  t0.id AS id_1,
  t0.web_agent AS web_agent_2,
  t0.ip_location AS ip_location_3,
  t0.created_at AS created_at_4,
  t0.country_location AS country_location_5,
  t0.visitor_name AS visitor_name_6,
  t0.visitor_phone AS visitor_phone_7,
  t0.physical_location_add AS physical_location_add_8,
  t0.longitude_add AS longitude_add_9,
  t0.latitude_add AS latitude_add_10,
  t0.continent AS continent_11,
  t0.region AS region_12,
  t0.ville AS ville_13,
  t0.visitor_email AS visitor_email_14,
  t0.is_admin AS is_admin_15,
  t0.country_code AS country_code_16
FROM
  visitor t0

SELECT t0.id AS id_1, t0.web_agent AS web_agent_2, t0.ip_location AS ip_location_3, t0.created_at AS created_at_4, t0.country_location AS country_location_5, t0.visitor_name AS visitor_name_6, t0.visitor_phone AS visitor_phone_7, t0.physical_location_add AS physical_location_add_8, t0.longitude_add AS longitude_add_9, t0.latitude_add AS latitude_add_10, t0.continent AS continent_11, t0.region AS region_12, t0.ville AS ville_13, t0.visitor_email AS visitor_email_14, t0.is_admin AS is_admin_15, t0.country_code AS country_code_16 FROM visitor t0;

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.title_en AS title_en_3,
  t0.location_type AS location_type_4,
  t0.amount AS amount_5,
  t0.number_of_piece AS number_of_piece_6,
  t0.area AS area_7,
  t0.description AS description_8,
  t0.created_at AS created_at_9,
  t0.expired_at AS expired_at_10,
  t0.vues AS vues_11,
  t0.description_en AS description_en_12,
  t0.type_id AS type_id_13,
  t0.address_id AS address_id_14,
  t0.picture_id AS picture_id_15,
  t0.cover_id AS cover_id_16,
  t0.created_by_id AS created_by_id_17
FROM
  announce t0

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.location_type AS location_type_4, t0.amount AS amount_5, t0.number_of_piece AS number_of_piece_6, t0.area AS area_7, t0.description AS description_8, t0.created_at AS created_at_9, t0.expired_at AS expired_at_10, t0.vues AS vues_11, t0.description_en AS description_en_12, t0.type_id AS type_id_13, t0.address_id AS address_id_14, t0.picture_id AS picture_id_15, t0.cover_id AS cover_id_16, t0.created_by_id AS created_by_id_17 FROM announce t0;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.message AS message_3,
  t0.active AS active_4,
  t0.created_at AS created_at_5,
  t0.position AS position_6,
  t0.message_en AS message_en_7,
  t0.title_en AS title_en_8,
  t0.picture_id AS picture_id_9,
  t0.created_by_id AS created_by_id_10
FROM
  background t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.message AS message_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.position AS position_6, t0.message_en AS message_en_7, t0.title_en AS title_en_8, t0.picture_id AS picture_id_9, t0.created_by_id AS created_by_id_10 FROM background t0;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.created_at AS created_at_3,
  t0.enable AS enable_4
FROM
  building_type t0

SELECT t0.id AS id_1, t0.type AS type_2, t0.created_at AS created_at_3, t0.enable AS enable_4 FROM building_type t0;