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 = '1130';

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  town
SET
  vues = ?
WHERE
  id = ?

UPDATE town SET vues = 20 WHERE id = 1130;

"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 = 1130 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 = 130;

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