Symfony Profiler

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

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 WHERE t0.id = '179';

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  town
SET
  vues = ?
WHERE
  id = ?

UPDATE town SET vues = 21 WHERE id = 179;

"COMMIT"

"COMMIT";

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.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.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;

SELECT
  b0_.id AS id_0,
  b0_.designation AS designation_1,
  b0_.area AS area_2,
  b0_.number_of_pieces AS number_of_pieces_3,
  b0_.code AS code_4,
  b0_.created_at AS created_at_5,
  b0_.description AS description_6,
  b0_.active AS active_7,
  b0_.company_id AS company_id_8,
  b0_.address_id AS address_id_9,
  b0_.picture1_id AS picture1_id_10,
  b0_.picture2_id AS picture2_id_11,
  b0_.picture3_id AS picture3_id_12,
  b0_.type_id AS type_id_13,
  b0_.created_by_id AS created_by_id_14,
  b0_.options_id AS options_id_15
FROM
  building b0_
  LEFT JOIN company c1_ ON b0_.company_id = c1_.id
  LEFT JOIN building_option b2_ ON b0_.options_id = b2_.id
  LEFT JOIN address a3_ ON b0_.address_id = a3_.id
  LEFT JOIN building_type b4_ ON b0_.type_id = b4_.id
  LEFT JOIN town t5_ ON a3_.town_id = t5_.id
  LEFT JOIN media_object m6_ ON b0_.picture1_id = m6_.id
WHERE
  t5_.id = ?
  AND b0_.active = ?
ORDER BY
  b2_.notiriety DESC

SELECT b0_.id AS id_0, b0_.designation AS designation_1, b0_.area AS area_2, b0_.number_of_pieces AS number_of_pieces_3, b0_.code AS code_4, b0_.created_at AS created_at_5, b0_.description AS description_6, b0_.active AS active_7, b0_.company_id AS company_id_8, b0_.address_id AS address_id_9, b0_.picture1_id AS picture1_id_10, b0_.picture2_id AS picture2_id_11, b0_.picture3_id AS picture3_id_12, b0_.type_id AS type_id_13, b0_.created_by_id AS created_by_id_14, b0_.options_id AS options_id_15 FROM building b0_ LEFT JOIN company c1_ ON b0_.company_id = c1_.id LEFT JOIN building_option b2_ ON b0_.options_id = b2_.id LEFT JOIN address a3_ ON b0_.address_id = a3_.id LEFT JOIN building_type b4_ ON b0_.type_id = b4_.id LEFT JOIN town t5_ ON a3_.town_id = t5_.id LEFT JOIN media_object m6_ ON b0_.picture1_id = m6_.id WHERE t5_.id = 179 AND b0_.active = 1 ORDER BY b2_.notiriety DESC;

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

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 WHERE t0.id = 'all';

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

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

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

SELECT
  t0.id AS id_1,
  t0.notiriety AS notiriety_2,
  t0.parking AS parking_3,
  t0.pool AS pool_4,
  t0.mini_bar AS mini_bar_5,
  t0.conference_room AS conference_room_6,
  t0.restaurant AS restaurant_7
FROM
  building_option t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.notiriety AS notiriety_2, t0.parking AS parking_3, t0.pool AS pool_4, t0.mini_bar AS mini_bar_5, t0.conference_room AS conference_room_6, t0.restaurant AS restaurant_7 FROM building_option t0 WHERE t0.id = 1;

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

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.building_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.building_id = 3;

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.company_phone1 AS company_phone1_3,
  t0.company_phone2 AS company_phone2_4,
  t0.company_fixe_phone AS company_fixe_phone_5,
  t0.company_email AS company_email_6,
  t0.company_domain AS company_domain_7,
  t0.company_facebook_page AS company_facebook_page_8,
  t0.company_instagram_page AS company_instagram_page_9,
  t0.company_twiter_page AS company_twiter_page_10,
  t0.company_linkedin_page AS company_linkedin_page_11,
  t0.company_slogan AS company_slogan_12,
  t0.company_short_description AS company_short_description_13,
  t0.company_full_description AS company_full_description_14,
  t0.company_bp AS company_bp_15,
  t0.vues AS vues_16,
  t0.company_logo_main_id AS company_logo_main_id_17,
  t0.address_id AS address_id_18
FROM
  company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_phone1 AS company_phone1_3, t0.company_phone2 AS company_phone2_4, t0.company_fixe_phone AS company_fixe_phone_5, t0.company_email AS company_email_6, t0.company_domain AS company_domain_7, t0.company_facebook_page AS company_facebook_page_8, t0.company_instagram_page AS company_instagram_page_9, t0.company_twiter_page AS company_twiter_page_10, t0.company_linkedin_page AS company_linkedin_page_11, t0.company_slogan AS company_slogan_12, t0.company_short_description AS company_short_description_13, t0.company_full_description AS company_full_description_14, t0.company_bp AS company_bp_15, t0.vues AS vues_16, t0.company_logo_main_id AS company_logo_main_id_17, t0.address_id AS address_id_18 FROM company t0 WHERE t0.id = 2;

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