Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

6.04 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲

Time

Info

4.37 ms

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.title AS title_3, t0.mots_cles AS mots_cles_4, t0.keyword AS keyword_5, t0.description AS description_6, t0.property_description AS property_description_7, t0.reference AS reference_8, t0.prix AS prix_9, t0.prix_visible AS prix_visible_10, t0.titre_vendu AS titre_vendu_11, t0.title_vendu AS title_vendu_12, t0.created_at AS created_at_13, t0.titre_text AS titre_text_14, t0.title_text AS title_text_15, t0.excellence AS excellence_16, t0.new_date AS new_date_17, t0.slug AS slug_18, t0.slug_en AS slug_en_19, t0.status_id AS status_id_20 FROM annonce t0 ORDER BY t0.prix DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.title AS title_3,
  t0.mots_cles AS mots_cles_4,
  t0.keyword AS keyword_5,
  t0.description AS description_6,
  t0.property_description AS property_description_7,
  t0.reference AS reference_8,
  t0.prix AS prix_9,
  t0.prix_visible AS prix_visible_10,
  t0.titre_vendu AS titre_vendu_11,
  t0.title_vendu AS title_vendu_12,
  t0.created_at AS created_at_13,
  t0.titre_text AS titre_text_14,
  t0.title_text AS title_text_15,
  t0.excellence AS excellence_16,
  t0.new_date AS new_date_17,
  t0.slug AS slug_18,
  t0.slug_en AS slug_en_19,
  t0.status_id AS status_id_20
FROM
  annonce t0
ORDER BY
  t0.prix DESC

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.title AS title_3, t0.mots_cles AS mots_cles_4, t0.keyword AS keyword_5, t0.description AS description_6, t0.property_description AS property_description_7, t0.reference AS reference_8, t0.prix AS prix_9, t0.prix_visible AS prix_visible_10, t0.titre_vendu AS titre_vendu_11, t0.title_vendu AS title_vendu_12, t0.created_at AS created_at_13, t0.titre_text AS titre_text_14, t0.title_text AS title_text_15, t0.excellence AS excellence_16, t0.new_date AS new_date_17, t0.slug AS slug_18, t0.slug_en AS slug_en_19, t0.status_id AS status_id_20 FROM annonce t0 ORDER BY t0.prix DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 21)
5	App\Controller\AccueilController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.03 ms

SELECT p0_.id AS id_0, p0_.image_name AS image_name_1, p0_.order_index AS order_index_2, p0_.annonce_id AS annonce_id_3 FROM photos p0_ WHERE p0_.order_index = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.image_name AS image_name_1,
  p0_.order_index AS order_index_2,
  p0_.annonce_id AS annonce_id_3
FROM
  photos p0_
WHERE
  p0_.order_index = 0

SELECT p0_.id AS id_0, p0_.image_name AS image_name_1, p0_.order_index AS order_index_2, p0_.annonce_id AS annonce_id_3 FROM photos p0_ WHERE p0_.order_index = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 29)
7	App\Repository\PhotoRepository->findFirstPhotosByAnnonces (line 22)
8	App\Controller\AccueilController->index (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.63 ms

SELECT t0.id AS id_1, t0.a AS a_2, t0.b AS b_3, t0.c AS c_4, t0.d AS d_5, t0.e AS e_6, t0.f AS f_7, t0.g AS g_8, t0.h AS h_9, t0.i AS i_10, t0.j AS j_11, t0.k AS k_12, t0.l AS l_13, t0.m AS m_14, t0.n AS n_15, t0.o AS o_16, t0.p AS p_17, t0.q AS q_18, t0.r AS r_19, t0.s AS s_20, t0.t AS t_21, t0.u AS u_22, t0.v AS v_23, t0.w AS w_24, t0.x AS x_25, t0.y AS y_26, t0.z AS z_27, t0.aa AS aa_28, t0.bb AS bb_29, t0.cc AS cc_30, t0.dd AS dd_31, t0.ee AS ee_32, t0.ff AS ff_33, t0.gg AS gg_34, t0.hh AS hh_35, t0.ii AS ii_36, t0.jj AS jj_37 FROM damier t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.a AS a_2,
  t0.b AS b_3,
  t0.c AS c_4,
  t0.d AS d_5,
  t0.e AS e_6,
  t0.f AS f_7,
  t0.g AS g_8,
  t0.h AS h_9,
  t0.i AS i_10,
  t0.j AS j_11,
  t0.k AS k_12,
  t0.l AS l_13,
  t0.m AS m_14,
  t0.n AS n_15,
  t0.o AS o_16,
  t0.p AS p_17,
  t0.q AS q_18,
  t0.r AS r_19,
  t0.s AS s_20,
  t0.t AS t_21,
  t0.u AS u_22,
  t0.v AS v_23,
  t0.w AS w_24,
  t0.x AS x_25,
  t0.y AS y_26,
  t0.z AS z_27,
  t0.aa AS aa_28,
  t0.bb AS bb_29,
  t0.cc AS cc_30,
  t0.dd AS dd_31,
  t0.ee AS ee_32,
  t0.ff AS ff_33,
  t0.gg AS gg_34,
  t0.hh AS hh_35,
  t0.ii AS ii_36,
  t0.jj AS jj_37
FROM
  damier t0

SELECT t0.id AS id_1, t0.a AS a_2, t0.b AS b_3, t0.c AS c_4, t0.d AS d_5, t0.e AS e_6, t0.f AS f_7, t0.g AS g_8, t0.h AS h_9, t0.i AS i_10, t0.j AS j_11, t0.k AS k_12, t0.l AS l_13, t0.m AS m_14, t0.n AS n_15, t0.o AS o_16, t0.p AS p_17, t0.q AS q_18, t0.r AS r_19, t0.s AS s_20, t0.t AS t_21, t0.u AS u_22, t0.v AS v_23, t0.w AS w_24, t0.x AS x_25, t0.y AS y_26, t0.z AS z_27, t0.aa AS aa_28, t0.bb AS bb_29, t0.cc AS cc_30, t0.dd AS dd_31, t0.ee AS ee_32, t0.ff AS ff_33, t0.gg AS gg_34, t0.hh AS hh_35, t0.ii AS ii_36, t0.jj AS jj_37 FROM damier t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 27)
6	App\Controller\AccueilController->index (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	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	The mappings App\Entity\Annonce#contacts and App\Entity\Contact#annonces are inconsistent with each other.
App\Entity\Status	No errors.
App\Entity\Photo	No errors.
App\Entity\Contact	The association App\Entity\Contact#annonces refers to the inverse side field App\Entity\Annonce#contact which does not exist.
App\Entity\Damier	No errors.

Symfony Profiler

POST https://wattine-immobilier.com/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping