Symfony Profiler

Query Metrics

57 Database Queries

13 Different statements

34.31 ms Query time

5 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

21.48 ms
(62.62%)

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.role AS role_2, p0_.year AS year_3, p0_.logo AS logo_4, p0_.image_size AS image_size_5, p0_.updated_at AS updated_at_6, p0_.description AS description_7, p0_.created_at AS created_at_8, p0_.theme_portrait AS theme_portrait_9, p0_.admin_id AS admin_id_10 FROM portrait p0_ ORDER BY p0_.id DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.nom AS nom_1,
  p0_.role AS role_2,
  p0_.year AS year_3,
  p0_.logo AS logo_4,
  p0_.image_size AS image_size_5,
  p0_.updated_at AS updated_at_6,
  p0_.description AS description_7,
  p0_.created_at AS created_at_8,
  p0_.theme_portrait AS theme_portrait_9,
  p0_.admin_id AS admin_id_10
FROM
  portrait p0_
ORDER BY
  p0_.id DESC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.role AS role_2, p0_.year AS year_3, p0_.logo AS logo_4, p0_.image_size AS image_size_5, p0_.updated_at AS updated_at_6, p0_.description AS description_7, p0_.created_at AS created_at_8, p0_.theme_portrait AS theme_portrait_9, p0_.admin_id AS admin_id_10 FROM portrait p0_ ORDER BY p0_.id DESC LIMIT 1;

#	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 74)
7	App\Repository\PortraitRepository->findByPortraitLatest (line 80)
8	App\Controller\HomeController->index (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)

8.30 ms
(24.18%)

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 = ?

Parameters:

[
  "58"
  "en"
  "App\Entity\Article"
]

View formatted query View runnable query Explain query View query backtrace

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 = '58' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Article';

#	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 919)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 105)
7	Gedmo\Translatable\Mapping\Event\Adapter\ORM->loadTranslations (line 525)
8	Gedmo\Translatable\TranslatableListener->postLoad (line 63)
9	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 98)
10	Doctrine\ORM\Event\ListenersInvoker->invoke (line 66)
11	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 3981)
12	Doctrine\ORM\UnitOfWork->hydrationComplete (line 129)
13	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 274)
14	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1231)
15	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
16	Doctrine\ORM\AbstractQuery->execute (line 907)
17	Doctrine\ORM\AbstractQuery->getResult (line 60)
18	App\Repository\ArticleRepository->findByArticleLatest (line 78)
19	App\Controller\HomeController->index (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.75 ms
(2.20%)

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 a0_.type = ? ORDER BY a0_.id DESC

Parameters:

[
  "Prestige"
]

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
  a0_.type = ?
ORDER BY
  a0_.id 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 a0_.type = 'Prestige' ORDER BY a0_.id DESC;

#	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 199)
7	App\Repository\AnnonceRepository->findAnnoncesByType (line 84)
8	App\Controller\HomeController->index (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)

0.75 ms
(2.19%)

SELECT t0.id AS id_1, t0.article_id AS article_id_2, t0.commenter_id AS commenter_id_3 FROM comment t0 WHERE t0.article_id = ?

Parameters:

[
  58
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.article_id AS article_id_2,
  t0.commenter_id AS commenter_id_3
FROM
  comment t0
WHERE
  t0.article_id = ?

SELECT t0.id AS id_1, t0.article_id AS article_id_2, t0.commenter_id AS commenter_id_3 FROM comment t0 WHERE t0.article_id = 58;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1928)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1869)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 1241)
9	Twig\Extension\CoreExtension::length (line 83)
10	__TwigTemplate_9036a10dabba5a2c6f2b8635d81036fc->doDisplay (line 388)
11	Twig\Template->yield (line 1330)
12	__TwigTemplate_8db93f86d8e3dbcec6b099d76a1a4ce1->block_body (line 432)
13	Twig\Template->yieldBlock (line 100)
14	__TwigTemplate_4d0e21a9134068d550e5879f9ad8f08b->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_b05030c9229ab1feaad5a2a16295ffda->doDisplay (line 388)
17	Twig\Template->yield (line 56)
18	__TwigTemplate_8db93f86d8e3dbcec6b099d76a1a4ce1->doDisplay (line 388)
19	Twig\Template->yield (line 344)
20	Twig\Template->display (line 359)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 334)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 92)
27	App\Controller\HomeController->index (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.53 ms
(1.54%)

SELECT t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.password AS password_7, t0.type_compte AS type_compte_8, t0.is_verified AS is_verified_9, t0.tel AS tel_10, t0.approve AS approve_11, t0.facebook_id AS facebook_id_12, t0.is_super_admin AS is_super_admin_13, t0.facebook AS facebook_14, t0.twitter AS twitter_15, t0.instagram AS instagram_16, t0.linkedin AS linkedin_17, t0.youtube AS youtube_18, t0.whatsapp AS whatsapp_19, t0.pinterest AS pinterest_20, t0.facebook_access_token AS facebook_access_token_21, t0.twitter_id AS twitter_id_22, t0.twitter_access_token AS twitter_access_token_23, t0.google_id AS google_id_24, t0.google_access_token AS google_access_token_25, t0.compte, t1.logo AS logo_26, t1.nom_professionel AS nom_professionel_27, t1.addresse AS addresse_28, t1.marques AS marques_29, t1.website AS website_30, t1.image_size AS image_size_31, t1.updated_at AS updated_at_32, t1.description AS description_33, t2.prenom AS prenom_34, t2.nom AS nom_35, t2.civility AS civility_36, t2.photo AS photo_37, t2.image_size AS image_size_38, t2.updated_at AS updated_at_39, t3.photo AS photo_40, t3.image_size AS image_size_41, t3.updated_at AS updated_at_42 FROM user t0 LEFT JOIN professionel t1 ON t0.id = t1.id LEFT JOIN particulier t2 ON t0.id = t2.id LEFT JOIN admin t3 ON t0.id = t3.id WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_4,
  t0.email AS email_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.type_compte AS type_compte_8,
  t0.is_verified AS is_verified_9,
  t0.tel AS tel_10,
  t0.approve AS approve_11,
  t0.facebook_id AS facebook_id_12,
  t0.is_super_admin AS is_super_admin_13,
  t0.facebook AS facebook_14,
  t0.twitter AS twitter_15,
  t0.instagram AS instagram_16,
  t0.linkedin AS linkedin_17,
  t0.youtube AS youtube_18,
  t0.whatsapp AS whatsapp_19,
  t0.pinterest AS pinterest_20,
  t0.facebook_access_token AS facebook_access_token_21,
  t0.twitter_id AS twitter_id_22,
  t0.twitter_access_token AS twitter_access_token_23,
  t0.google_id AS google_id_24,
  t0.google_access_token AS google_access_token_25,
  t0.compte,
  t1.logo AS logo_26,
  t1.nom_professionel AS nom_professionel_27,
  t1.addresse AS addresse_28,
  t1.marques AS marques_29,
  t1.website AS website_30,
  t1.image_size AS image_size_31,
  t1.updated_at AS updated_at_32,
  t1.description AS description_33,
  t2.prenom AS prenom_34,
  t2.nom AS nom_35,
  t2.civility AS civility_36,
  t2.photo AS photo_37,
  t2.image_size AS image_size_38,
  t2.updated_at AS updated_at_39,
  t3.photo AS photo_40,
  t3.image_size AS image_size_41,
  t3.updated_at AS updated_at_42
FROM
  user t0
  LEFT JOIN professionel t1 ON t0.id = t1.id
  LEFT JOIN particulier t2 ON t0.id = t2.id
  LEFT JOIN admin t3 ON t0.id = t3.id
WHERE
  t0.id = ?

SELECT t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.password AS password_7, t0.type_compte AS type_compte_8, t0.is_verified AS is_verified_9, t0.tel AS tel_10, t0.approve AS approve_11, t0.facebook_id AS facebook_id_12, t0.is_super_admin AS is_super_admin_13, t0.facebook AS facebook_14, t0.twitter AS twitter_15, t0.instagram AS instagram_16, t0.linkedin AS linkedin_17, t0.youtube AS youtube_18, t0.whatsapp AS whatsapp_19, t0.pinterest AS pinterest_20, t0.facebook_access_token AS facebook_access_token_21, t0.twitter_id AS twitter_id_22, t0.twitter_access_token AS twitter_access_token_23, t0.google_id AS google_id_24, t0.google_access_token AS google_access_token_25, t0.compte, t1.logo AS logo_26, t1.nom_professionel AS nom_professionel_27, t1.addresse AS addresse_28, t1.marques AS marques_29, t1.website AS website_30, t1.image_size AS image_size_31, t1.updated_at AS updated_at_32, t1.description AS description_33, t2.prenom AS prenom_34, t2.nom AS nom_35, t2.civility AS civility_36, t2.photo AS photo_37, t2.image_size AS image_size_38, t2.updated_at AS updated_at_39, t3.photo AS photo_40, t3.image_size AS image_size_41, t3.updated_at AS updated_at_42 FROM user t0 LEFT JOIN professionel t1 ON t0.id = t1.id LEFT JOIN particulier t2 ON t0.id = t2.id LEFT JOIN admin t3 ON t0.id = t3.id WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 823)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 3099)
4	Doctrine\ORM\UnitOfWork->createEntity (line 272)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 502)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 272)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1231)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
10	Doctrine\ORM\AbstractQuery->execute (line 907)
11	Doctrine\ORM\AbstractQuery->getResult (line 76)
12	App\Repository\AnnonceRepository->findByAnnonceLatest (line 79)
13	App\Controller\HomeController->index (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.50 ms
(1.45%)

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 t5_.content = ? ORDER BY a0_.id DESC

Parameters:

[
  null
]

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
  t5_.content = ?
ORDER BY
  a0_.id 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 t5_.content = NULL ORDER BY a0_.id DESC;

#	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 150)
7	App\Repository\AnnonceRepository->findAnnoncesByCarroserie (line 81)
8	App\Controller\HomeController->index (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)

0.46 ms
(1.35%)

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 = ?

Parameters:

[
  "Entéte du site"
]

View formatted query View runnable query Explain query View query backtrace

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 89)
4	App\Controller\HomeController->index (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.34 ms
(0.99%)

SELECT a0_.id AS id_0, a0_.filename AS filename_1, a0_.image_size AS image_size_2, a0_.title AS title_3, a0_.description AS description_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.type_art AS type_art_7, a0_.professionel_id AS professionel_id_8, a0_.admin_id AS admin_id_9 FROM article a0_ INNER JOIN admin a1_ ON a0_.admin_id = a1_.id LEFT JOIN user u2_ ON a1_.id = u2_.id WHERE a0_.type_art IS NULL ORDER BY a0_.id DESC LIMIT 3

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.filename AS filename_1,
  a0_.image_size AS image_size_2,
  a0_.title AS title_3,
  a0_.description AS description_4,
  a0_.created_at AS created_at_5,
  a0_.updated_at AS updated_at_6,
  a0_.type_art AS type_art_7,
  a0_.professionel_id AS professionel_id_8,
  a0_.admin_id AS admin_id_9
FROM
  article a0_
  INNER JOIN admin a1_ ON a0_.admin_id = a1_.id
  LEFT JOIN user u2_ ON a1_.id = u2_.id
WHERE
  a0_.type_art IS NULL
ORDER BY
  a0_.id DESC
LIMIT
  3

SELECT a0_.id AS id_0, a0_.filename AS filename_1, a0_.image_size AS image_size_2, a0_.title AS title_3, a0_.description AS description_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.type_art AS type_art_7, a0_.professionel_id AS professionel_id_8, a0_.admin_id AS admin_id_9 FROM article a0_ INNER JOIN admin a1_ ON a0_.admin_id = a1_.id LEFT JOIN user u2_ ON a1_.id = u2_.id WHERE a0_.type_art IS NULL ORDER BY a0_.id DESC LIMIT 3;

#	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 60)
7	App\Repository\ArticleRepository->findByArticleLatest (line 78)
8	App\Controller\HomeController->index (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)

0.33 ms
(0.96%)

SELECT a0_.id AS id_0, a0_.category AS category_1, a0_.marques AS marques_2, a0_.modeles AS modeles_3, a0_.etats AS etats_4, a0_.carosseries AS carosseries_5, a0_.year AS year_6, a0_.kilometrage AS kilometrage_7, a0_.carburants AS carburants_8, a0_.transmission AS transmission_9, a0_.moteur AS moteur_10, a0_.entrainement AS entrainement_11, a0_.couleur_ext AS couleur_ext_12, a0_.couleur_int AS couleur_int_13, a0_.numero_chassis AS numero_chassis_14, a0_.consommationville AS consommationville_15, a0_.consommation_route AS consommation_route_16, a0_.carosserie_equip AS carosserie_equip_17, a0_.transmission_equip AS transmission_equip_18, a0_.interieur_equip AS interieur_equip_19, a0_.exterieur_equip AS exterieur_equip_20, a0_.electronique_equip AS electronique_equip_21, a0_.dispo_securite AS dispo_securite_22, a0_.videos AS videos_23, a0_.price AS price_24, a0_.description AS description_25, a0_.descriptionadd AS descriptionadd_26, a0_.specificationtechniques AS specificationtechniques_27, a0_.infosgenerales AS infosgenerales_28, a0_.brochure_filename AS brochure_filename_29, a0_.brochure_size AS brochure_size_30, a0_.created_at AS created_at_31, a0_.updated_at 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_ ORDER BY a0_.id DESC LIMIT 6

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.category AS category_1,
  a0_.marques AS marques_2,
  a0_.modeles AS modeles_3,
  a0_.etats AS etats_4,
  a0_.carosseries AS carosseries_5,
  a0_.year AS year_6,
  a0_.kilometrage AS kilometrage_7,
  a0_.carburants AS carburants_8,
  a0_.transmission AS transmission_9,
  a0_.moteur AS moteur_10,
  a0_.entrainement AS entrainement_11,
  a0_.couleur_ext AS couleur_ext_12,
  a0_.couleur_int AS couleur_int_13,
  a0_.numero_chassis AS numero_chassis_14,
  a0_.consommationville AS consommationville_15,
  a0_.consommation_route AS consommation_route_16,
  a0_.carosserie_equip AS carosserie_equip_17,
  a0_.transmission_equip AS transmission_equip_18,
  a0_.interieur_equip AS interieur_equip_19,
  a0_.exterieur_equip AS exterieur_equip_20,
  a0_.electronique_equip AS electronique_equip_21,
  a0_.dispo_securite AS dispo_securite_22,
  a0_.videos AS videos_23,
  a0_.price AS price_24,
  a0_.description AS description_25,
  a0_.descriptionadd AS descriptionadd_26,
  a0_.specificationtechniques AS specificationtechniques_27,
  a0_.infosgenerales AS infosgenerales_28,
  a0_.brochure_filename AS brochure_filename_29,
  a0_.brochure_size AS brochure_size_30,
  a0_.created_at AS created_at_31,
  a0_.updated_at 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_
ORDER BY
  a0_.id DESC
LIMIT
  6

SELECT a0_.id AS id_0, a0_.category AS category_1, a0_.marques AS marques_2, a0_.modeles AS modeles_3, a0_.etats AS etats_4, a0_.carosseries AS carosseries_5, a0_.year AS year_6, a0_.kilometrage AS kilometrage_7, a0_.carburants AS carburants_8, a0_.transmission AS transmission_9, a0_.moteur AS moteur_10, a0_.entrainement AS entrainement_11, a0_.couleur_ext AS couleur_ext_12, a0_.couleur_int AS couleur_int_13, a0_.numero_chassis AS numero_chassis_14, a0_.consommationville AS consommationville_15, a0_.consommation_route AS consommation_route_16, a0_.carosserie_equip AS carosserie_equip_17, a0_.transmission_equip AS transmission_equip_18, a0_.interieur_equip AS interieur_equip_19, a0_.exterieur_equip AS exterieur_equip_20, a0_.electronique_equip AS electronique_equip_21, a0_.dispo_securite AS dispo_securite_22, a0_.videos AS videos_23, a0_.price AS price_24, a0_.description AS description_25, a0_.descriptionadd AS descriptionadd_26, a0_.specificationtechniques AS specificationtechniques_27, a0_.infosgenerales AS infosgenerales_28, a0_.brochure_filename AS brochure_filename_29, a0_.brochure_size AS brochure_size_30, a0_.created_at AS created_at_31, a0_.updated_at 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_ ORDER BY a0_.id DESC LIMIT 6;

#	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 76)
7	App\Repository\AnnonceRepository->findByAnnonceLatest (line 79)
8	App\Controller\HomeController->index (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)

0.25 ms
(0.73%)

SELECT t0.id AS id_1, t0.category AS category_2, t0.marques AS marques_3, t0.modeles AS modeles_4, t0.etats AS etats_5, t0.carosseries AS carosseries_6, t0.year AS year_7, t0.kilometrage AS kilometrage_8, t0.carburants AS carburants_9, t0.transmission AS transmission_10, t0.moteur AS moteur_11, t0.entrainement AS entrainement_12, t0.couleur_ext AS couleur_ext_13, t0.couleur_int AS couleur_int_14, t0.numero_chassis AS numero_chassis_15, t0.consommationville AS consommationville_16, t0.consommation_route AS consommation_route_17, t0.carosserie_equip AS carosserie_equip_18, t0.transmission_equip AS transmission_equip_19, t0.interieur_equip AS interieur_equip_20, t0.exterieur_equip AS exterieur_equip_21, t0.electronique_equip AS electronique_equip_22, t0.dispo_securite AS dispo_securite_23, t0.videos AS videos_24, t0.price AS price_25, t0.description AS description_26, t0.descriptionadd AS descriptionadd_27, t0.specificationtechniques AS specificationtechniques_28, t0.infosgenerales AS infosgenerales_29, t0.brochure_filename AS brochure_filename_30, t0.brochure_size AS brochure_size_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.device AS device_34, t0.regions AS regions_35, t0.villes AS villes_36, t0.communes AS communes_37, t0.address AS address_38, t0.type AS type_39, t0.urgent AS urgent_40, t0.nbrcylindre AS nbrcylindre_41, t0.numero_enregistrement AS numero_enregistrement_42, t0.is_favoris AS is_favoris_43, t0.has_co2 AS has_co2_44, t0.export_price AS export_price_45, t0.bargan_price AS bargan_price_46, t0.is_active AS is_active_47, t0.int_moto AS int_moto_48, t0.electro_moto AS electro_moto_49, t0.disposec_moto AS disposec_moto_50, t0.dispconf_moto AS dispconf_moto_51, t0.lon AS lon_52, t0.lat AS lat_53, t0.duration AS duration_54, t0.comments AS comments_55, t0.note AS note_56, t0.is_compared AS is_compared_57, t0.user_id AS user_id_58 FROM annonce t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.category AS category_2,
  t0.marques AS marques_3,
  t0.modeles AS modeles_4,
  t0.etats AS etats_5,
  t0.carosseries AS carosseries_6,
  t0.year AS year_7,
  t0.kilometrage AS kilometrage_8,
  t0.carburants AS carburants_9,
  t0.transmission AS transmission_10,
  t0.moteur AS moteur_11,
  t0.entrainement AS entrainement_12,
  t0.couleur_ext AS couleur_ext_13,
  t0.couleur_int AS couleur_int_14,
  t0.numero_chassis AS numero_chassis_15,
  t0.consommationville AS consommationville_16,
  t0.consommation_route AS consommation_route_17,
  t0.carosserie_equip AS carosserie_equip_18,
  t0.transmission_equip AS transmission_equip_19,
  t0.interieur_equip AS interieur_equip_20,
  t0.exterieur_equip AS exterieur_equip_21,
  t0.electronique_equip AS electronique_equip_22,
  t0.dispo_securite AS dispo_securite_23,
  t0.videos AS videos_24,
  t0.price AS price_25,
  t0.description AS description_26,
  t0.descriptionadd AS descriptionadd_27,
  t0.specificationtechniques AS specificationtechniques_28,
  t0.infosgenerales AS infosgenerales_29,
  t0.brochure_filename AS brochure_filename_30,
  t0.brochure_size AS brochure_size_31,
  t0.created_at AS created_at_32,
  t0.updated_at AS updated_at_33,
  t0.device AS device_34,
  t0.regions AS regions_35,
  t0.villes AS villes_36,
  t0.communes AS communes_37,
  t0.address AS address_38,
  t0.type AS type_39,
  t0.urgent AS urgent_40,
  t0.nbrcylindre AS nbrcylindre_41,
  t0.numero_enregistrement AS numero_enregistrement_42,
  t0.is_favoris AS is_favoris_43,
  t0.has_co2 AS has_co2_44,
  t0.export_price AS export_price_45,
  t0.bargan_price AS bargan_price_46,
  t0.is_active AS is_active_47,
  t0.int_moto AS int_moto_48,
  t0.electro_moto AS electro_moto_49,
  t0.disposec_moto AS disposec_moto_50,
  t0.dispconf_moto AS dispconf_moto_51,
  t0.lon AS lon_52,
  t0.lat AS lat_53,
  t0.duration AS duration_54,
  t0.comments AS comments_55,
  t0.note AS note_56,
  t0.is_compared AS is_compared_57,
  t0.user_id AS user_id_58
FROM
  annonce t0

SELECT t0.id AS id_1, t0.category AS category_2, t0.marques AS marques_3, t0.modeles AS modeles_4, t0.etats AS etats_5, t0.carosseries AS carosseries_6, t0.year AS year_7, t0.kilometrage AS kilometrage_8, t0.carburants AS carburants_9, t0.transmission AS transmission_10, t0.moteur AS moteur_11, t0.entrainement AS entrainement_12, t0.couleur_ext AS couleur_ext_13, t0.couleur_int AS couleur_int_14, t0.numero_chassis AS numero_chassis_15, t0.consommationville AS consommationville_16, t0.consommation_route AS consommation_route_17, t0.carosserie_equip AS carosserie_equip_18, t0.transmission_equip AS transmission_equip_19, t0.interieur_equip AS interieur_equip_20, t0.exterieur_equip AS exterieur_equip_21, t0.electronique_equip AS electronique_equip_22, t0.dispo_securite AS dispo_securite_23, t0.videos AS videos_24, t0.price AS price_25, t0.description AS description_26, t0.descriptionadd AS descriptionadd_27, t0.specificationtechniques AS specificationtechniques_28, t0.infosgenerales AS infosgenerales_29, t0.brochure_filename AS brochure_filename_30, t0.brochure_size AS brochure_size_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.device AS device_34, t0.regions AS regions_35, t0.villes AS villes_36, t0.communes AS communes_37, t0.address AS address_38, t0.type AS type_39, t0.urgent AS urgent_40, t0.nbrcylindre AS nbrcylindre_41, t0.numero_enregistrement AS numero_enregistrement_42, t0.is_favoris AS is_favoris_43, t0.has_co2 AS has_co2_44, t0.export_price AS export_price_45, t0.bargan_price AS bargan_price_46, t0.is_active AS is_active_47, t0.int_moto AS int_moto_48, t0.electro_moto AS electro_moto_49, t0.disposec_moto AS disposec_moto_50, t0.dispconf_moto AS dispconf_moto_51, t0.lon AS lon_52, t0.lat AS lat_53, t0.duration AS duration_54, t0.comments AS comments_55, t0.note AS note_56, t0.is_compared AS is_compared_57, t0.user_id AS user_id_58 FROM annonce t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 82)
5	App\Controller\HomeController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.21 ms
(0.62%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.username AS username_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.category AS category_6, t0.marque AS marque_7, t0.modele AS modele_8, t0.budget AS budget_9, t0.transmission AS transmission_10, t0.carburant AS carburant_11, t0.prevision AS prevision_12, t0.period1 AS period1_13, t0.period2 AS period2_14, t0.wished_options AS wished_options_15, t0.nb_portes AS nb_portes_16, t0.reference AS reference_17, t0.type_annonce AS type_annonce_18, t0.created_at AS created_at_19 FROM depot_recherche t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.username AS username_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5,
  t0.category AS category_6,
  t0.marque AS marque_7,
  t0.modele AS modele_8,
  t0.budget AS budget_9,
  t0.transmission AS transmission_10,
  t0.carburant AS carburant_11,
  t0.prevision AS prevision_12,
  t0.period1 AS period1_13,
  t0.period2 AS period2_14,
  t0.wished_options AS wished_options_15,
  t0.nb_portes AS nb_portes_16,
  t0.reference AS reference_17,
  t0.type_annonce AS type_annonce_18,
  t0.created_at AS created_at_19
FROM
  depot_recherche t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.username AS username_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.category AS category_6, t0.marque AS marque_7, t0.modele AS modele_8, t0.budget AS budget_9, t0.transmission AS transmission_10, t0.carburant AS carburant_11, t0.prevision AS prevision_12, t0.period1 AS period1_13, t0.period2 AS period2_14, t0.wished_options AS wished_options_15, t0.nb_portes AS nb_portes_16, t0.reference AS reference_17, t0.type_annonce AS type_annonce_18, t0.created_at AS created_at_19 FROM depot_recherche t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 87)
5	App\Controller\HomeController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.21 ms
(0.62%)

SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.type_compte AS type_compte_6, t1.is_verified AS is_verified_7, t1.tel AS tel_8, t1.approve AS approve_9, t1.facebook_id AS facebook_id_10, t1.is_super_admin AS is_super_admin_11, t1.facebook AS facebook_12, t1.twitter AS twitter_13, t1.instagram AS instagram_14, t1.linkedin AS linkedin_15, t1.youtube AS youtube_16, t1.whatsapp AS whatsapp_17, t1.pinterest AS pinterest_18, t1.facebook_access_token AS facebook_access_token_19, t1.twitter_id AS twitter_id_20, t1.twitter_access_token AS twitter_access_token_21, t1.google_id AS google_id_22, t1.google_access_token AS google_access_token_23, t0.logo AS logo_24, t0.nom_professionel AS nom_professionel_25, t0.addresse AS addresse_26, t0.marques AS marques_27, t0.website AS website_28, t0.image_size AS image_size_29, t0.updated_at AS updated_at_30, t0.description AS description_31, t1.compte FROM professionel t0 INNER JOIN user t1 ON t0.id = t1.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.id AS id_2,
  t1.email AS email_3,
  t1.roles AS roles_4,
  t1.password AS password_5,
  t1.type_compte AS type_compte_6,
  t1.is_verified AS is_verified_7,
  t1.tel AS tel_8,
  t1.approve AS approve_9,
  t1.facebook_id AS facebook_id_10,
  t1.is_super_admin AS is_super_admin_11,
  t1.facebook AS facebook_12,
  t1.twitter AS twitter_13,
  t1.instagram AS instagram_14,
  t1.linkedin AS linkedin_15,
  t1.youtube AS youtube_16,
  t1.whatsapp AS whatsapp_17,
  t1.pinterest AS pinterest_18,
  t1.facebook_access_token AS facebook_access_token_19,
  t1.twitter_id AS twitter_id_20,
  t1.twitter_access_token AS twitter_access_token_21,
  t1.google_id AS google_id_22,
  t1.google_access_token AS google_access_token_23,
  t0.logo AS logo_24,
  t0.nom_professionel AS nom_professionel_25,
  t0.addresse AS addresse_26,
  t0.marques AS marques_27,
  t0.website AS website_28,
  t0.image_size AS image_size_29,
  t0.updated_at AS updated_at_30,
  t0.description AS description_31,
  t1.compte
FROM
  professionel t0
  INNER JOIN user t1 ON t0.id = t1.id

SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.type_compte AS type_compte_6, t1.is_verified AS is_verified_7, t1.tel AS tel_8, t1.approve AS approve_9, t1.facebook_id AS facebook_id_10, t1.is_super_admin AS is_super_admin_11, t1.facebook AS facebook_12, t1.twitter AS twitter_13, t1.instagram AS instagram_14, t1.linkedin AS linkedin_15, t1.youtube AS youtube_16, t1.whatsapp AS whatsapp_17, t1.pinterest AS pinterest_18, t1.facebook_access_token AS facebook_access_token_19, t1.twitter_id AS twitter_id_20, t1.twitter_access_token AS twitter_access_token_21, t1.google_id AS google_id_22, t1.google_access_token AS google_access_token_23, t0.logo AS logo_24, t0.nom_professionel AS nom_professionel_25, t0.addresse AS addresse_26, t0.marques AS marques_27, t0.website AS website_28, t0.image_size AS image_size_29, t0.updated_at AS updated_at_30, t0.description AS description_31, t1.compte FROM professionel t0 INNER JOIN user t1 ON t0.id = t1.id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 86)
5	App\Controller\HomeController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.19 ms
(0.55%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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;

#	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 80)
7	App\Repository\PubInfosRepository->findByPubLatest (line 16)
8	App\Service\PubsService->getPubs (line 88)
9	App\Controller\HomeController->index (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	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\Article	The association App\Entity\Article#professionel refers to the inverse side field App\Entity\Professionel#articles which does not exist.
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\Admin	The association App\Entity\Admin#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\Comment	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	No errors.
App\Entity\Annonce	No errors.
App\Entity\Picture	No errors.
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\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\Annuaire	No errors.
App\Entity\Vitrine	No errors.
App\Entity\Contact	No errors.
App\Entity\Portrait	No errors.
App\Entity\DepotRecherche	No errors.
App\Entity\PubInfos	No errors.
App\Entity\Pub	No errors.
App\Entity\Commenter	No errors.

Symfony Profiler

GET https://topautosntest.sn-topauto.com/en/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping