Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.89 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.89 ms
(100.00%)

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.slug AS slug_2, f0_.created_at AS created_at_3 FROM filiere f0_ LEFT JOIN users u1_ ON (u1_.filiere_id = f0_.id) WHERE u1_.id IS NULL ORDER BY f0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.slug AS slug_2,
  f0_.created_at AS created_at_3
FROM
  filiere f0_
  LEFT JOIN users u1_ ON (u1_.filiere_id = f0_.id)
WHERE
  u1_.id IS NULL
ORDER BY
  f0_.name ASC

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.slug AS slug_2, f0_.created_at AS created_at_3 FROM filiere f0_ LEFT JOIN users u1_ ON (u1_.filiere_id = f0_.id) WHERE u1_.id IS NULL ORDER BY f0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\IdentityAccess\Infrastructure\Doctrine\UserDoctrineRepository->listAvailableFilieresForUser (line 128)
7	App\Admin\Infrastructure\Http\AdminUserController->new (line 56)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
12	frankenphp_handle_request (line 45)
13	Runtime\FrankenPhpSymfony\Runner::run (line 45)
14	require_once (line 29)
15	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.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

Class	Mapping errors
App\IdentityAccess\Domain\Model\User	No errors.
App\Shared\Domain\Model\Filiere	No errors.

Symfony Profiler

GET https://mercure.terrenourriciere.org/admin/users/new

Configuration Settings

Theme

Page Width