Symfony Profiler

SELECT
  a0_.id AS id_0,
  t1_.content AS category_1,
  t2_.content AS marques_2,
  t3_.content AS modeles_3,
  t4_.content AS etats_4,
  t5_.content AS carosseries_5,
  a0_.year AS year_6,
  t6_.content AS kilometrage_7,
  t7_.content AS carburants_8,
  t8_.content AS transmission_9,
  t9_.content AS moteur_10,
  t10_.content AS entrainement_11,
  t11_.content AS couleur_ext_12,
  t12_.content AS couleur_int_13,
  a0_.numero_chassis AS numero_chassis_14,
  t13_.content AS consommationville_15,
  t14_.content AS consommation_route_16,
  t15_.content AS carosserie_equip_17,
  t16_.content AS transmission_equip_18,
  t17_.content AS interieur_equip_19,
  t18_.content AS exterieur_equip_20,
  t19_.content AS electronique_equip_21,
  a0_.dispo_securite AS dispo_securite_22,
  a0_.videos AS videos_23,
  t20_.content AS price_24,
  t21_.content AS description_25,
  t22_.content AS descriptionadd_26,
  t23_.content AS specificationtechniques_27,
  t24_.content AS infosgenerales_28,
  a0_.brochure_filename AS brochure_filename_29,
  a0_.brochure_size AS brochure_size_30,
  t25_.content AS created_at_31,
  t26_.content AS updated_at_32,
  a0_.device AS device_33,
  a0_.regions AS regions_34,
  a0_.villes AS villes_35,
  a0_.communes AS communes_36,
  a0_.address AS address_37,
  a0_.type AS type_38,
  a0_.urgent AS urgent_39,
  a0_.nbrcylindre AS nbrcylindre_40,
  a0_.numero_enregistrement AS numero_enregistrement_41,
  a0_.is_favoris AS is_favoris_42,
  a0_.has_co2 AS has_co2_43,
  a0_.export_price AS export_price_44,
  a0_.bargan_price AS bargan_price_45,
  a0_.is_active AS is_active_46,
  a0_.int_moto AS int_moto_47,
  a0_.electro_moto AS electro_moto_48,
  a0_.disposec_moto AS disposec_moto_49,
  a0_.dispconf_moto AS dispconf_moto_50,
  a0_.lon AS lon_51,
  a0_.lat AS lat_52,
  a0_.duration AS duration_53,
  a0_.comments AS comments_54,
  a0_.note AS note_55,
  a0_.is_compared AS is_compared_56,
  a0_.user_id AS user_id_57
FROM
  annonce a0_
  LEFT JOIN ext_translations t1_ ON t1_.locale = 'en'
  AND t1_.field = 'category'
  AND t1_.object_class = 'App\\Entity\\Annonce'
  AND t1_.foreign_key = a0_.id
  LEFT JOIN ext_translations t2_ ON t2_.locale = 'en'
  AND t2_.field = 'marques'
  AND t2_.object_class = 'App\\Entity\\Annonce'
  AND t2_.foreign_key = a0_.id
  LEFT JOIN ext_translations t3_ ON t3_.locale = 'en'
  AND t3_.field = 'modeles'
  AND t3_.object_class = 'App\\Entity\\Annonce'
  AND t3_.foreign_key = a0_.id
  LEFT JOIN ext_translations t4_ ON t4_.locale = 'en'
  AND t4_.field = 'etats'
  AND t4_.object_class = 'App\\Entity\\Annonce'
  AND t4_.foreign_key = a0_.id
  LEFT JOIN ext_translations t5_ ON t5_.locale = 'en'
  AND t5_.field = 'carosseries'
  AND t5_.object_class = 'App\\Entity\\Annonce'
  AND t5_.foreign_key = a0_.id
  LEFT JOIN ext_translations t6_ ON t6_.locale = 'en'
  AND t6_.field = 'kilometrage'
  AND t6_.object_class = 'App\\Entity\\Annonce'
  AND t6_.foreign_key = a0_.id
  LEFT JOIN ext_translations t7_ ON t7_.locale = 'en'
  AND t7_.field = 'carburants'
  AND t7_.object_class = 'App\\Entity\\Annonce'
  AND t7_.foreign_key = a0_.id
  LEFT JOIN ext_translations t8_ ON t8_.locale = 'en'
  AND t8_.field = 'transmission'
  AND t8_.object_class = 'App\\Entity\\Annonce'
  AND t8_.foreign_key = a0_.id
  LEFT JOIN ext_translations t9_ ON t9_.locale = 'en'
  AND t9_.field = 'moteur'
  AND t9_.object_class = 'App\\Entity\\Annonce'
  AND t9_.foreign_key = a0_.id
  LEFT JOIN ext_translations t10_ ON t10_.locale = 'en'
  AND t10_.field = 'entrainement'
  AND t10_.object_class = 'App\\Entity\\Annonce'
  AND t10_.foreign_key = a0_.id
  LEFT JOIN ext_translations t11_ ON t11_.locale = 'en'
  AND t11_.field = 'couleurExt'
  AND t11_.object_class = 'App\\Entity\\Annonce'
  AND t11_.foreign_key = a0_.id
  LEFT JOIN ext_translations t12_ ON t12_.locale = 'en'
  AND t12_.field = 'couleurInt'
  AND t12_.object_class = 'App\\Entity\\Annonce'
  AND t12_.foreign_key = a0_.id
  LEFT JOIN ext_translations t13_ ON t13_.locale = 'en'
  AND t13_.field = 'consommationville'
  AND t13_.object_class = 'App\\Entity\\Annonce'
  AND t13_.foreign_key = a0_.id
  LEFT JOIN ext_translations t14_ ON t14_.locale = 'en'
  AND t14_.field = 'consommationRoute'
  AND t14_.object_class = 'App\\Entity\\Annonce'
  AND t14_.foreign_key = a0_.id
  LEFT JOIN ext_translations t15_ ON t15_.locale = 'en'
  AND t15_.field = 'carosserieEquip'
  AND t15_.object_class = 'App\\Entity\\Annonce'
  AND t15_.foreign_key = a0_.id
  LEFT JOIN ext_translations t16_ ON t16_.locale = 'en'
  AND t16_.field = 'transmissionEquip'
  AND t16_.object_class = 'App\\Entity\\Annonce'
  AND t16_.foreign_key = a0_.id
  LEFT JOIN ext_translations t17_ ON t17_.locale = 'en'
  AND t17_.field = 'InterieurEquip'
  AND t17_.object_class = 'App\\Entity\\Annonce'
  AND t17_.foreign_key = a0_.id
  LEFT JOIN ext_translations t18_ ON t18_.locale = 'en'
  AND t18_.field = 'exterieurEquip'
  AND t18_.object_class = 'App\\Entity\\Annonce'
  AND t18_.foreign_key = a0_.id
  LEFT JOIN ext_translations t19_ ON t19_.locale = 'en'
  AND t19_.field = 'electroniqueEquip'
  AND t19_.object_class = 'App\\Entity\\Annonce'
  AND t19_.foreign_key = a0_.id
  LEFT JOIN ext_translations t20_ ON t20_.locale = 'en'
  AND t20_.field = 'price'
  AND t20_.object_class = 'App\\Entity\\Annonce'
  AND t20_.foreign_key = a0_.id
  LEFT JOIN ext_translations t21_ ON t21_.locale = 'en'
  AND t21_.field = 'description'
  AND t21_.object_class = 'App\\Entity\\Annonce'
  AND t21_.foreign_key = a0_.id
  LEFT JOIN ext_translations t22_ ON t22_.locale = 'en'
  AND t22_.field = 'descriptionadd'
  AND t22_.object_class = 'App\\Entity\\Annonce'
  AND t22_.foreign_key = a0_.id
  LEFT JOIN ext_translations t23_ ON t23_.locale = 'en'
  AND t23_.field = 'specificationtechniques'
  AND t23_.object_class = 'App\\Entity\\Annonce'
  AND t23_.foreign_key = a0_.id
  LEFT JOIN ext_translations t24_ ON t24_.locale = 'en'
  AND t24_.field = 'infosgenerales'
  AND t24_.object_class = 'App\\Entity\\Annonce'
  AND t24_.foreign_key = a0_.id
  LEFT JOIN ext_translations t25_ ON t25_.locale = 'en'
  AND t25_.field = 'created_At'
  AND t25_.object_class = 'App\\Entity\\Annonce'
  AND t25_.foreign_key = a0_.id
  LEFT JOIN ext_translations t26_ ON t26_.locale = 'en'
  AND t26_.field = 'updated_At'
  AND t26_.object_class = 'App\\Entity\\Annonce'
  AND t26_.foreign_key = a0_.id
WHERE
  t1_.content = ?
ORDER BY
  t25_.content DESC

SELECT a0_.id AS id_0, t1_.content AS category_1, t2_.content AS marques_2, t3_.content AS modeles_3, t4_.content AS etats_4, t5_.content AS carosseries_5, a0_.year AS year_6, t6_.content AS kilometrage_7, t7_.content AS carburants_8, t8_.content AS transmission_9, t9_.content AS moteur_10, t10_.content AS entrainement_11, t11_.content AS couleur_ext_12, t12_.content AS couleur_int_13, a0_.numero_chassis AS numero_chassis_14, t13_.content AS consommationville_15, t14_.content AS consommation_route_16, t15_.content AS carosserie_equip_17, t16_.content AS transmission_equip_18, t17_.content AS interieur_equip_19, t18_.content AS exterieur_equip_20, t19_.content AS electronique_equip_21, a0_.dispo_securite AS dispo_securite_22, a0_.videos AS videos_23, t20_.content AS price_24, t21_.content AS description_25, t22_.content AS descriptionadd_26, t23_.content AS specificationtechniques_27, t24_.content AS infosgenerales_28, a0_.brochure_filename AS brochure_filename_29, a0_.brochure_size AS brochure_size_30, t25_.content AS created_at_31, t26_.content AS updated_at_32, a0_.device AS device_33, a0_.regions AS regions_34, a0_.villes AS villes_35, a0_.communes AS communes_36, a0_.address AS address_37, a0_.type AS type_38, a0_.urgent AS urgent_39, a0_.nbrcylindre AS nbrcylindre_40, a0_.numero_enregistrement AS numero_enregistrement_41, a0_.is_favoris AS is_favoris_42, a0_.has_co2 AS has_co2_43, a0_.export_price AS export_price_44, a0_.bargan_price AS bargan_price_45, a0_.is_active AS is_active_46, a0_.int_moto AS int_moto_47, a0_.electro_moto AS electro_moto_48, a0_.disposec_moto AS disposec_moto_49, a0_.dispconf_moto AS dispconf_moto_50, a0_.lon AS lon_51, a0_.lat AS lat_52, a0_.duration AS duration_53, a0_.comments AS comments_54, a0_.note AS note_55, a0_.is_compared AS is_compared_56, a0_.user_id AS user_id_57 FROM annonce a0_ LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'category' AND t1_.object_class = 'App\\Entity\\Annonce' AND t1_.foreign_key = a0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'marques' AND t2_.object_class = 'App\\Entity\\Annonce' AND t2_.foreign_key = a0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'modeles' AND t3_.object_class = 'App\\Entity\\Annonce' AND t3_.foreign_key = a0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'etats' AND t4_.object_class = 'App\\Entity\\Annonce' AND t4_.foreign_key = a0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'carosseries' AND t5_.object_class = 'App\\Entity\\Annonce' AND t5_.foreign_key = a0_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'kilometrage' AND t6_.object_class = 'App\\Entity\\Annonce' AND t6_.foreign_key = a0_.id LEFT JOIN ext_translations t7_ ON t7_.locale = 'en' AND t7_.field = 'carburants' AND t7_.object_class = 'App\\Entity\\Annonce' AND t7_.foreign_key = a0_.id LEFT JOIN ext_translations t8_ ON t8_.locale = 'en' AND t8_.field = 'transmission' AND t8_.object_class = 'App\\Entity\\Annonce' AND t8_.foreign_key = a0_.id LEFT JOIN ext_translations t9_ ON t9_.locale = 'en' AND t9_.field = 'moteur' AND t9_.object_class = 'App\\Entity\\Annonce' AND t9_.foreign_key = a0_.id LEFT JOIN ext_translations t10_ ON t10_.locale = 'en' AND t10_.field = 'entrainement' AND t10_.object_class = 'App\\Entity\\Annonce' AND t10_.foreign_key = a0_.id LEFT JOIN ext_translations t11_ ON t11_.locale = 'en' AND t11_.field = 'couleurExt' AND t11_.object_class = 'App\\Entity\\Annonce' AND t11_.foreign_key = a0_.id LEFT JOIN ext_translations t12_ ON t12_.locale = 'en' AND t12_.field = 'couleurInt' AND t12_.object_class = 'App\\Entity\\Annonce' AND t12_.foreign_key = a0_.id LEFT JOIN ext_translations t13_ ON t13_.locale = 'en' AND t13_.field = 'consommationville' AND t13_.object_class = 'App\\Entity\\Annonce' AND t13_.foreign_key = a0_.id LEFT JOIN ext_translations t14_ ON t14_.locale = 'en' AND t14_.field = 'consommationRoute' AND t14_.object_class = 'App\\Entity\\Annonce' AND t14_.foreign_key = a0_.id LEFT JOIN ext_translations t15_ ON t15_.locale = 'en' AND t15_.field = 'carosserieEquip' AND t15_.object_class = 'App\\Entity\\Annonce' AND t15_.foreign_key = a0_.id LEFT JOIN ext_translations t16_ ON t16_.locale = 'en' AND t16_.field = 'transmissionEquip' AND t16_.object_class = 'App\\Entity\\Annonce' AND t16_.foreign_key = a0_.id LEFT JOIN ext_translations t17_ ON t17_.locale = 'en' AND t17_.field = 'InterieurEquip' AND t17_.object_class = 'App\\Entity\\Annonce' AND t17_.foreign_key = a0_.id LEFT JOIN ext_translations t18_ ON t18_.locale = 'en' AND t18_.field = 'exterieurEquip' AND t18_.object_class = 'App\\Entity\\Annonce' AND t18_.foreign_key = a0_.id LEFT JOIN ext_translations t19_ ON t19_.locale = 'en' AND t19_.field = 'electroniqueEquip' AND t19_.object_class = 'App\\Entity\\Annonce' AND t19_.foreign_key = a0_.id LEFT JOIN ext_translations t20_ ON t20_.locale = 'en' AND t20_.field = 'price' AND t20_.object_class = 'App\\Entity\\Annonce' AND t20_.foreign_key = a0_.id LEFT JOIN ext_translations t21_ ON t21_.locale = 'en' AND t21_.field = 'description' AND t21_.object_class = 'App\\Entity\\Annonce' AND t21_.foreign_key = a0_.id LEFT JOIN ext_translations t22_ ON t22_.locale = 'en' AND t22_.field = 'descriptionadd' AND t22_.object_class = 'App\\Entity\\Annonce' AND t22_.foreign_key = a0_.id LEFT JOIN ext_translations t23_ ON t23_.locale = 'en' AND t23_.field = 'specificationtechniques' AND t23_.object_class = 'App\\Entity\\Annonce' AND t23_.foreign_key = a0_.id LEFT JOIN ext_translations t24_ ON t24_.locale = 'en' AND t24_.field = 'infosgenerales' AND t24_.object_class = 'App\\Entity\\Annonce' AND t24_.foreign_key = a0_.id LEFT JOIN ext_translations t25_ ON t25_.locale = 'en' AND t25_.field = 'created_At' AND t25_.object_class = 'App\\Entity\\Annonce' AND t25_.foreign_key = a0_.id LEFT JOIN ext_translations t26_ ON t26_.locale = 'en' AND t26_.field = 'updated_At' AND t26_.object_class = 'App\\Entity\\Annonce' AND t26_.foreign_key = a0_.id WHERE t1_.content = 'Auto' ORDER BY t25_.content DESC;

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
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '4' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\PubInfos';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '3' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\PubInfos';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '2' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\PubInfos';

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
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '1' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Pub';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '2' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Pub';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '15' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Pub';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '23' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Pub';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '24' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Pub';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '25' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Pub';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '26' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Pub';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '27' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Pub';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '28' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Pub';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '29' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Pub';