Symfony Profiler

SELECT
  a0_.id AS id_0,
  t1_.content AS categorie_1,
  t2_.content AS nom_an_2,
  t3_.content AS description_3,
  t4_.content 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,
  t5_.content AS updated_at_10,
  u6_.id AS id_11,
  u6_.email AS email_12,
  u6_.roles AS roles_13,
  u6_.password AS password_14,
  t7_.content AS type_compte_15,
  u6_.is_verified AS is_verified_16,
  t8_.content AS tel_17,
  u6_.approve AS approve_18,
  u6_.facebook_id AS facebook_id_19,
  u6_.is_super_admin AS is_super_admin_20,
  u6_.facebook AS facebook_21,
  u6_.twitter AS twitter_22,
  u6_.instagram AS instagram_23,
  u6_.linkedin AS linkedin_24,
  u6_.youtube AS youtube_25,
  u6_.whatsapp AS whatsapp_26,
  u6_.pinterest AS pinterest_27,
  u6_.facebook_access_token AS facebook_access_token_28,
  u6_.twitter_id AS twitter_id_29,
  u6_.twitter_access_token AS twitter_access_token_30,
  u6_.google_id AS google_id_31,
  u6_.google_access_token AS google_access_token_32,
  p36_.logo AS logo_33,
  p36_.nom_professionel AS nom_professionel_34,
  p36_.addresse AS addresse_35,
  p36_.marques AS marques_36,
  p36_.website AS website_37,
  p36_.image_size AS image_size_38,
  p36_.updated_at AS updated_at_39,
  p36_.description AS description_40,
  a9_.id AS id_41,
  t10_.content AS category_42,
  t11_.content AS marques_43,
  t12_.content AS modeles_44,
  t13_.content AS etats_45,
  t14_.content AS carosseries_46,
  a9_.year AS year_47,
  t15_.content AS kilometrage_48,
  t16_.content AS carburants_49,
  t17_.content AS transmission_50,
  t18_.content AS moteur_51,
  t19_.content AS entrainement_52,
  t20_.content AS couleur_ext_53,
  t21_.content AS couleur_int_54,
  a9_.numero_chassis AS numero_chassis_55,
  t22_.content AS consommationville_56,
  t23_.content AS consommation_route_57,
  t24_.content AS carosserie_equip_58,
  t25_.content AS transmission_equip_59,
  t26_.content AS interieur_equip_60,
  t27_.content AS exterieur_equip_61,
  t28_.content AS electronique_equip_62,
  a9_.dispo_securite AS dispo_securite_63,
  a9_.videos AS videos_64,
  t29_.content AS price_65,
  t30_.content AS description_66,
  t31_.content AS descriptionadd_67,
  t32_.content AS specificationtechniques_68,
  t33_.content AS infosgenerales_69,
  a9_.brochure_filename AS brochure_filename_70,
  a9_.brochure_size AS brochure_size_71,
  t34_.content AS created_at_72,
  t35_.content AS updated_at_73,
  a9_.device AS device_74,
  a9_.regions AS regions_75,
  a9_.villes AS villes_76,
  a9_.communes AS communes_77,
  a9_.address AS address_78,
  a9_.type AS type_79,
  a9_.urgent AS urgent_80,
  a9_.nbrcylindre AS nbrcylindre_81,
  a9_.numero_enregistrement AS numero_enregistrement_82,
  a9_.is_favoris AS is_favoris_83,
  a9_.has_co2 AS has_co2_84,
  a9_.export_price AS export_price_85,
  a9_.bargan_price AS bargan_price_86,
  a9_.is_active AS is_active_87,
  a9_.int_moto AS int_moto_88,
  a9_.electro_moto AS electro_moto_89,
  a9_.disposec_moto AS disposec_moto_90,
  a9_.dispconf_moto AS dispconf_moto_91,
  a9_.lon AS lon_92,
  a9_.lat AS lat_93,
  a9_.duration AS duration_94,
  a9_.comments AS comments_95,
  a9_.note AS note_96,
  a9_.is_compared AS is_compared_97,
  a0_.user_an_id AS user_an_id_98,
  u6_.compte AS compte_99,
  a9_.user_id AS user_id_100
FROM
  annuaire a0_
  LEFT JOIN professionel p36_ ON a0_.user_an_id = p36_.id
  LEFT JOIN user u6_ ON p36_.id = u6_.id
  LEFT JOIN annonce a9_ ON u6_.id = a9_.user_id
  LEFT JOIN ext_translations t1_ ON t1_.locale = 'en'
  AND t1_.field = 'categorie'
  AND t1_.object_class = 'App\\Entity\\Annuaire'
  AND t1_.foreign_key = a0_.id
  LEFT JOIN ext_translations t2_ ON t2_.locale = 'en'
  AND t2_.field = 'nomAn'
  AND t2_.object_class = 'App\\Entity\\Annuaire'
  AND t2_.foreign_key = a0_.id
  LEFT JOIN ext_translations t3_ ON t3_.locale = 'en'
  AND t3_.field = 'description'
  AND t3_.object_class = 'App\\Entity\\Annuaire'
  AND t3_.foreign_key = a0_.id
  LEFT JOIN ext_translations t4_ ON t4_.locale = 'en'
  AND t4_.field = 'created_At'
  AND t4_.object_class = 'App\\Entity\\Annuaire'
  AND t4_.foreign_key = a0_.id
  LEFT JOIN ext_translations t5_ ON t5_.locale = 'en'
  AND t5_.field = 'updated_At'
  AND t5_.object_class = 'App\\Entity\\Annuaire'
  AND t5_.foreign_key = a0_.id
  LEFT JOIN ext_translations t7_ ON t7_.locale = 'en'
  AND t7_.field = 'typeCompte'
  AND t7_.object_class = 'App\\Entity\\User'
  AND t7_.foreign_key = u6_.id
  LEFT JOIN ext_translations t8_ ON t8_.locale = 'en'
  AND t8_.field = 'tel'
  AND t8_.object_class = 'App\\Entity\\User'
  AND t8_.foreign_key = u6_.id
  LEFT JOIN ext_translations t10_ ON t10_.locale = 'en'
  AND t10_.field = 'category'
  AND t10_.object_class = 'App\\Entity\\Annonce'
  AND t10_.foreign_key = a9_.id
  LEFT JOIN ext_translations t11_ ON t11_.locale = 'en'
  AND t11_.field = 'marques'
  AND t11_.object_class = 'App\\Entity\\Annonce'
  AND t11_.foreign_key = a9_.id
  LEFT JOIN ext_translations t12_ ON t12_.locale = 'en'
  AND t12_.field = 'modeles'
  AND t12_.object_class = 'App\\Entity\\Annonce'
  AND t12_.foreign_key = a9_.id
  LEFT JOIN ext_translations t13_ ON t13_.locale = 'en'
  AND t13_.field = 'etats'
  AND t13_.object_class = 'App\\Entity\\Annonce'
  AND t13_.foreign_key = a9_.id
  LEFT JOIN ext_translations t14_ ON t14_.locale = 'en'
  AND t14_.field = 'carosseries'
  AND t14_.object_class = 'App\\Entity\\Annonce'
  AND t14_.foreign_key = a9_.id
  LEFT JOIN ext_translations t15_ ON t15_.locale = 'en'
  AND t15_.field = 'kilometrage'
  AND t15_.object_class = 'App\\Entity\\Annonce'
  AND t15_.foreign_key = a9_.id
  LEFT JOIN ext_translations t16_ ON t16_.locale = 'en'
  AND t16_.field = 'carburants'
  AND t16_.object_class = 'App\\Entity\\Annonce'
  AND t16_.foreign_key = a9_.id
  LEFT JOIN ext_translations t17_ ON t17_.locale = 'en'
  AND t17_.field = 'transmission'
  AND t17_.object_class = 'App\\Entity\\Annonce'
  AND t17_.foreign_key = a9_.id
  LEFT JOIN ext_translations t18_ ON t18_.locale = 'en'
  AND t18_.field = 'moteur'
  AND t18_.object_class = 'App\\Entity\\Annonce'
  AND t18_.foreign_key = a9_.id
  LEFT JOIN ext_translations t19_ ON t19_.locale = 'en'
  AND t19_.field = 'entrainement'
  AND t19_.object_class = 'App\\Entity\\Annonce'
  AND t19_.foreign_key = a9_.id
  LEFT JOIN ext_translations t20_ ON t20_.locale = 'en'
  AND t20_.field = 'couleurExt'
  AND t20_.object_class = 'App\\Entity\\Annonce'
  AND t20_.foreign_key = a9_.id
  LEFT JOIN ext_translations t21_ ON t21_.locale = 'en'
  AND t21_.field = 'couleurInt'
  AND t21_.object_class = 'App\\Entity\\Annonce'
  AND t21_.foreign_key = a9_.id
  LEFT JOIN ext_translations t22_ ON t22_.locale = 'en'
  AND t22_.field = 'consommationville'
  AND t22_.object_class = 'App\\Entity\\Annonce'
  AND t22_.foreign_key = a9_.id
  LEFT JOIN ext_translations t23_ ON t23_.locale = 'en'
  AND t23_.field = 'consommationRoute'
  AND t23_.object_class = 'App\\Entity\\Annonce'
  AND t23_.foreign_key = a9_.id
  LEFT JOIN ext_translations t24_ ON t24_.locale = 'en'
  AND t24_.field = 'carosserieEquip'
  AND t24_.object_class = 'App\\Entity\\Annonce'
  AND t24_.foreign_key = a9_.id
  LEFT JOIN ext_translations t25_ ON t25_.locale = 'en'
  AND t25_.field = 'transmissionEquip'
  AND t25_.object_class = 'App\\Entity\\Annonce'
  AND t25_.foreign_key = a9_.id
  LEFT JOIN ext_translations t26_ ON t26_.locale = 'en'
  AND t26_.field = 'InterieurEquip'
  AND t26_.object_class = 'App\\Entity\\Annonce'
  AND t26_.foreign_key = a9_.id
  LEFT JOIN ext_translations t27_ ON t27_.locale = 'en'
  AND t27_.field = 'exterieurEquip'
  AND t27_.object_class = 'App\\Entity\\Annonce'
  AND t27_.foreign_key = a9_.id
  LEFT JOIN ext_translations t28_ ON t28_.locale = 'en'
  AND t28_.field = 'electroniqueEquip'
  AND t28_.object_class = 'App\\Entity\\Annonce'
  AND t28_.foreign_key = a9_.id
  LEFT JOIN ext_translations t29_ ON t29_.locale = 'en'
  AND t29_.field = 'price'
  AND t29_.object_class = 'App\\Entity\\Annonce'
  AND t29_.foreign_key = a9_.id
  LEFT JOIN ext_translations t30_ ON t30_.locale = 'en'
  AND t30_.field = 'description'
  AND t30_.object_class = 'App\\Entity\\Annonce'
  AND t30_.foreign_key = a9_.id
  LEFT JOIN ext_translations t31_ ON t31_.locale = 'en'
  AND t31_.field = 'descriptionadd'
  AND t31_.object_class = 'App\\Entity\\Annonce'
  AND t31_.foreign_key = a9_.id
  LEFT JOIN ext_translations t32_ ON t32_.locale = 'en'
  AND t32_.field = 'specificationtechniques'
  AND t32_.object_class = 'App\\Entity\\Annonce'
  AND t32_.foreign_key = a9_.id
  LEFT JOIN ext_translations t33_ ON t33_.locale = 'en'
  AND t33_.field = 'infosgenerales'
  AND t33_.object_class = 'App\\Entity\\Annonce'
  AND t33_.foreign_key = a9_.id
  LEFT JOIN ext_translations t34_ ON t34_.locale = 'en'
  AND t34_.field = 'created_At'
  AND t34_.object_class = 'App\\Entity\\Annonce'
  AND t34_.foreign_key = a9_.id
  LEFT JOIN ext_translations t35_ ON t35_.locale = 'en'
  AND t35_.field = 'updated_At'
  AND t35_.object_class = 'App\\Entity\\Annonce'
  AND t35_.foreign_key = a9_.id
WHERE
  t1_.content = ?
ORDER BY
  a0_.id DESC

SELECT a0_.id AS id_0, t1_.content AS categorie_1, t2_.content AS nom_an_2, t3_.content AS description_3, t4_.content 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, t5_.content AS updated_at_10, u6_.id AS id_11, u6_.email AS email_12, u6_.roles AS roles_13, u6_.password AS password_14, t7_.content AS type_compte_15, u6_.is_verified AS is_verified_16, t8_.content AS tel_17, u6_.approve AS approve_18, u6_.facebook_id AS facebook_id_19, u6_.is_super_admin AS is_super_admin_20, u6_.facebook AS facebook_21, u6_.twitter AS twitter_22, u6_.instagram AS instagram_23, u6_.linkedin AS linkedin_24, u6_.youtube AS youtube_25, u6_.whatsapp AS whatsapp_26, u6_.pinterest AS pinterest_27, u6_.facebook_access_token AS facebook_access_token_28, u6_.twitter_id AS twitter_id_29, u6_.twitter_access_token AS twitter_access_token_30, u6_.google_id AS google_id_31, u6_.google_access_token AS google_access_token_32, p36_.logo AS logo_33, p36_.nom_professionel AS nom_professionel_34, p36_.addresse AS addresse_35, p36_.marques AS marques_36, p36_.website AS website_37, p36_.image_size AS image_size_38, p36_.updated_at AS updated_at_39, p36_.description AS description_40, a9_.id AS id_41, t10_.content AS category_42, t11_.content AS marques_43, t12_.content AS modeles_44, t13_.content AS etats_45, t14_.content AS carosseries_46, a9_.year AS year_47, t15_.content AS kilometrage_48, t16_.content AS carburants_49, t17_.content AS transmission_50, t18_.content AS moteur_51, t19_.content AS entrainement_52, t20_.content AS couleur_ext_53, t21_.content AS couleur_int_54, a9_.numero_chassis AS numero_chassis_55, t22_.content AS consommationville_56, t23_.content AS consommation_route_57, t24_.content AS carosserie_equip_58, t25_.content AS transmission_equip_59, t26_.content AS interieur_equip_60, t27_.content AS exterieur_equip_61, t28_.content AS electronique_equip_62, a9_.dispo_securite AS dispo_securite_63, a9_.videos AS videos_64, t29_.content AS price_65, t30_.content AS description_66, t31_.content AS descriptionadd_67, t32_.content AS specificationtechniques_68, t33_.content AS infosgenerales_69, a9_.brochure_filename AS brochure_filename_70, a9_.brochure_size AS brochure_size_71, t34_.content AS created_at_72, t35_.content AS updated_at_73, a9_.device AS device_74, a9_.regions AS regions_75, a9_.villes AS villes_76, a9_.communes AS communes_77, a9_.address AS address_78, a9_.type AS type_79, a9_.urgent AS urgent_80, a9_.nbrcylindre AS nbrcylindre_81, a9_.numero_enregistrement AS numero_enregistrement_82, a9_.is_favoris AS is_favoris_83, a9_.has_co2 AS has_co2_84, a9_.export_price AS export_price_85, a9_.bargan_price AS bargan_price_86, a9_.is_active AS is_active_87, a9_.int_moto AS int_moto_88, a9_.electro_moto AS electro_moto_89, a9_.disposec_moto AS disposec_moto_90, a9_.dispconf_moto AS dispconf_moto_91, a9_.lon AS lon_92, a9_.lat AS lat_93, a9_.duration AS duration_94, a9_.comments AS comments_95, a9_.note AS note_96, a9_.is_compared AS is_compared_97, a0_.user_an_id AS user_an_id_98, u6_.compte AS compte_99, a9_.user_id AS user_id_100 FROM annuaire a0_ LEFT JOIN professionel p36_ ON a0_.user_an_id = p36_.id LEFT JOIN user u6_ ON p36_.id = u6_.id LEFT JOIN annonce a9_ ON u6_.id = a9_.user_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'categorie' AND t1_.object_class = 'App\\Entity\\Annuaire' AND t1_.foreign_key = a0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'nomAn' AND t2_.object_class = 'App\\Entity\\Annuaire' AND t2_.foreign_key = a0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.object_class = 'App\\Entity\\Annuaire' AND t3_.foreign_key = a0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'created_At' AND t4_.object_class = 'App\\Entity\\Annuaire' AND t4_.foreign_key = a0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'updated_At' AND t5_.object_class = 'App\\Entity\\Annuaire' AND t5_.foreign_key = a0_.id LEFT JOIN ext_translations t7_ ON t7_.locale = 'en' AND t7_.field = 'typeCompte' AND t7_.object_class = 'App\\Entity\\User' AND t7_.foreign_key = u6_.id LEFT JOIN ext_translations t8_ ON t8_.locale = 'en' AND t8_.field = 'tel' AND t8_.object_class = 'App\\Entity\\User' AND t8_.foreign_key = u6_.id LEFT JOIN ext_translations t10_ ON t10_.locale = 'en' AND t10_.field = 'category' AND t10_.object_class = 'App\\Entity\\Annonce' AND t10_.foreign_key = a9_.id LEFT JOIN ext_translations t11_ ON t11_.locale = 'en' AND t11_.field = 'marques' AND t11_.object_class = 'App\\Entity\\Annonce' AND t11_.foreign_key = a9_.id LEFT JOIN ext_translations t12_ ON t12_.locale = 'en' AND t12_.field = 'modeles' AND t12_.object_class = 'App\\Entity\\Annonce' AND t12_.foreign_key = a9_.id LEFT JOIN ext_translations t13_ ON t13_.locale = 'en' AND t13_.field = 'etats' AND t13_.object_class = 'App\\Entity\\Annonce' AND t13_.foreign_key = a9_.id LEFT JOIN ext_translations t14_ ON t14_.locale = 'en' AND t14_.field = 'carosseries' AND t14_.object_class = 'App\\Entity\\Annonce' AND t14_.foreign_key = a9_.id LEFT JOIN ext_translations t15_ ON t15_.locale = 'en' AND t15_.field = 'kilometrage' AND t15_.object_class = 'App\\Entity\\Annonce' AND t15_.foreign_key = a9_.id LEFT JOIN ext_translations t16_ ON t16_.locale = 'en' AND t16_.field = 'carburants' AND t16_.object_class = 'App\\Entity\\Annonce' AND t16_.foreign_key = a9_.id LEFT JOIN ext_translations t17_ ON t17_.locale = 'en' AND t17_.field = 'transmission' AND t17_.object_class = 'App\\Entity\\Annonce' AND t17_.foreign_key = a9_.id LEFT JOIN ext_translations t18_ ON t18_.locale = 'en' AND t18_.field = 'moteur' AND t18_.object_class = 'App\\Entity\\Annonce' AND t18_.foreign_key = a9_.id LEFT JOIN ext_translations t19_ ON t19_.locale = 'en' AND t19_.field = 'entrainement' AND t19_.object_class = 'App\\Entity\\Annonce' AND t19_.foreign_key = a9_.id LEFT JOIN ext_translations t20_ ON t20_.locale = 'en' AND t20_.field = 'couleurExt' AND t20_.object_class = 'App\\Entity\\Annonce' AND t20_.foreign_key = a9_.id LEFT JOIN ext_translations t21_ ON t21_.locale = 'en' AND t21_.field = 'couleurInt' AND t21_.object_class = 'App\\Entity\\Annonce' AND t21_.foreign_key = a9_.id LEFT JOIN ext_translations t22_ ON t22_.locale = 'en' AND t22_.field = 'consommationville' AND t22_.object_class = 'App\\Entity\\Annonce' AND t22_.foreign_key = a9_.id LEFT JOIN ext_translations t23_ ON t23_.locale = 'en' AND t23_.field = 'consommationRoute' AND t23_.object_class = 'App\\Entity\\Annonce' AND t23_.foreign_key = a9_.id LEFT JOIN ext_translations t24_ ON t24_.locale = 'en' AND t24_.field = 'carosserieEquip' AND t24_.object_class = 'App\\Entity\\Annonce' AND t24_.foreign_key = a9_.id LEFT JOIN ext_translations t25_ ON t25_.locale = 'en' AND t25_.field = 'transmissionEquip' AND t25_.object_class = 'App\\Entity\\Annonce' AND t25_.foreign_key = a9_.id LEFT JOIN ext_translations t26_ ON t26_.locale = 'en' AND t26_.field = 'InterieurEquip' AND t26_.object_class = 'App\\Entity\\Annonce' AND t26_.foreign_key = a9_.id LEFT JOIN ext_translations t27_ ON t27_.locale = 'en' AND t27_.field = 'exterieurEquip' AND t27_.object_class = 'App\\Entity\\Annonce' AND t27_.foreign_key = a9_.id LEFT JOIN ext_translations t28_ ON t28_.locale = 'en' AND t28_.field = 'electroniqueEquip' AND t28_.object_class = 'App\\Entity\\Annonce' AND t28_.foreign_key = a9_.id LEFT JOIN ext_translations t29_ ON t29_.locale = 'en' AND t29_.field = 'price' AND t29_.object_class = 'App\\Entity\\Annonce' AND t29_.foreign_key = a9_.id LEFT JOIN ext_translations t30_ ON t30_.locale = 'en' AND t30_.field = 'description' AND t30_.object_class = 'App\\Entity\\Annonce' AND t30_.foreign_key = a9_.id LEFT JOIN ext_translations t31_ ON t31_.locale = 'en' AND t31_.field = 'descriptionadd' AND t31_.object_class = 'App\\Entity\\Annonce' AND t31_.foreign_key = a9_.id LEFT JOIN ext_translations t32_ ON t32_.locale = 'en' AND t32_.field = 'specificationtechniques' AND t32_.object_class = 'App\\Entity\\Annonce' AND t32_.foreign_key = a9_.id LEFT JOIN ext_translations t33_ ON t33_.locale = 'en' AND t33_.field = 'infosgenerales' AND t33_.object_class = 'App\\Entity\\Annonce' AND t33_.foreign_key = a9_.id LEFT JOIN ext_translations t34_ ON t34_.locale = 'en' AND t34_.field = 'created_At' AND t34_.object_class = 'App\\Entity\\Annonce' AND t34_.foreign_key = a9_.id LEFT JOIN ext_translations t35_ ON t35_.locale = 'en' AND t35_.field = 'updated_At' AND t35_.object_class = 'App\\Entity\\Annonce' AND t35_.foreign_key = a9_.id WHERE t1_.content = 'Agences de Location' ORDER BY a0_.id DESC;

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