Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.50 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.50 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

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

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 = 'Moto' AND a0_.type = 'Gold' ORDER BY a0_.id DESC LIMIT 15 LIMIT 15;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 239)
7	App\Repository\AnnonceRepository->findAnnoncesByTypesandCategory (line 124)
8	App\Controller\PanController->typeCategory (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

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.

Symfony Profiler

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

Configuration Settings

Theme