Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.validity AS validity_3,
  t0.location AS location_4,
  t0.category AS category_5,
  t0.link AS link_6,
  t0.file_pub AS file_pub_7,
  t0.file_size AS file_size_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.expireted_at AS expireted_at_11,
  t0.back_link AS back_link_12
FROM
  pub t0
WHERE
  t0.location = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.validity AS validity_3, t0.location AS location_4, t0.category AS category_5, t0.link AS link_6, t0.file_pub AS file_pub_7, t0.file_size AS file_size_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.expireted_at AS expireted_at_11, t0.back_link AS back_link_12 FROM pub t0 WHERE t0.location = 'Entéte du site';

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.image_pub AS image_pub_2,
  p0_.created_at AS created_at_3,
  p0_.image_size AS image_size_4,
  p0_.updated_at AS updated_at_5,
  p0_.description AS description_6,
  p0_.admin_id AS admin_id_7
FROM
  pub_infos p0_
ORDER BY
  p0_.id DESC
LIMIT
  3

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.image_pub AS image_pub_2, p0_.created_at AS created_at_3, p0_.image_size AS image_size_4, p0_.updated_at AS updated_at_5, p0_.description AS description_6, p0_.admin_id AS admin_id_7 FROM pub_infos p0_ ORDER BY p0_.id DESC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.validity AS validity_3,
  t0.location AS location_4,
  t0.category AS category_5,
  t0.link AS link_6,
  t0.file_pub AS file_pub_7,
  t0.file_size AS file_size_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.expireted_at AS expireted_at_11,
  t0.back_link AS back_link_12
FROM
  pub t0
WHERE
  t0.location = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.validity AS validity_3, t0.location AS location_4, t0.category AS category_5, t0.link AS link_6, t0.file_pub AS file_pub_7, t0.file_size AS file_size_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.expireted_at AS expireted_at_11, t0.back_link AS back_link_12 FROM pub t0 WHERE t0.location = 'Banière Vitrine';

SELECT
  a0_.id AS id_0,
  a0_.categorie AS categorie_1,
  a0_.nom_an AS nom_an_2,
  a0_.description AS description_3,
  a0_.created_at AS created_at_4,
  a0_.logo AS logo_5,
  a0_.image_size AS image_size_6,
  a0_.email AS email_7,
  a0_.address AS address_8,
  a0_.website AS website_9,
  a0_.updated_at AS updated_at_10,
  u1_.id AS id_11,
  u1_.email AS email_12,
  u1_.roles AS roles_13,
  u1_.password AS password_14,
  u1_.type_compte AS type_compte_15,
  u1_.is_verified AS is_verified_16,
  u1_.tel AS tel_17,
  u1_.approve AS approve_18,
  u1_.facebook_id AS facebook_id_19,
  u1_.is_super_admin AS is_super_admin_20,
  u1_.facebook AS facebook_21,
  u1_.twitter AS twitter_22,
  u1_.instagram AS instagram_23,
  u1_.linkedin AS linkedin_24,
  u1_.youtube AS youtube_25,
  u1_.whatsapp AS whatsapp_26,
  u1_.pinterest AS pinterest_27,
  u1_.facebook_access_token AS facebook_access_token_28,
  u1_.twitter_id AS twitter_id_29,
  u1_.twitter_access_token AS twitter_access_token_30,
  u1_.google_id AS google_id_31,
  u1_.google_access_token AS google_access_token_32,
  p2_.logo AS logo_33,
  p2_.nom_professionel AS nom_professionel_34,
  p2_.addresse AS addresse_35,
  p2_.marques AS marques_36,
  p2_.website AS website_37,
  p2_.image_size AS image_size_38,
  p2_.updated_at AS updated_at_39,
  p2_.description AS description_40,
  a3_.id AS id_41,
  a3_.category AS category_42,
  a3_.marques AS marques_43,
  a3_.modeles AS modeles_44,
  a3_.etats AS etats_45,
  a3_.carosseries AS carosseries_46,
  a3_.year AS year_47,
  a3_.kilometrage AS kilometrage_48,
  a3_.carburants AS carburants_49,
  a3_.transmission AS transmission_50,
  a3_.moteur AS moteur_51,
  a3_.entrainement AS entrainement_52,
  a3_.couleur_ext AS couleur_ext_53,
  a3_.couleur_int AS couleur_int_54,
  a3_.numero_chassis AS numero_chassis_55,
  a3_.consommationville AS consommationville_56,
  a3_.consommation_route AS consommation_route_57,
  a3_.carosserie_equip AS carosserie_equip_58,
  a3_.transmission_equip AS transmission_equip_59,
  a3_.interieur_equip AS interieur_equip_60,
  a3_.exterieur_equip AS exterieur_equip_61,
  a3_.electronique_equip AS electronique_equip_62,
  a3_.dispo_securite AS dispo_securite_63,
  a3_.videos AS videos_64,
  a3_.price AS price_65,
  a3_.description AS description_66,
  a3_.descriptionadd AS descriptionadd_67,
  a3_.specificationtechniques AS specificationtechniques_68,
  a3_.infosgenerales AS infosgenerales_69,
  a3_.brochure_filename AS brochure_filename_70,
  a3_.brochure_size AS brochure_size_71,
  a3_.created_at AS created_at_72,
  a3_.updated_at AS updated_at_73,
  a3_.device AS device_74,
  a3_.regions AS regions_75,
  a3_.villes AS villes_76,
  a3_.communes AS communes_77,
  a3_.address AS address_78,
  a3_.type AS type_79,
  a3_.urgent AS urgent_80,
  a3_.nbrcylindre AS nbrcylindre_81,
  a3_.numero_enregistrement AS numero_enregistrement_82,
  a3_.is_favoris AS is_favoris_83,
  a3_.has_co2 AS has_co2_84,
  a3_.export_price AS export_price_85,
  a3_.bargan_price AS bargan_price_86,
  a3_.is_active AS is_active_87,
  a3_.int_moto AS int_moto_88,
  a3_.electro_moto AS electro_moto_89,
  a3_.disposec_moto AS disposec_moto_90,
  a3_.dispconf_moto AS dispconf_moto_91,
  a3_.lon AS lon_92,
  a3_.lat AS lat_93,
  a3_.duration AS duration_94,
  a3_.comments AS comments_95,
  a3_.note AS note_96,
  a3_.is_compared AS is_compared_97,
  a0_.user_an_id AS user_an_id_98,
  u1_.compte AS compte_99,
  a3_.user_id AS user_id_100
FROM
  annuaire a0_
  LEFT JOIN professionel p2_ ON a0_.user_an_id = p2_.id
  LEFT JOIN user u1_ ON p2_.id = u1_.id
  LEFT JOIN annonce a3_ ON u1_.id = a3_.user_id
WHERE
  a0_.categorie = ?
ORDER BY
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.categorie AS categorie_1, a0_.nom_an AS nom_an_2, a0_.description AS description_3, a0_.created_at AS created_at_4, a0_.logo AS logo_5, a0_.image_size AS image_size_6, a0_.email AS email_7, a0_.address AS address_8, a0_.website AS website_9, a0_.updated_at AS updated_at_10, u1_.id AS id_11, u1_.email AS email_12, u1_.roles AS roles_13, u1_.password AS password_14, u1_.type_compte AS type_compte_15, u1_.is_verified AS is_verified_16, u1_.tel AS tel_17, u1_.approve AS approve_18, u1_.facebook_id AS facebook_id_19, u1_.is_super_admin AS is_super_admin_20, u1_.facebook AS facebook_21, u1_.twitter AS twitter_22, u1_.instagram AS instagram_23, u1_.linkedin AS linkedin_24, u1_.youtube AS youtube_25, u1_.whatsapp AS whatsapp_26, u1_.pinterest AS pinterest_27, u1_.facebook_access_token AS facebook_access_token_28, u1_.twitter_id AS twitter_id_29, u1_.twitter_access_token AS twitter_access_token_30, u1_.google_id AS google_id_31, u1_.google_access_token AS google_access_token_32, p2_.logo AS logo_33, p2_.nom_professionel AS nom_professionel_34, p2_.addresse AS addresse_35, p2_.marques AS marques_36, p2_.website AS website_37, p2_.image_size AS image_size_38, p2_.updated_at AS updated_at_39, p2_.description AS description_40, a3_.id AS id_41, a3_.category AS category_42, a3_.marques AS marques_43, a3_.modeles AS modeles_44, a3_.etats AS etats_45, a3_.carosseries AS carosseries_46, a3_.year AS year_47, a3_.kilometrage AS kilometrage_48, a3_.carburants AS carburants_49, a3_.transmission AS transmission_50, a3_.moteur AS moteur_51, a3_.entrainement AS entrainement_52, a3_.couleur_ext AS couleur_ext_53, a3_.couleur_int AS couleur_int_54, a3_.numero_chassis AS numero_chassis_55, a3_.consommationville AS consommationville_56, a3_.consommation_route AS consommation_route_57, a3_.carosserie_equip AS carosserie_equip_58, a3_.transmission_equip AS transmission_equip_59, a3_.interieur_equip AS interieur_equip_60, a3_.exterieur_equip AS exterieur_equip_61, a3_.electronique_equip AS electronique_equip_62, a3_.dispo_securite AS dispo_securite_63, a3_.videos AS videos_64, a3_.price AS price_65, a3_.description AS description_66, a3_.descriptionadd AS descriptionadd_67, a3_.specificationtechniques AS specificationtechniques_68, a3_.infosgenerales AS infosgenerales_69, a3_.brochure_filename AS brochure_filename_70, a3_.brochure_size AS brochure_size_71, a3_.created_at AS created_at_72, a3_.updated_at AS updated_at_73, a3_.device AS device_74, a3_.regions AS regions_75, a3_.villes AS villes_76, a3_.communes AS communes_77, a3_.address AS address_78, a3_.type AS type_79, a3_.urgent AS urgent_80, a3_.nbrcylindre AS nbrcylindre_81, a3_.numero_enregistrement AS numero_enregistrement_82, a3_.is_favoris AS is_favoris_83, a3_.has_co2 AS has_co2_84, a3_.export_price AS export_price_85, a3_.bargan_price AS bargan_price_86, a3_.is_active AS is_active_87, a3_.int_moto AS int_moto_88, a3_.electro_moto AS electro_moto_89, a3_.disposec_moto AS disposec_moto_90, a3_.dispconf_moto AS dispconf_moto_91, a3_.lon AS lon_92, a3_.lat AS lat_93, a3_.duration AS duration_94, a3_.comments AS comments_95, a3_.note AS note_96, a3_.is_compared AS is_compared_97, a0_.user_an_id AS user_an_id_98, u1_.compte AS compte_99, a3_.user_id AS user_id_100 FROM annuaire a0_ LEFT JOIN professionel p2_ ON a0_.user_an_id = p2_.id LEFT JOIN user u1_ ON p2_.id = u1_.id LEFT JOIN annonce a3_ ON u1_.id = a3_.user_id WHERE a0_.categorie = 'Concessionnaires' ORDER BY a0_.id DESC;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  professionel p1_
  INNER JOIN user u2_ ON p1_.id = u2_.id
  LEFT JOIN annonce a0_ ON u2_.id = a0_.user_id
WHERE
  u2_.id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM professionel p1_ INNER JOIN user u2_ ON p1_.id = u2_.id LEFT JOIN annonce a0_ ON u2_.id = a0_.user_id WHERE u2_.id = 34;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  professionel p1_
  INNER JOIN user u2_ ON p1_.id = u2_.id
  LEFT JOIN annonce a0_ ON u2_.id = a0_.user_id
WHERE
  u2_.id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM professionel p1_ INNER JOIN user u2_ ON p1_.id = u2_.id LEFT JOIN annonce a0_ ON u2_.id = a0_.user_id WHERE u2_.id = 32;