Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.97 ms Query time

4 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.75 ms

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.type_mine AS type_mine_2, p0_.type_projet AS type_projet_3, p0_.date_projet AS date_projet_4, p0_.code AS code_5, p0_.stade_projet AS stade_projet_6, p0_.classification AS classification_7, p0_.categorie AS categorie_8, p0_.id_dw AS id_dw_9, p0_.is_publish AS is_publish_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.deleted_at AS deleted_at_13, p0_.contrat_principal_id AS contrat_principal_id_14, p0_.contrat_relatif_id AS contrat_relatif_id_15, p0_.user_id AS user_id_16 FROM projet p0_ WHERE p0_.is_publish = 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_.type_mine AS type_mine_2,
  p0_.type_projet AS type_projet_3,
  p0_.date_projet AS date_projet_4,
  p0_.code AS code_5,
  p0_.stade_projet AS stade_projet_6,
  p0_.classification AS classification_7,
  p0_.categorie AS categorie_8,
  p0_.id_dw AS id_dw_9,
  p0_.is_publish AS is_publish_10,
  p0_.created_at AS created_at_11,
  p0_.updated_at AS updated_at_12,
  p0_.deleted_at AS deleted_at_13,
  p0_.contrat_principal_id AS contrat_principal_id_14,
  p0_.contrat_relatif_id AS contrat_relatif_id_15,
  p0_.user_id AS user_id_16
FROM
  projet p0_
WHERE
  p0_.is_publish = 1

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.type_mine AS type_mine_2, p0_.type_projet AS type_projet_3, p0_.date_projet AS date_projet_4, p0_.code AS code_5, p0_.stade_projet AS stade_projet_6, p0_.classification AS classification_7, p0_.categorie AS categorie_8, p0_.id_dw AS id_dw_9, p0_.is_publish AS is_publish_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.deleted_at AS deleted_at_13, p0_.contrat_principal_id AS contrat_principal_id_14, p0_.contrat_relatif_id AS contrat_relatif_id_15, p0_.user_id AS user_id_16 FROM projet p0_ WHERE p0_.is_publish = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 29)
7	App\Repository\Activite\ProjetRepository->getProjets (line 40)
8	App\Controller\Activite\ProjetController->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.22 ms

SELECT COUNT(DISTINCT p0_.id) AS sclr_0, p0_.stade_projet AS stade_projet_1 FROM projet p0_ WHERE p0_.is_publish = 1 GROUP BY p0_.stade_projet

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0,
  p0_.stade_projet AS stade_projet_1
FROM
  projet p0_
WHERE
  p0_.is_publish = 1
GROUP BY
  p0_.stade_projet

SELECT COUNT(DISTINCT p0_.id) AS sclr_0, p0_.stade_projet AS stade_projet_1 FROM projet p0_ WHERE p0_.is_publish = 1 GROUP BY p0_.stade_projet;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 103)
7	App\Repository\Activite\ProjetRepository->getTab (line 45)
8	App\Controller\Activite\ProjetController->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)

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\Activite\Projet	The field App\Entity\Activite\Projet#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Activite\Projet#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\ContratPrincipal	The field App\Entity\Transparence\ContratPrincipal#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Transparence\ContratPrincipal#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\ContratRelatif	The field App\Entity\Transparence\ContratRelatif#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Transparence\ContratRelatif#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\User	The field App\Entity\User#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\User#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.

Symfony Profiler

GET https://sokimo.ht2techinfo.cd/activite/projet

Configuration Settings

Theme