Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

13.08 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.25 ms
(40.15%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1420)
2	Doctrine\DBAL\Connection->commit (line 472)
3	Doctrine\ORM\UnitOfWork->commit (line 403)
4	Doctrine\ORM\EntityManager->flush (line 37)
5	App\Controller\SecurityController->login (line 166)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
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)

1.94 ms
(14.86%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.gestion_web AS gestion_web_3, t0.type AS type_4, t0.name AS name_5, t0.bank AS bank_6, t0.director AS director_7, t0.phone_director AS phone_director_8, t0.email AS email_9, t0.phone AS phone_10, t0.address AS address_11, t0.city AS city_12, t0.cp AS cp_13, t0.siret AS siret_14, t0.tva AS tva_15, t0.ape AS ape_16, t0.website AS website_17, t0.created AS created_18, t0.fax AS fax_19, t0.rib AS rib_20, t0.logo AS logo_21, t0.sender_mail AS sender_mail_22, t0.sender_name AS sender_name_23, t0.logo_facture AS logo_facture_24, t0.gestion_lot_chantier AS gestion_lot_chantier_25, t0.indemnite_trajet_zone1 AS indemnite_trajet_zone1_26, t0.idemnite_repas AS idemnite_repas_27, t0.signature AS signature_28, t0.gestion_articles AS gestion_articles_29, t0.gestion_chantiers AS gestion_chantiers_30, t0.tva_applicable AS tva_applicable_31, t0.entreprise_type AS entreprise_type_32, t0.cloud_folder AS cloud_folder_33, t0.facturation_keobat AS facturation_keobat_34, t0.numerotation_facture AS numerotation_facture_35, t0.type_document AS type_document_36, t0.months AS months_37, t0.sign_elect AS sign_elect_38, t0.lng AS lng_39, t0.lat AS lat_40 FROM entreprise t0 INNER JOIN entreprise_admin ON t0.id = entreprise_admin.entreprise_id WHERE entreprise_admin.admin_id = ?

Parameters:

[
  1253
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.gestion_web AS gestion_web_3,
  t0.type AS type_4,
  t0.name AS name_5,
  t0.bank AS bank_6,
  t0.director AS director_7,
  t0.phone_director AS phone_director_8,
  t0.email AS email_9,
  t0.phone AS phone_10,
  t0.address AS address_11,
  t0.city AS city_12,
  t0.cp AS cp_13,
  t0.siret AS siret_14,
  t0.tva AS tva_15,
  t0.ape AS ape_16,
  t0.website AS website_17,
  t0.created AS created_18,
  t0.fax AS fax_19,
  t0.rib AS rib_20,
  t0.logo AS logo_21,
  t0.sender_mail AS sender_mail_22,
  t0.sender_name AS sender_name_23,
  t0.logo_facture AS logo_facture_24,
  t0.gestion_lot_chantier AS gestion_lot_chantier_25,
  t0.indemnite_trajet_zone1 AS indemnite_trajet_zone1_26,
  t0.idemnite_repas AS idemnite_repas_27,
  t0.signature AS signature_28,
  t0.gestion_articles AS gestion_articles_29,
  t0.gestion_chantiers AS gestion_chantiers_30,
  t0.tva_applicable AS tva_applicable_31,
  t0.entreprise_type AS entreprise_type_32,
  t0.cloud_folder AS cloud_folder_33,
  t0.facturation_keobat AS facturation_keobat_34,
  t0.numerotation_facture AS numerotation_facture_35,
  t0.type_document AS type_document_36,
  t0.months AS months_37,
  t0.sign_elect AS sign_elect_38,
  t0.lng AS lng_39,
  t0.lat AS lat_40
FROM
  entreprise t0
  INNER JOIN entreprise_admin ON t0.id = entreprise_admin.entreprise_id
WHERE
  entreprise_admin.admin_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.gestion_web AS gestion_web_3, t0.type AS type_4, t0.name AS name_5, t0.bank AS bank_6, t0.director AS director_7, t0.phone_director AS phone_director_8, t0.email AS email_9, t0.phone AS phone_10, t0.address AS address_11, t0.city AS city_12, t0.cp AS cp_13, t0.siret AS siret_14, t0.tva AS tva_15, t0.ape AS ape_16, t0.website AS website_17, t0.created AS created_18, t0.fax AS fax_19, t0.rib AS rib_20, t0.logo AS logo_21, t0.sender_mail AS sender_mail_22, t0.sender_name AS sender_name_23, t0.logo_facture AS logo_facture_24, t0.gestion_lot_chantier AS gestion_lot_chantier_25, t0.indemnite_trajet_zone1 AS indemnite_trajet_zone1_26, t0.idemnite_repas AS idemnite_repas_27, t0.signature AS signature_28, t0.gestion_articles AS gestion_articles_29, t0.gestion_chantiers AS gestion_chantiers_30, t0.tva_applicable AS tva_applicable_31, t0.entreprise_type AS entreprise_type_32, t0.cloud_folder AS cloud_folder_33, t0.facturation_keobat AS facturation_keobat_34, t0.numerotation_facture AS numerotation_facture_35, t0.type_document AS type_document_36, t0.months AS months_37, t0.sign_elect AS sign_elect_38, t0.lng AS lng_39, t0.lat AS lat_40 FROM entreprise t0 INNER JOIN entreprise_admin ON t0.id = entreprise_admin.entreprise_id WHERE entreprise_admin.admin_id = 1253;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3144)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 267)
7	Doctrine\Common\Collections\AbstractLazyCollection->map (line 140)
8	App\Service\Firebase\Entities\FirebaseAdminSyncService->hydrateAdminForFirebase (line 58)
9	App\Service\Firebase\Entities\FirebaseAdminSyncService->updateDataToFirebase (line 37)
10	App\EventListener\EntityListener\AdminListener->postUpdate (line 93)
11	Doctrine\ORM\Event\ListenersInvoker->invoke (line 1263)
12	Doctrine\ORM\UnitOfWork->executeUpdates (line 448)
13	Doctrine\ORM\UnitOfWork->commit (line 403)
14	Doctrine\ORM\EntityManager->flush (line 37)
15	App\Controller\SecurityController->login (line 166)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

1.76 ms
(13.46%)

SELECT t0.uid AS uid_1, t0.civ AS civ_2, t0.lastname AS lastname_3, t0.firstname AS firstname_4, t0.email AS email_5, t0.phone AS phone_6, t0.password AS password_7, t0.numero AS numero_8, t0.address AS address_9, t0.city AS city_10, t0.cp AS cp_11, t0.dep AS dep_12, t0.region AS region_13, t0.website AS website_14, t0.categoryuser AS categoryuser_15, t0.created AS created_16, t0.lastlogin AS lastlogin_17, t0.status AS status_18, t0.admin AS admin_19, t0.token AS token_20, t0.verif AS verif_21, t0.notif AS notif_22, t0.role AS role_23, t0.resetting AS resetting_24, t0.super_admin AS super_admin_25, t0.ip_list AS ip_list_26, t0.all_ip AS all_ip_27, t0.photo AS photo_28, t0.nombre_photo_galerie AS nombre_photo_galerie_29, t0.entreprise_id AS entreprise_id_30 FROM admin t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "elshaseries@keodev.fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.uid AS uid_1,
  t0.civ AS civ_2,
  t0.lastname AS lastname_3,
  t0.firstname AS firstname_4,
  t0.email AS email_5,
  t0.phone AS phone_6,
  t0.password AS password_7,
  t0.numero AS numero_8,
  t0.address AS address_9,
  t0.city AS city_10,
  t0.cp AS cp_11,
  t0.dep AS dep_12,
  t0.region AS region_13,
  t0.website AS website_14,
  t0.categoryuser AS categoryuser_15,
  t0.created AS created_16,
  t0.lastlogin AS lastlogin_17,
  t0.status AS status_18,
  t0.admin AS admin_19,
  t0.token AS token_20,
  t0.verif AS verif_21,
  t0.notif AS notif_22,
  t0.role AS role_23,
  t0.resetting AS resetting_24,
  t0.super_admin AS super_admin_25,
  t0.ip_list AS ip_list_26,
  t0.all_ip AS all_ip_27,
  t0.photo AS photo_28,
  t0.nombre_photo_galerie AS nombre_photo_galerie_29,
  t0.entreprise_id AS entreprise_id_30
FROM
  admin t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.uid AS uid_1, t0.civ AS civ_2, t0.lastname AS lastname_3, t0.firstname AS firstname_4, t0.email AS email_5, t0.phone AS phone_6, t0.password AS password_7, t0.numero AS numero_8, t0.address AS address_9, t0.city AS city_10, t0.cp AS cp_11, t0.dep AS dep_12, t0.region AS region_13, t0.website AS website_14, t0.categoryuser AS categoryuser_15, t0.created AS created_16, t0.lastlogin AS lastlogin_17, t0.status AS status_18, t0.admin AS admin_19, t0.token AS token_20, t0.verif AS verif_21, t0.notif AS notif_22, t0.role AS role_23, t0.resetting AS resetting_24, t0.super_admin AS super_admin_25, t0.ip_list AS ip_list_26, t0.all_ip AS all_ip_27, t0.photo AS photo_28, t0.nombre_photo_galerie AS nombre_photo_galerie_29, t0.entreprise_id AS entreprise_id_30 FROM admin t0 WHERE t0.email = 'elshaseries@keodev.fr' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 35)
4	App\Controller\SecurityController->login (line 166)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
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)

1.50 ms
(11.44%)

UPDATE admin SET password = ? WHERE uid = ?

Parameters:

[
  "$2y$13$lVB7dq8lhBRD6RDLYN7gJ.Z7y1q/pzAQLfU4Q4T7CM1bY3kXT4z8a"
  1253
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  admin
SET
  password = ?
WHERE
  uid = ?

UPDATE admin SET password = '$2y$13$lVB7dq8lhBRD6RDLYN7gJ.Z7y1q/pzAQLfU4Q4T7CM1bY3kXT4z8a' WHERE uid = 1253;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 528)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 414)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1257)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 448)
5	Doctrine\ORM\UnitOfWork->commit (line 403)
6	Doctrine\ORM\EntityManager->flush (line 37)
7	App\Controller\SecurityController->login (line 166)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.42 ms
(10.85%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.lien AS lien_3, t0.menu_id AS menu_id_4 FROM page_controle t0 INNER JOIN admin_page_controle ON t0.id = admin_page_controle.page_id WHERE admin_page_controle.admin_id = ?

Parameters:

[
  1253
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.lien AS lien_3,
  t0.menu_id AS menu_id_4
FROM
  page_controle t0
  INNER JOIN admin_page_controle ON t0.id = admin_page_controle.page_id
WHERE
  admin_page_controle.admin_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.lien AS lien_3, t0.menu_id AS menu_id_4 FROM page_controle t0 INNER JOIN admin_page_controle ON t0.id = admin_page_controle.page_id WHERE admin_page_controle.admin_id = 1253;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3144)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 267)
7	Doctrine\Common\Collections\AbstractLazyCollection->map (line 145)
8	App\Service\Firebase\Entities\FirebaseAdminSyncService->hydrateAdminForFirebase (line 58)
9	App\Service\Firebase\Entities\FirebaseAdminSyncService->updateDataToFirebase (line 37)
10	App\EventListener\EntityListener\AdminListener->postUpdate (line 93)
11	Doctrine\ORM\Event\ListenersInvoker->invoke (line 1263)
12	Doctrine\ORM\UnitOfWork->executeUpdates (line 448)
13	Doctrine\ORM\UnitOfWork->commit (line 403)
14	Doctrine\ORM\EntityManager->flush (line 37)
15	App\Controller\SecurityController->login (line 166)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

1.21 ms
(9.23%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 424)
2	Doctrine\ORM\UnitOfWork->commit (line 403)
3	Doctrine\ORM\EntityManager->flush (line 37)
4	App\Controller\SecurityController->login (line 166)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
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)

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\Admin	The field App\Entity\Admin#entreprises is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Entreprise#admins does not contain the required 'inversedBy="entreprises"' attribute. The association App\Entity\Admin#entreprise refers to the inverse side field App\Entity\Entreprise#directeurs which does not exist.
App\Entity\Entreprise	No errors.
App\Entity\PageControle	The field App\Entity\PageControle#admins is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Admin#pages does not contain the required 'inversedBy="admins"' attribute.
App\Entity\Menu	The field App\Entity\Menu#entreprises is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Entreprise#menus does not contain the required 'inversedBy="entreprises"' attribute. The mappings App\Entity\Menu#boutons and App\Entity\Bouton#menu are inconsistent with each other.

Symfony Profiler

GET http://51.91.254.174/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping