Symfony Profiler

Query Metrics

9 Database Queries

9 Different statements

8.51 ms Query time

1 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.65 ms
(78.13%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\AuditLogger->logAndFlush (line 72)
4	App\EventSubscriber\SecurityAuditSubscriber->onLoginSuccess (line 34)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 250)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 230)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
13	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
14	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
15	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
16	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
17	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

0.39 ms
(4.53%)

INSERT INTO audit_log (user_email, action, entity_type, entity_id, description, data_before, data_after, ip_address, user_agent, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "abdelhak.hamdouni@cat-secteurprive.fr"
  "LOGIN_SUCCESS"
  null
  null
  "Connexion réussie"
  null
  null
  "93.2.212.82"
  "okhttp/4.12.0"
  "2026-06-15 13:34:24"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO audit_log (
  user_email, action, entity_type, entity_id,
  description, data_before, data_after,
  ip_address, user_agent, created_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO audit_log (user_email, action, entity_type, entity_id, description, data_before, data_after, ip_address, user_agent, created_at) VALUES ('abdelhak.hamdouni@cat-secteurprive.fr', 'LOGIN_SUCCESS', NULL, NULL, 'Connexion réussie', NULL, NULL, '93.2.212.82', 'okhttp/4.12.0', '2026-06-15 13:34:24');

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\AuditLogger->logAndFlush (line 72)
7	App\EventSubscriber\SecurityAuditSubscriber->onLoginSuccess (line 34)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 250)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 230)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
16	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
17	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
18	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

0.28 ms
(3.34%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.piece_identite AS piece_identite_8, t0.is_adherent AS is_adherent_9, t0.identifiant AS identifiant_10, t0.is_prof AS is_prof_11, t0.is_active AS is_active_12, t0.email_auth_code AS email_auth_code_13, t0.email_auth_enabled AS email_auth_enabled_14, t0.reset_token AS reset_token_15, t0.reset_token_expires_at AS reset_token_expires_at_16, t0.address_id AS address_id_17 FROM `user` t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "abdelhak.hamdouni@cat-secteurprive.fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.mobile AS mobile_7,
  t0.piece_identite AS piece_identite_8,
  t0.is_adherent AS is_adherent_9,
  t0.identifiant AS identifiant_10,
  t0.is_prof AS is_prof_11,
  t0.is_active AS is_active_12,
  t0.email_auth_code AS email_auth_code_13,
  t0.email_auth_enabled AS email_auth_enabled_14,
  t0.reset_token AS reset_token_15,
  t0.reset_token_expires_at AS reset_token_expires_at_16,
  t0.address_id AS address_id_17
FROM
  `user` t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.piece_identite AS piece_identite_8, t0.is_adherent AS is_adherent_9, t0.identifiant AS identifiant_10, t0.is_prof AS is_prof_11, t0.is_active AS is_active_12, t0.email_auth_code AS email_auth_code_13, t0.email_auth_enabled AS email_auth_enabled_14, t0.reset_token AS reset_token_15, t0.reset_token_expires_at AS reset_token_expires_at_16, t0.address_id AS address_id_17 FROM `user` t0 WHERE t0.email = 'abdelhak.hamdouni@cat-secteurprive.fr' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 57)
5	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 208)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 105)
7	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 97)
8	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
9	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 189)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

0.24 ms
(2.86%)

SELECT t0.id AS id_1, t0.annee AS annee_2, t0.type AS type_3, t0.identifiant AS identifiant_4, t0.cursus AS cursus_5, t0.avec_science AS avec_science_6, t0.fiche_sanitaire AS fiche_sanitaire_7, t0.fiche_sanitaire_at AS fiche_sanitaire_at_8, t0.montant_total AS montant_total_9, t0.montant_inscription AS montant_inscription_10, t0.paiement_exempte AS paiement_exempte_11, t0.motif_exemption_paiement AS motif_exemption_paiement_12, t0.eleve_id AS eleve_id_13, t0.author_id AS author_id_14, t0.tarif_id AS tarif_id_15 FROM inscription t0 WHERE t0.eleve_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.annee AS annee_2,
  t0.type AS type_3,
  t0.identifiant AS identifiant_4,
  t0.cursus AS cursus_5,
  t0.avec_science AS avec_science_6,
  t0.fiche_sanitaire AS fiche_sanitaire_7,
  t0.fiche_sanitaire_at AS fiche_sanitaire_at_8,
  t0.montant_total AS montant_total_9,
  t0.montant_inscription AS montant_inscription_10,
  t0.paiement_exempte AS paiement_exempte_11,
  t0.motif_exemption_paiement AS motif_exemption_paiement_12,
  t0.eleve_id AS eleve_id_13,
  t0.author_id AS author_id_14,
  t0.tarif_id AS tarif_id_15
FROM
  inscription t0
WHERE
  t0.eleve_id = ?

SELECT t0.id AS id_1, t0.annee AS annee_2, t0.type AS type_3, t0.identifiant AS identifiant_4, t0.cursus AS cursus_5, t0.avec_science AS avec_science_6, t0.fiche_sanitaire AS fiche_sanitaire_7, t0.fiche_sanitaire_at AS fiche_sanitaire_at_8, t0.montant_total AS montant_total_9, t0.montant_inscription AS montant_inscription_10, t0.paiement_exempte AS paiement_exempte_11, t0.motif_exemption_paiement AS motif_exemption_paiement_12, t0.eleve_id AS eleve_id_13, t0.author_id AS author_id_14, t0.tarif_id AS tarif_id_15 FROM inscription t0 WHERE t0.eleve_id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Controller\Api\Mobile\MobileParentController->activeRegistration (line 185)
8	App\Controller\Api\Mobile\MobileParentController->serializeChild (line 160)
9	App\Controller\Api\Mobile\MobileParentController->serializeChildDetail (line 177)
10	App\Controller\Api\Mobile\MobileParentController->childShow (line 109)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

0.23 ms
(2.70%)

SELECT e0_.id AS id_0, e0_.first_name AS first_name_1, e0_.last_name AS last_name_2, e0_.birthday AS birthday_3, e0_.birth_city AS birth_city_4, e0_.is_arabo_phone AS is_arabo_phone_5, e0_.is_dificult AS is_dificult_6, e0_.observation AS observation_7, e0_.created_at AS created_at_8, e0_.pere_id AS pere_id_9, e0_.mere_id AS mere_id_10, e0_.tuteur_id AS tuteur_id_11, e0_.created_by_id AS created_by_id_12 FROM eleve e0_ WHERE e0_.pere_id = ? OR e0_.mere_id = ? OR e0_.tuteur_id = ? ORDER BY e0_.last_name ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.first_name AS first_name_1,
  e0_.last_name AS last_name_2,
  e0_.birthday AS birthday_3,
  e0_.birth_city AS birth_city_4,
  e0_.is_arabo_phone AS is_arabo_phone_5,
  e0_.is_dificult AS is_dificult_6,
  e0_.observation AS observation_7,
  e0_.created_at AS created_at_8,
  e0_.pere_id AS pere_id_9,
  e0_.mere_id AS mere_id_10,
  e0_.tuteur_id AS tuteur_id_11,
  e0_.created_by_id AS created_by_id_12
FROM
  eleve e0_
WHERE
  e0_.pere_id = ?
  OR e0_.mere_id = ?
  OR e0_.tuteur_id = ?
ORDER BY
  e0_.last_name ASC

SELECT e0_.id AS id_0, e0_.first_name AS first_name_1, e0_.last_name AS last_name_2, e0_.birthday AS birthday_3, e0_.birth_city AS birth_city_4, e0_.is_arabo_phone AS is_arabo_phone_5, e0_.is_dificult AS is_dificult_6, e0_.observation AS observation_7, e0_.created_at AS created_at_8, e0_.pere_id AS pere_id_9, e0_.mere_id AS mere_id_10, e0_.tuteur_id AS tuteur_id_11, e0_.created_by_id AS created_by_id_12 FROM eleve e0_ WHERE e0_.pere_id = 1 OR e0_.mere_id = 1 OR e0_.tuteur_id = 1 ORDER BY e0_.last_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\Controller\Api\Mobile\MobileParentController->parentChildren (line 85)
7	App\Controller\Api\Mobile\MobileParentController->findParentChild (line 90)
8	App\Controller\Api\Mobile\MobileParentController->childShow (line 107)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.21 ms
(2.47%)

SELECT t0.id AS id_1, t0.absence_at AS absence_at_2, t0.is_resolved AS is_resolved_3, t0.eleve_id AS eleve_id_4, t0.resolved_by_id AS resolved_by_id_5, t0.prof_id AS prof_id_6 FROM absence t0 WHERE t0.eleve_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.absence_at AS absence_at_2,
  t0.is_resolved AS is_resolved_3,
  t0.eleve_id AS eleve_id_4,
  t0.resolved_by_id AS resolved_by_id_5,
  t0.prof_id AS prof_id_6
FROM
  absence t0
WHERE
  t0.eleve_id = ?

SELECT t0.id AS id_1, t0.absence_at AS absence_at_2, t0.is_resolved AS is_resolved_3, t0.eleve_id AS eleve_id_4, t0.resolved_by_id AS resolved_by_id_5, t0.prof_id AS prof_id_6 FROM absence t0 WHERE t0.eleve_id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	count (line 171)
9	App\Controller\Api\Mobile\MobileParentController::serializeChild (line 171)
10	App\Controller\Api\Mobile\MobileParentController->serializeChildDetail (line 177)
11	App\Controller\Api\Mobile\MobileParentController->childShow (line 109)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 5)

0.21 ms
(2.43%)

SELECT t0.id AS id_1, t0.montant AS montant_2, t0.mode AS mode_3, t0.statut AS statut_4, t0.date_paiement AS date_paiement_5, t0.reference AS reference_6, t0.note AS note_7, t0.created_at AS created_at_8, t0.inscription_id AS inscription_id_9, t0.created_by_id AS created_by_id_10 FROM paiement t0 WHERE t0.inscription_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.montant AS montant_2,
  t0.mode AS mode_3,
  t0.statut AS statut_4,
  t0.date_paiement AS date_paiement_5,
  t0.reference AS reference_6,
  t0.note AS note_7,
  t0.created_at AS created_at_8,
  t0.inscription_id AS inscription_id_9,
  t0.created_by_id AS created_by_id_10
FROM
  paiement t0
WHERE
  t0.inscription_id = ?

SELECT t0.id AS id_1, t0.montant AS montant_2, t0.mode AS mode_3, t0.statut AS statut_4, t0.date_paiement AS date_paiement_5, t0.reference AS reference_6, t0.note AS note_7, t0.created_at AS created_at_8, t0.inscription_id AS inscription_id_9, t0.created_by_id AS created_by_id_10 FROM paiement t0 WHERE t0.inscription_id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\Inscription->getMontantEncaisse (line 229)
8	App\Controller\Api\Mobile\MobileParentController->serializeRegistration (line 204)
9	App\Controller\Api\Mobile\MobileParentController->serializeChild (line 169)
10	App\Controller\Api\Mobile\MobileParentController->serializeChildDetail (line 177)
11	App\Controller\Api\Mobile\MobileParentController->childShow (line 109)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 5)

0.16 ms
(1.89%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.jour AS jour_3, t0.horaire AS horaire_4, t0.description AS description_5 FROM classe t0 INNER JOIN classe_eleve ON t0.id = classe_eleve.classe_id WHERE classe_eleve.eleve_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.jour AS jour_3,
  t0.horaire AS horaire_4,
  t0.description AS description_5
FROM
  classe t0
  INNER JOIN classe_eleve ON t0.id = classe_eleve.classe_id
WHERE
  classe_eleve.eleve_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.jour AS jour_3, t0.horaire AS horaire_4, t0.description AS description_5 FROM classe t0 INNER JOIN classe_eleve ON t0.id = classe_eleve.classe_id WHERE classe_eleve.eleve_id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->first (line 169)
7	Doctrine\ORM\PersistentCollection->first (line 518)
8	App\Controller\Api\Mobile\MobileParentController->serializeChild (line 170)
9	App\Controller\Api\Mobile\MobileParentController->serializeChildDetail (line 177)
10	App\Controller\Api\Mobile\MobileParentController->childShow (line 109)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

0.14 ms
(1.66%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\AuditLogger->logAndFlush (line 72)
4	App\EventSubscriber\SecurityAuditSubscriber->onLoginSuccess (line 34)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 250)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 230)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
13	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
14	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
15	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
16	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
17	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	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
App\Entity\Eleve	2
App\Entity\User	1
App\Entity\AuditLog	1
App\Entity\Inscription	1
App\Entity\Tarif	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Address	No errors.
App\Entity\Eleve	The mappings App\Entity\Eleve#mere and App\Entity\User#eleves are inconsistent with each other. The mappings App\Entity\Eleve#tuteur and App\Entity\User#eleves are inconsistent with each other.
App\Entity\Inscription	No errors.
App\Entity\Absence	No errors.
App\Entity\FileManager	No errors.
App\Entity\Cotisation	No errors.
App\Entity\StripeTransaction	No errors.
App\Entity\AuditLog	No errors.
App\Entity\Classe	No errors.
App\Entity\NiveauScolaire	No errors.
App\Entity\Tarif	No errors.
App\Entity\Paiement	No errors.
App\Entity\Prof	No errors.

Symfony Profiler

GET https://assalam-orleans.fr/api/mobile/parent/children/4

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping