Error 500 Internal Server Error

GET http://mail.sn-topauto.commail.sn-topauto.com/en/filter/vehicules/Moto/Gold

IP
20.171.207.190
Profiled on
Token
eddda9
Forwarded to ErrorController (a394a6)

Query Metrics

1 Database Queries
1 Different statements
1.72 ms Query time
6 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.72 ms 
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 = ? AND a0_.type = ? ORDER BY a0_.id DESC LIMIT 15 LIMIT 15
Parameters: 
[
  "Moto"
  "Gold"
]
View formatted query    View runnable query    Explain query    View query backtrace

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\Annonce No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation No errors.
Gedmo\Translatable\Entity\Translation 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\Picture No errors.
App\Entity\Boutique No errors.
App\Entity\Code No errors.
App\Entity\Avis No errors.
App\Entity\OffreCredit No errors.
App\Entity\JournalCredit No errors.
App\Entity\Message No errors.
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\Particulier
  • The association App\Entity\Particulier#boutiques refers to the owning side field App\Entity\Boutique#userId which does not exist.
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\Abonne No errors.
App\Entity\Comment No errors.
App\Entity\Contact No errors.
App\Entity\Recommandation
  • The association App\Entity\Recommandation#annonce refers to the inverse side field App\Entity\Annonce#recommandations which does not exist.
App\Entity\Abonnee No errors.
App\Entity\Marque No errors.
App\Entity\Visiteur No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\Vitrine No errors.
App\Entity\DepotRecherche No errors.
App\Entity\Pub No errors.
App\Entity\PubInfos No errors.
App\Entity\Portrait No errors.
App\Entity\Offer No errors.
App\Entity\Modele No errors.
App\Entity\EssaiVehicule No errors.
App\Entity\ContactTel No errors.
App\Entity\ContactAnnonce No errors.
App\Entity\Article
  • The association App\Entity\Article#professionel refers to the inverse side field App\Entity\Professionel#articles which does not exist.
App\Entity\Commenter No errors.
App\Entity\Annuaire No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation No errors.
Vich\UploaderBundle\Entity\File No errors.