Symfony Profiler

Query Metrics

21 Database Queries
4 Different statements
15.62 ms Query time
3 Invalid entities
Queries


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 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 = ? 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 = ? AND e0_.locale = ? AND e0_.object_class = ?
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 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 = ? 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 = ? 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 = ? 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 = ? 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 = ? 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 = ? 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 = ? 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 = ? 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 = ? 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 = ? 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 = ? AND e0_.locale = ? AND e0_.object_class = ?
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 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 = ? AND e0_.locale = ? AND e0_.object_class = ?
Database Connections

Name	Service
default	doctrine.dbal.default_connection
Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
Second Level Cache

Second Level Cache is not enabled.
Entities Mapping

Class	Mapping errors
App\Entity\Annuaire	No errors.
App\Entity\User	The association App\Entity\User#boutiques refers to the owning side field App\Entity\Boutique#userId which does not exist.
App\Entity\Professionel	The association App\Entity\Professionel#boutiques refers to the owning side field App\Entity\Boutique#userId which does not exist. The mappings App\Entity\Professionel#artilces and App\Entity\Article#professionel are inconsistent with each other.
App\Entity\Annonce	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	No errors.
App\Entity\PubInfos	No errors.
App\Entity\Admin	The association App\Entity\Admin#boutiques refers to the owning side field App\Entity\Boutique#userId which does not exist.
App\Entity\Pub	No errors.
Symfony Profiler

GET https://topautosntest.sn-topauto.com/en/annuaires/pro/Concessionnaires

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping
