Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.data AS data_3
FROM
  enum_values t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.data AS data_3 FROM enum_values t0 WHERE t0.name = 'nbrRooms' LIMIT 1;

SELECT
  SUM(
    CASE WHEN department = 75 THEN 1 ELSE 0 END
  ) AS "Paris",
  SUM(
    CASE WHEN department = 77 THEN 1 ELSE 0 END
  ) AS "Seine-et-Marne",
  SUM(
    CASE WHEN department = 78 THEN 1 ELSE 0 END
  ) AS "Yvelines",
  SUM(
    CASE WHEN department = 91 THEN 1 ELSE 0 END
  ) AS "Essonne",
  SUM(
    CASE WHEN department = 92 THEN 1 ELSE 0 END
  ) AS "Hauts-de-Seine",
  SUM(
    CASE WHEN department = 93 THEN 1 ELSE 0 END
  ) AS "Seine-Saint-Denis",
  SUM(
    CASE WHEN department = 94 THEN 1 ELSE 0 END
  ) AS "Val-de-Marne",
  SUM(
    CASE WHEN department = 95 THEN 1 ELSE 0 END
  ) AS "Val-d'Oise"
FROM
  offer
WHERE
  offer.is_published = 1
  AND offer.convention_end_date >= NOW()
  AND offer.slug != ""

SELECT
				SUM(CASE WHEN department = 75 THEN 1 ELSE 0 END) AS "Paris",
				SUM(CASE WHEN department = 77 THEN 1 ELSE 0 END) AS "Seine-et-Marne",
				SUM(CASE WHEN department = 78 THEN 1 ELSE 0 END) AS "Yvelines",
				SUM(CASE WHEN department = 91 THEN 1 ELSE 0 END) AS "Essonne",
				SUM(CASE WHEN department = 92 THEN 1 ELSE 0 END) AS "Hauts-de-Seine",
				SUM(CASE WHEN department = 93 THEN 1 ELSE 0 END) AS "Seine-Saint-Denis",
				SUM(CASE WHEN department = 94 THEN 1 ELSE 0 END) AS "Val-de-Marne",
				SUM(CASE WHEN department = 95 THEN 1 ELSE 0 END) AS "Val-d'Oise"
			FROM
				offer
			WHERE
				offer.is_published = 1
			AND offer.convention_end_date >= NOW() 
			AND offer.slug != "";

SELECT
  offer.id,
  offer.contract_type AS contractType,
  offer.slug,
  offer.department,
  details.is_bathroom AS isBathroom,
  details.is_shower_room AS isShowerRoom,
  offer.nbr_bedrooms AS nbrBedrooms,
  offer.nbr_rooms AS nbrRooms,
  offer.building_type AS buildingType,
  offer.nbr_rooms AS nbrRoom,
  offer.surface,
  offer.zipcode,
  offer.is_favorite,
  city.name AS city,
  offer.price,
  offer.construction_type AS constructionType,
  offer.description AS description,
  details.is_furnished AS isFurnished,
  details.is_renovated AS isRenovated,
  details.is_very_good_condition AS isVeryGoodCondition,
  details.is_good_condition AS isGoodCondition,
  details.is_light AS isLight,
  p.image AS image
FROM
  offer
  LEFT JOIN (
    SELECT
      CONCAT_WS(".", filename, extension) AS image,
      offer_image_id
    FROM
      offer_image
  ) p ON p.offer_image_id = offer.id
  LEFT JOIN offer_details details ON details.offer_id = offer.id
  LEFT JOIN city ON city.id = offer.city_id
WHERE
  offer.is_published = 1
  AND offer.convention_end_date >= NOW()
  AND offer.slug != ""
GROUP BY
  offer.id
ORDER BY
  offer.published_at DESC
LIMIT
  10

SELECT
				offer.id,
				offer.contract_type AS contractType,
				offer.slug,
				offer.department,
				details.is_bathroom AS isBathroom,
				details.is_shower_room AS isShowerRoom,
				offer.nbr_bedrooms AS nbrBedrooms,
				offer.nbr_rooms AS nbrRooms,
				offer.building_type AS buildingType,
				offer.nbr_rooms AS nbrRoom,
				offer.surface,
				offer.zipcode,
				offer.is_favorite,
				city.name AS city,
				offer.price,
				offer.construction_type AS constructionType,
				offer.description AS description,
				details.is_furnished AS isFurnished,
				details.is_renovated AS isRenovated,
				details.is_very_good_condition AS isVeryGoodCondition,
				details.is_good_condition AS isGoodCondition,
				details.is_light AS isLight,
				p.image AS image
			FROM
				offer
			LEFT JOIN (
				SELECT
					CONCAT_WS(".", filename, extension) AS image,
					offer_image_id
				FROM offer_image
				) p ON p.offer_image_id = offer.id
			LEFT JOIN offer_details details
				ON details.offer_id = offer.id
			LEFT JOIN city
				ON city.id = offer.city_id
			WHERE
				offer.is_published = 1
			AND offer.convention_end_date >= NOW()
			AND offer.slug != ""
			GROUP BY offer.id ORDER BY offer.published_at DESC LIMIT 10;