Symfony Profiler

Query Metrics

34 Database Queries

22 Different statements

17.99 ms Query time

13 Invalid entities

75 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.97 ms
(27.62%)

SELECT s0_.module AS module_0 FROM subscription_module s0_ WHERE s0_.societe_id = ? AND s0_.active = 1

Parameters:

[
  23
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.module AS module_0
FROM
  subscription_module s0_
WHERE
  s0_.societe_id = ?
  AND s0_.active = 1

SELECT s0_.module AS module_0 FROM subscription_module s0_ WHERE s0_.societe_id = 23 AND s0_.active = 1;

#	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->getScalarResult (line 724)
6	App\Bundle\AdminBundle\Repository\SubscriptionModuleRepository->findActiveModulesForSociete (line 28)
7	App\Service\BundleManager->hasModule (line 151)
8	App\Service\MenuService->getMenuItems (line 148)
9	App\Twig\GlobalVariableExtension->getGlobals (line 46)
10	Twig\ExtensionSet->getGlobals (line 361)
11	Twig\Environment->getGlobals (line 908)
12	Twig\Template->yield (line 398)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
20	App\Bundle\AppBundle\Controller\NotificationController->notificationsNewCount (line 78)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

1.28 ms
(7.12%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.societe_id AS societe_id_4 FROM parametre t0 WHERE t0.societe_id = ? AND t0.type = ? LIMIT 1

Parameters:

[
  23
  "nbutilisateur"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.valeur AS valeur_3,
  t0.societe_id AS societe_id_4
FROM
  parametre t0
WHERE
  t0.societe_id = ?
  AND t0.type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.societe_id AS societe_id_4 FROM parametre t0 WHERE t0.societe_id = 23 AND t0.type = 'nbutilisateur' 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	App\Bundle\AdminBundle\Service\QuotaService->getQuotaValue (line 47)
5	App\Bundle\AdminBundle\Service\QuotaService->canAddUser (line 23)
6	App\Twig\GlobalVariableExtension->getGlobals (line 103)
7	Twig\ExtensionSet->getGlobals (line 361)
8	Twig\Environment->getGlobals (line 908)
9	Twig\Template->yield (line 398)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Environment->render (line 333)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
17	App\Bundle\AppBundle\Controller\NotificationController->notificationsNewCount (line 78)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

1.06 ms
(5.90%)

SELECT t0.id AS id_1, t0.capsule_client_id AS capsule_client_id_2, t0.nom AS nom_3, t0.forme_juridique AS forme_juridique_4, t0.adresse AS adresse_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.pays AS pays_8, t0.email AS email_9, t0.telephone AS telephone_10, t0.site AS site_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.tva AS tva_14, t0.rcs AS rcs_15, t0.numero_rcs AS numero_rcs_16, t0.capital AS capital_17, t0.numero_tva AS numero_tva_18, t0.logo AS logo_19, t0.logo_crop AS logo_crop_20, t0.token AS token_21, t0.type_societe AS type_societe_22, t0.objet AS objet_23, t0.autre AS autre_24, t0.signature AS signature_25, t0.signature_auto AS signature_auto_26, t0.linkedin AS linkedin_27, t0.presentation AS presentation_28, t0.date1 AS date1_29, t0.date2 AS date2_30, t0.date3 AS date3_31, t0.deleted AS deleted_32, t0.mecene AS mecene_33, t0.dossier AS dossier_34, t0.contact_id AS contact_id_35, t0.banque_id AS banque_id_36, t0.type_id AS type_id_37, t0.departement_id AS departement_id_38, t0.secteur_id AS secteur_id_39 FROM societe t0 WHERE t0.token = ? LIMIT 1

Parameters:

[
  "r9SqJvQQLucV0754g3e6DAj7c6euNGVFsYbQJH6x2b0"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.capsule_client_id AS capsule_client_id_2,
  t0.nom AS nom_3,
  t0.forme_juridique AS forme_juridique_4,
  t0.adresse AS adresse_5,
  t0.code_postal AS code_postal_6,
  t0.ville AS ville_7,
  t0.pays AS pays_8,
  t0.email AS email_9,
  t0.telephone AS telephone_10,
  t0.site AS site_11,
  t0.siren AS siren_12,
  t0.siret AS siret_13,
  t0.tva AS tva_14,
  t0.rcs AS rcs_15,
  t0.numero_rcs AS numero_rcs_16,
  t0.capital AS capital_17,
  t0.numero_tva AS numero_tva_18,
  t0.logo AS logo_19,
  t0.logo_crop AS logo_crop_20,
  t0.token AS token_21,
  t0.type_societe AS type_societe_22,
  t0.objet AS objet_23,
  t0.autre AS autre_24,
  t0.signature AS signature_25,
  t0.signature_auto AS signature_auto_26,
  t0.linkedin AS linkedin_27,
  t0.presentation AS presentation_28,
  t0.date1 AS date1_29,
  t0.date2 AS date2_30,
  t0.date3 AS date3_31,
  t0.deleted AS deleted_32,
  t0.mecene AS mecene_33,
  t0.dossier AS dossier_34,
  t0.contact_id AS contact_id_35,
  t0.banque_id AS banque_id_36,
  t0.type_id AS type_id_37,
  t0.departement_id AS departement_id_38,
  t0.secteur_id AS secteur_id_39
FROM
  societe t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.capsule_client_id AS capsule_client_id_2, t0.nom AS nom_3, t0.forme_juridique AS forme_juridique_4, t0.adresse AS adresse_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.pays AS pays_8, t0.email AS email_9, t0.telephone AS telephone_10, t0.site AS site_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.tva AS tva_14, t0.rcs AS rcs_15, t0.numero_rcs AS numero_rcs_16, t0.capital AS capital_17, t0.numero_tva AS numero_tva_18, t0.logo AS logo_19, t0.logo_crop AS logo_crop_20, t0.token AS token_21, t0.type_societe AS type_societe_22, t0.objet AS objet_23, t0.autre AS autre_24, t0.signature AS signature_25, t0.signature_auto AS signature_auto_26, t0.linkedin AS linkedin_27, t0.presentation AS presentation_28, t0.date1 AS date1_29, t0.date2 AS date2_30, t0.date3 AS date3_31, t0.deleted AS deleted_32, t0.mecene AS mecene_33, t0.dossier AS dossier_34, t0.contact_id AS contact_id_35, t0.banque_id AS banque_id_36, t0.type_id AS type_id_37, t0.departement_id AS departement_id_38, t0.secteur_id AS secteur_id_39 FROM societe t0 WHERE t0.token = 'r9SqJvQQLucV0754g3e6DAj7c6euNGVFsYbQJH6x2b0' 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	App\Bundle\AppBundle\Service\InfoServices->getSociete (line 43)
5	App\EventListener\BundleCheckListener->onKernelRequest (line 37)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.89 ms
(4.97%)

SELECT n0_.id AS id_0, n0_.idtoken AS idtoken_1, n0_.type AS type_2, n0_.titre AS titre_3, n0_.message AS message_4, n0_.action AS action_5, n0_.url AS url_6, n0_.lu AS lu_7, n0_.created_at AS created_at_8, n0_.read_at AS read_at_9, n0_.destinataire_id AS destinataire_id_10 FROM notification n0_ WHERE n0_.destinataire_id = ? AND n0_.lu = 0 ORDER BY n0_.created_at DESC

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.idtoken AS idtoken_1,
  n0_.type AS type_2,
  n0_.titre AS titre_3,
  n0_.message AS message_4,
  n0_.action AS action_5,
  n0_.url AS url_6,
  n0_.lu AS lu_7,
  n0_.created_at AS created_at_8,
  n0_.read_at AS read_at_9,
  n0_.destinataire_id AS destinataire_id_10
FROM
  notification n0_
WHERE
  n0_.destinataire_id = ?
  AND n0_.lu = 0
ORDER BY
  n0_.created_at DESC

SELECT n0_.id AS id_0, n0_.idtoken AS idtoken_1, n0_.type AS type_2, n0_.titre AS titre_3, n0_.message AS message_4, n0_.action AS action_5, n0_.url AS url_6, n0_.lu AS lu_7, n0_.created_at AS created_at_8, n0_.read_at AS read_at_9, n0_.destinataire_id AS destinataire_id_10 FROM notification n0_ WHERE n0_.destinataire_id = 3 AND n0_.lu = 0 ORDER BY n0_.created_at DESC;

#	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\Bundle\AppBundle\Repository\NotificationRepository->findUnreadByDestinataire (line 27)
7	App\Bundle\AppBundle\Controller\NotificationController->notificationsNewCount (line 76)
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	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.82 ms
(4.54%)

SELECT u0_.id AS id_0, u0_.roles AS roles_1, u0_.prenom AS prenom_2, u0_.nom AS nom_3, u0_.qrcode AS qrcode_4, u0_.user_type AS user_type_5, u0_.is_admin AS is_admin_6, u0_.email AS email_7, u0_.password AS password_8, u0_.image AS image_9, u0_.statut AS statut_10, u0_.fonction AS fonction_11, u0_.adresse AS adresse_12, u0_.code_postal AS code_postal_13, u0_.ville AS ville_14, u0_.pays AS pays_15, u0_.telephone AS telephone_16, u0_.token AS token_17, u0_.deleted AS deleted_18, u0_.archive AS archive_19, u0_.telephone_fixe AS telephone_fixe_20, u0_.entreprise AS entreprise_21, u0_.linkedin AS linkedin_22, u0_.siteweb AS siteweb_23, u0_.idtoken AS idtoken_24, u0_.role_id AS role_id_25, u0_.mecene_id AS mecene_id_26, u0_.soc_id AS soc_id_27 FROM user u0_ WHERE u0_.user_type = ? AND u0_.deleted = ? AND EXISTS (SELECT 1 FROM user_societe u1_ WHERE u1_.user_id = u0_.id AND u1_.societe_id IN (?))

Parameters:

[
  "staff"
  0
  23
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.roles AS roles_1,
  u0_.prenom AS prenom_2,
  u0_.nom AS nom_3,
  u0_.qrcode AS qrcode_4,
  u0_.user_type AS user_type_5,
  u0_.is_admin AS is_admin_6,
  u0_.email AS email_7,
  u0_.password AS password_8,
  u0_.image AS image_9,
  u0_.statut AS statut_10,
  u0_.fonction AS fonction_11,
  u0_.adresse AS adresse_12,
  u0_.code_postal AS code_postal_13,
  u0_.ville AS ville_14,
  u0_.pays AS pays_15,
  u0_.telephone AS telephone_16,
  u0_.token AS token_17,
  u0_.deleted AS deleted_18,
  u0_.archive AS archive_19,
  u0_.telephone_fixe AS telephone_fixe_20,
  u0_.entreprise AS entreprise_21,
  u0_.linkedin AS linkedin_22,
  u0_.siteweb AS siteweb_23,
  u0_.idtoken AS idtoken_24,
  u0_.role_id AS role_id_25,
  u0_.mecene_id AS mecene_id_26,
  u0_.soc_id AS soc_id_27
FROM
  user u0_
WHERE
  u0_.user_type = ?
  AND u0_.deleted = ?
  AND EXISTS (
    SELECT
      1
    FROM
      user_societe u1_
    WHERE
      u1_.user_id = u0_.id
      AND u1_.societe_id IN (?)
  )

SELECT u0_.id AS id_0, u0_.roles AS roles_1, u0_.prenom AS prenom_2, u0_.nom AS nom_3, u0_.qrcode AS qrcode_4, u0_.user_type AS user_type_5, u0_.is_admin AS is_admin_6, u0_.email AS email_7, u0_.password AS password_8, u0_.image AS image_9, u0_.statut AS statut_10, u0_.fonction AS fonction_11, u0_.adresse AS adresse_12, u0_.code_postal AS code_postal_13, u0_.ville AS ville_14, u0_.pays AS pays_15, u0_.telephone AS telephone_16, u0_.token AS token_17, u0_.deleted AS deleted_18, u0_.archive AS archive_19, u0_.telephone_fixe AS telephone_fixe_20, u0_.entreprise AS entreprise_21, u0_.linkedin AS linkedin_22, u0_.siteweb AS siteweb_23, u0_.idtoken AS idtoken_24, u0_.role_id AS role_id_25, u0_.mecene_id AS mecene_id_26, u0_.soc_id AS soc_id_27 FROM user u0_ WHERE u0_.user_type = 'staff' AND u0_.deleted = 0 AND EXISTS (SELECT 1 FROM user_societe u1_ WHERE u1_.user_id = u0_.id AND u1_.societe_id IN (23));

#	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\Bundle\AppBundle\Repository\UserRepository->findAllStaffBySociete (line 44)
7	App\Bundle\AdminBundle\Service\QuotaService->canAddUser (line 26)
8	App\Twig\GlobalVariableExtension->getGlobals (line 103)
9	Twig\ExtensionSet->getGlobals (line 361)
10	Twig\Environment->getGlobals (line 908)
11	Twig\Template->yield (line 398)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
19	App\Bundle\AppBundle\Controller\NotificationController->notificationsNewCount (line 78)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

0.68 ms
(3.75%)

SELECT e0_.id AS id_0, e0_.idtoken AS idtoken_1, e0_.nom AS nom_2, e0_.societe_id AS societe_id_3, e0_.wall_id AS wall_id_4 FROM espace e0_ INNER JOIN projet p1_ ON e0_.id = p1_.espace_id WHERE p1_.id IN (?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.idtoken AS idtoken_1,
  e0_.nom AS nom_2,
  e0_.societe_id AS societe_id_3,
  e0_.wall_id AS wall_id_4
FROM
  espace e0_
  INNER JOIN projet p1_ ON e0_.id = p1_.espace_id
WHERE
  p1_.id IN (?, ?, ?, ?)

SELECT e0_.id AS id_0, e0_.idtoken AS idtoken_1, e0_.nom AS nom_2, e0_.societe_id AS societe_id_3, e0_.wall_id AS wall_id_4 FROM espace e0_ INNER JOIN projet p1_ ON e0_.id = p1_.espace_id WHERE p1_.id IN (1, 3, 4, 6);

#	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\Bundle\PortailBundle\Repository\EspaceRepository->findByProjets (line 33)
7	App\Bundle\AppBundle\Service\InfoServices->getInfo (line 101)
8	App\Twig\GlobalVariableExtension->getGlobals (line 100)
9	Twig\ExtensionSet->getGlobals (line 361)
10	Twig\Environment->getGlobals (line 908)
11	Twig\Template->yield (line 398)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
19	App\Bundle\AppBundle\Controller\NotificationController->notificationsNewCount (line 78)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

0.67 ms
(3.71%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.titre AS titre_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.deadline AS deadline_6, t0.statut AS statut_7, t0.created_at AS created_at_8, t0.objectif_financier AS objectif_financier_9, t0.montant_prevu AS montant_prevu_10, t0.montant_recu AS montant_recu_11, t0.archive AS archive_12, t0.logo AS logo_13, t0.affiche AS affiche_14, t0.public AS public_15, t0.deleted AS deleted_16, t0.idtoken AS idtoken_17, t0.gains AS gains_18, t0.depenses AS depenses_19, t0.import_convention AS import_convention_20, t0.import_formule AS import_formule_21, t0.import_modele AS import_modele_22, t0.import_contrepartie AS import_contrepartie_23, t0.import AS import_24, t0.created_by_id AS created_by_id_25, t0.societe_id AS societe_id_26, t0.signataire_id AS signataire_id_27, t0.responsable_id AS responsable_id_28, t0.parent_id AS parent_id_29, t0.presentation_id AS presentation_id_30, t0.espace_id AS espace_id_31 FROM projet t0 WHERE t0.societe_id = ? AND t0.statut = ? AND t0.deleted = ?

Parameters:

[
  23
  "Ouvert"
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.titre AS titre_3,
  t0.start_date AS start_date_4,
  t0.end_date AS end_date_5,
  t0.deadline AS deadline_6,
  t0.statut AS statut_7,
  t0.created_at AS created_at_8,
  t0.objectif_financier AS objectif_financier_9,
  t0.montant_prevu AS montant_prevu_10,
  t0.montant_recu AS montant_recu_11,
  t0.archive AS archive_12,
  t0.logo AS logo_13,
  t0.affiche AS affiche_14,
  t0.public AS public_15,
  t0.deleted AS deleted_16,
  t0.idtoken AS idtoken_17,
  t0.gains AS gains_18,
  t0.depenses AS depenses_19,
  t0.import_convention AS import_convention_20,
  t0.import_formule AS import_formule_21,
  t0.import_modele AS import_modele_22,
  t0.import_contrepartie AS import_contrepartie_23,
  t0.import AS import_24,
  t0.created_by_id AS created_by_id_25,
  t0.societe_id AS societe_id_26,
  t0.signataire_id AS signataire_id_27,
  t0.responsable_id AS responsable_id_28,
  t0.parent_id AS parent_id_29,
  t0.presentation_id AS presentation_id_30,
  t0.espace_id AS espace_id_31
FROM
  projet t0
WHERE
  t0.societe_id = ?
  AND t0.statut = ?
  AND t0.deleted = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.titre AS titre_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.deadline AS deadline_6, t0.statut AS statut_7, t0.created_at AS created_at_8, t0.objectif_financier AS objectif_financier_9, t0.montant_prevu AS montant_prevu_10, t0.montant_recu AS montant_recu_11, t0.archive AS archive_12, t0.logo AS logo_13, t0.affiche AS affiche_14, t0.public AS public_15, t0.deleted AS deleted_16, t0.idtoken AS idtoken_17, t0.gains AS gains_18, t0.depenses AS depenses_19, t0.import_convention AS import_convention_20, t0.import_formule AS import_formule_21, t0.import_modele AS import_modele_22, t0.import_contrepartie AS import_contrepartie_23, t0.import AS import_24, t0.created_by_id AS created_by_id_25, t0.societe_id AS societe_id_26, t0.signataire_id AS signataire_id_27, t0.responsable_id AS responsable_id_28, t0.parent_id AS parent_id_29, t0.presentation_id AS presentation_id_30, t0.espace_id AS espace_id_31 FROM projet t0 WHERE t0.societe_id = 23 AND t0.statut = 'Ouvert' AND t0.deleted = 0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Bundle\AppBundle\Service\InfoServices->getInfo (line 106)
5	App\Twig\GlobalVariableExtension->getGlobals (line 100)
6	Twig\ExtensionSet->getGlobals (line 361)
7	Twig\Environment->getGlobals (line 908)
8	Twig\Template->yield (line 398)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
16	App\Bundle\AppBundle\Controller\NotificationController->notificationsNewCount (line 78)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.64 ms
(3.55%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.titre AS titre_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.deadline AS deadline_6, t0.statut AS statut_7, t0.created_at AS created_at_8, t0.objectif_financier AS objectif_financier_9, t0.montant_prevu AS montant_prevu_10, t0.montant_recu AS montant_recu_11, t0.archive AS archive_12, t0.logo AS logo_13, t0.affiche AS affiche_14, t0.public AS public_15, t0.deleted AS deleted_16, t0.idtoken AS idtoken_17, t0.gains AS gains_18, t0.depenses AS depenses_19, t0.import_convention AS import_convention_20, t0.import_formule AS import_formule_21, t0.import_modele AS import_modele_22, t0.import_contrepartie AS import_contrepartie_23, t0.import AS import_24, t0.created_by_id AS created_by_id_25, t0.societe_id AS societe_id_26, t0.signataire_id AS signataire_id_27, t0.responsable_id AS responsable_id_28, t0.parent_id AS parent_id_29, t0.presentation_id AS presentation_id_30, t0.espace_id AS espace_id_31 FROM projet t0 WHERE t0.statut = ? AND t0.deleted = ?

Parameters:

[
  "Ouvert"
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.titre AS titre_3,
  t0.start_date AS start_date_4,
  t0.end_date AS end_date_5,
  t0.deadline AS deadline_6,
  t0.statut AS statut_7,
  t0.created_at AS created_at_8,
  t0.objectif_financier AS objectif_financier_9,
  t0.montant_prevu AS montant_prevu_10,
  t0.montant_recu AS montant_recu_11,
  t0.archive AS archive_12,
  t0.logo AS logo_13,
  t0.affiche AS affiche_14,
  t0.public AS public_15,
  t0.deleted AS deleted_16,
  t0.idtoken AS idtoken_17,
  t0.gains AS gains_18,
  t0.depenses AS depenses_19,
  t0.import_convention AS import_convention_20,
  t0.import_formule AS import_formule_21,
  t0.import_modele AS import_modele_22,
  t0.import_contrepartie AS import_contrepartie_23,
  t0.import AS import_24,
  t0.created_by_id AS created_by_id_25,
  t0.societe_id AS societe_id_26,
  t0.signataire_id AS signataire_id_27,
  t0.responsable_id AS responsable_id_28,
  t0.parent_id AS parent_id_29,
  t0.presentation_id AS presentation_id_30,
  t0.espace_id AS espace_id_31
FROM
  projet t0
WHERE
  t0.statut = ?
  AND t0.deleted = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.titre AS titre_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.deadline AS deadline_6, t0.statut AS statut_7, t0.created_at AS created_at_8, t0.objectif_financier AS objectif_financier_9, t0.montant_prevu AS montant_prevu_10, t0.montant_recu AS montant_recu_11, t0.archive AS archive_12, t0.logo AS logo_13, t0.affiche AS affiche_14, t0.public AS public_15, t0.deleted AS deleted_16, t0.idtoken AS idtoken_17, t0.gains AS gains_18, t0.depenses AS depenses_19, t0.import_convention AS import_convention_20, t0.import_formule AS import_formule_21, t0.import_modele AS import_modele_22, t0.import_contrepartie AS import_contrepartie_23, t0.import AS import_24, t0.created_by_id AS created_by_id_25, t0.societe_id AS societe_id_26, t0.signataire_id AS signataire_id_27, t0.responsable_id AS responsable_id_28, t0.parent_id AS parent_id_29, t0.presentation_id AS presentation_id_30, t0.espace_id AS espace_id_31 FROM projet t0 WHERE t0.statut = 'Ouvert' AND t0.deleted = 0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Bundle\AppBundle\Service\InfoServices->getInfo (line 100)
5	App\Twig\GlobalVariableExtension->getGlobals (line 100)
6	Twig\ExtensionSet->getGlobals (line 361)
7	Twig\Environment->getGlobals (line 908)
8	Twig\Template->yield (line 398)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
16	App\Bundle\AppBundle\Controller\NotificationController->notificationsNewCount (line 78)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.64 ms
(3.53%)

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.qrcode AS qrcode_5, t0.user_type AS user_type_6, t0.is_admin AS is_admin_7, t0.email AS email_8, t0.password AS password_9, t0.image AS image_10, t0.statut AS statut_11, t0.fonction AS fonction_12, t0.adresse AS adresse_13, t0.code_postal AS code_postal_14, t0.ville AS ville_15, t0.pays AS pays_16, t0.telephone AS telephone_17, t0.token AS token_18, t0.deleted AS deleted_19, t0.archive AS archive_20, t0.telephone_fixe AS telephone_fixe_21, t0.entreprise AS entreprise_22, t0.linkedin AS linkedin_23, t0.siteweb AS siteweb_24, t0.idtoken AS idtoken_25, t0.role_id AS role_id_26, t0.mecene_id AS mecene_id_27, t0.soc_id AS soc_id_28 FROM user t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.prenom AS prenom_3,
  t0.nom AS nom_4,
  t0.qrcode AS qrcode_5,
  t0.user_type AS user_type_6,
  t0.is_admin AS is_admin_7,
  t0.email AS email_8,
  t0.password AS password_9,
  t0.image AS image_10,
  t0.statut AS statut_11,
  t0.fonction AS fonction_12,
  t0.adresse AS adresse_13,
  t0.code_postal AS code_postal_14,
  t0.ville AS ville_15,
  t0.pays AS pays_16,
  t0.telephone AS telephone_17,
  t0.token AS token_18,
  t0.deleted AS deleted_19,
  t0.archive AS archive_20,
  t0.telephone_fixe AS telephone_fixe_21,
  t0.entreprise AS entreprise_22,
  t0.linkedin AS linkedin_23,
  t0.siteweb AS siteweb_24,
  t0.idtoken AS idtoken_25,
  t0.role_id AS role_id_26,
  t0.mecene_id AS mecene_id_27,
  t0.soc_id AS soc_id_28
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.qrcode AS qrcode_5, t0.user_type AS user_type_6, t0.is_admin AS is_admin_7, t0.email AS email_8, t0.password AS password_9, t0.image AS image_10, t0.statut AS statut_11, t0.fonction AS fonction_12, t0.adresse AS adresse_13, t0.code_postal AS code_postal_14, t0.ville AS ville_15, t0.pays AS pays_16, t0.telephone AS telephone_17, t0.token AS token_18, t0.deleted AS deleted_19, t0.archive AS archive_20, t0.telephone_fixe AS telephone_fixe_21, t0.entreprise AS entreprise_22, t0.linkedin AS linkedin_23, t0.siteweb AS siteweb_24, t0.idtoken AS idtoken_25, t0.role_id AS role_id_26, t0.mecene_id AS mecene_id_27, t0.soc_id AS soc_id_28 FROM user t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 92)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 214)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 131)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 77)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.59 ms
(3.28%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.societe_id AS societe_id_4 FROM parametre t0 WHERE t0.societe_id = ?

Parameters:

[
  23
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.valeur AS valeur_3,
  t0.societe_id AS societe_id_4
FROM
  parametre t0
WHERE
  t0.societe_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.societe_id AS societe_id_4 FROM parametre t0 WHERE t0.societe_id = 23;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Twig\GlobalVariableExtension->getGlobals (line 64)
5	Twig\ExtensionSet->getGlobals (line 361)
6	Twig\Environment->getGlobals (line 908)
7	Twig\Template->yield (line 398)
8	Twig\Template->display (line 358)
9	Twig\Template->render (line 373)
10	Twig\TemplateWrapper->render (line 51)
11	Twig\Environment->render (line 333)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
15	App\Bundle\AppBundle\Controller\NotificationController->notificationsNewCount (line 78)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.59 ms
(3.27%)

SELECT COUNT(m0_.id) AS sclr_0 FROM mecene m0_ INNER JOIN mecene_societe m2_ ON m0_.id = m2_.mecene_id INNER JOIN societe s1_ ON s1_.id = m2_.societe_id WHERE s1_.id = ?

Parameters:

[
  23
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  mecene m0_
  INNER JOIN mecene_societe m2_ ON m0_.id = m2_.mecene_id
  INNER JOIN societe s1_ ON s1_.id = m2_.societe_id
WHERE
  s1_.id = ?

SELECT COUNT(m0_.id) AS sclr_0 FROM mecene m0_ INNER JOIN mecene_societe m2_ ON m0_.id = m2_.mecene_id INNER JOIN societe s1_ ON s1_.id = m2_.societe_id WHERE s1_.id = 23;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Bundle\ProjetBundle\Repository\MeceneRepository->countBySociete (line 86)
8	App\Bundle\AdminBundle\Service\QuotaService->canAddPartner (line 38)
9	App\Twig\GlobalVariableExtension->getGlobals (line 104)
10	Twig\ExtensionSet->getGlobals (line 361)
11	Twig\Environment->getGlobals (line 908)
12	Twig\Template->yield (line 398)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
20	App\Bundle\AppBundle\Controller\NotificationController->notificationsNewCount (line 78)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.56 ms
(3.14%)

SELECT t0.id AS id_1, t0.idtoken AS idtoken_2, t0.type AS type_3, t0.nom AS nom_4, t0.valeur AS valeur_5, t0.deduction_fiscale AS deduction_fiscale_6, t0.description AS description_7, t0.personnalise AS personnalise_8, t0.flex AS flex_9, t0.valeur_contrepartie AS valeur_contrepartie_10, t0.valeur_utilisee AS valeur_utilisee_11, t0.created_at AS created_at_12, t0.deleted AS deleted_13, t0.societe_id AS societe_id_14, t0.projet_id AS projet_id_15, t0.niveau_id AS niveau_id_16 FROM formule t0 WHERE t0.societe_id = ? AND t0.deleted = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.idtoken AS idtoken_2,
  t0.type AS type_3,
  t0.nom AS nom_4,
  t0.valeur AS valeur_5,
  t0.deduction_fiscale AS deduction_fiscale_6,
  t0.description AS description_7,
  t0.personnalise AS personnalise_8,
  t0.flex AS flex_9,
  t0.valeur_contrepartie AS valeur_contrepartie_10,
  t0.valeur_utilisee AS valeur_utilisee_11,
  t0.created_at AS created_at_12,
  t0.deleted AS deleted_13,
  t0.societe_id AS societe_id_14,
  t0.projet_id AS projet_id_15,
  t0.niveau_id AS niveau_id_16
FROM
  formule t0
WHERE
  t0.societe_id = ?
  AND t0.deleted = ?

SELECT t0.id AS id_1, t0.idtoken AS idtoken_2, t0.type AS type_3, t0.nom AS nom_4, t0.valeur AS valeur_5, t0.deduction_fiscale AS deduction_fiscale_6, t0.description AS description_7, t0.personnalise AS personnalise_8, t0.flex AS flex_9, t0.valeur_contrepartie AS valeur_contrepartie_10, t0.valeur_utilisee AS valeur_utilisee_11, t0.created_at AS created_at_12, t0.deleted AS deleted_13, t0.societe_id AS societe_id_14, t0.projet_id AS projet_id_15, t0.niveau_id AS niveau_id_16 FROM formule t0 WHERE t0.societe_id = 23 AND t0.deleted = 0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\EventSubscriber\GlobalContextSubscriber->onKernelController (line 53)
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 122)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.54 ms
(3.01%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.groupe AS groupe_4 FROM permission t0 INNER JOIN role_permission ON t0.id = role_permission.permission_id WHERE role_permission.role_id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.groupe AS groupe_4
FROM
  permission t0
  INNER JOIN role_permission ON t0.id = role_permission.permission_id
WHERE
  role_permission.role_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.groupe AS groupe_4 FROM permission t0 INNER JOIN role_permission ON t0.id = role_permission.permission_id WHERE role_permission.role_id = 9;

#	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->getIterator (line 313)
7	App\Service\UserPermissionServices->getPermissions (line 22)
8	App\Twig\GlobalVariableExtension->getGlobals (line 101)
9	Twig\ExtensionSet->getGlobals (line 361)
10	Twig\Environment->getGlobals (line 908)
11	Twig\Template->yield (line 398)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
19	App\Bundle\AppBundle\Controller\NotificationController->notificationsNewCount (line 78)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

0.52 ms
(2.91%)

SELECT t0.id AS id_1, t0.idtoken AS idtoken_2, t0.nom AS nom_3, t0.position AS position_4, t0.nb AS nb_5, t0.affiche AS affiche_6, t0.affiche_nom AS affiche_nom_7, t0.affiche_logo AS affiche_logo_8, t0.deleted AS deleted_9, t0.societe_id AS societe_id_10 FROM niveau_mecenat t0 WHERE t0.societe_id = ? AND t0.deleted = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.idtoken AS idtoken_2,
  t0.nom AS nom_3,
  t0.position AS position_4,
  t0.nb AS nb_5,
  t0.affiche AS affiche_6,
  t0.affiche_nom AS affiche_nom_7,
  t0.affiche_logo AS affiche_logo_8,
  t0.deleted AS deleted_9,
  t0.societe_id AS societe_id_10
FROM
  niveau_mecenat t0
WHERE
  t0.societe_id = ?
  AND t0.deleted = ?

SELECT t0.id AS id_1, t0.idtoken AS idtoken_2, t0.nom AS nom_3, t0.position AS position_4, t0.nb AS nb_5, t0.affiche AS affiche_6, t0.affiche_nom AS affiche_nom_7, t0.affiche_logo AS affiche_logo_8, t0.deleted AS deleted_9, t0.societe_id AS societe_id_10 FROM niveau_mecenat t0 WHERE t0.societe_id = 23 AND t0.deleted = 0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\EventSubscriber\GlobalContextSubscriber->onKernelController (line 49)
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 122)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.49 ms
(2.75%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.groupe AS groupe_4 FROM permission t0 INNER JOIN user_permission ON t0.id = user_permission.permission_id WHERE user_permission.user_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.groupe AS groupe_4
FROM
  permission t0
  INNER JOIN user_permission ON t0.id = user_permission.permission_id
WHERE
  user_permission.user_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.groupe AS groupe_4 FROM permission t0 INNER JOIN user_permission ON t0.id = user_permission.permission_id WHERE user_permission.user_id = 3;

#	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->getIterator (line 313)
7	App\Service\UserPermissionServices->getPermissions (line 28)
8	App\Twig\GlobalVariableExtension->getGlobals (line 101)
9	Twig\ExtensionSet->getGlobals (line 361)
10	Twig\Environment->getGlobals (line 908)
11	Twig\Template->yield (line 398)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
19	App\Bundle\AppBundle\Controller\NotificationController->notificationsNewCount (line 78)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

0.47 ms
(2.62%)

SELECT t0.id AS id_1, t0.idtoken AS idtoken_2, t0.nom AS nom_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.deleted AS deleted_6, t0.societe_id AS societe_id_7 FROM type_mecenat t0 WHERE t0.societe_id = ? AND t0.deleted = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.idtoken AS idtoken_2,
  t0.nom AS nom_3,
  t0.type AS type_4,
  t0.created_at AS created_at_5,
  t0.deleted AS deleted_6,
  t0.societe_id AS societe_id_7
FROM
  type_mecenat t0
WHERE
  t0.societe_id = ?
  AND t0.deleted = ?

SELECT t0.id AS id_1, t0.idtoken AS idtoken_2, t0.nom AS nom_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.deleted AS deleted_6, t0.societe_id AS societe_id_7 FROM type_mecenat t0 WHERE t0.societe_id = 23 AND t0.deleted = 0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\EventSubscriber\GlobalContextSubscriber->onKernelController (line 50)
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 122)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.47 ms
(2.62%)

SELECT t0.id AS id_1, t0.idtoken AS idtoken_2, t0.nom AS nom_3, t0.description AS description_4, t0.image AS image_5, t0.deleted AS deleted_6, t0.valeur AS valeur_7, t0.nombre_activation AS nombre_activation_8, t0.nombre_max AS nombre_max_9, t0.societe_id AS societe_id_10, t0.categorie_id AS categorie_id_11, t0.projet_id AS projet_id_12 FROM type_contrepartie t0 WHERE t0.societe_id = ? AND t0.deleted = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.idtoken AS idtoken_2,
  t0.nom AS nom_3,
  t0.description AS description_4,
  t0.image AS image_5,
  t0.deleted AS deleted_6,
  t0.valeur AS valeur_7,
  t0.nombre_activation AS nombre_activation_8,
  t0.nombre_max AS nombre_max_9,
  t0.societe_id AS societe_id_10,
  t0.categorie_id AS categorie_id_11,
  t0.projet_id AS projet_id_12
FROM
  type_contrepartie t0
WHERE
  t0.societe_id = ?
  AND t0.deleted = ?

SELECT t0.id AS id_1, t0.idtoken AS idtoken_2, t0.nom AS nom_3, t0.description AS description_4, t0.image AS image_5, t0.deleted AS deleted_6, t0.valeur AS valeur_7, t0.nombre_activation AS nombre_activation_8, t0.nombre_max AS nombre_max_9, t0.societe_id AS societe_id_10, t0.categorie_id AS categorie_id_11, t0.projet_id AS projet_id_12 FROM type_contrepartie t0 WHERE t0.societe_id = 23 AND t0.deleted = 0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\EventSubscriber\GlobalContextSubscriber->onKernelController (line 52)
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 122)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.47 ms
(2.61%)

SELECT e0_.id AS id_0, e0_.idtoken AS idtoken_1, e0_.nom AS nom_2, e0_.societe_id AS societe_id_3, e0_.wall_id AS wall_id_4 FROM espace e0_ INNER JOIN projet p1_ ON e0_.id = p1_.espace_id WHERE p1_.id IN (?)

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.idtoken AS idtoken_1,
  e0_.nom AS nom_2,
  e0_.societe_id AS societe_id_3,
  e0_.wall_id AS wall_id_4
FROM
  espace e0_
  INNER JOIN projet p1_ ON e0_.id = p1_.espace_id
WHERE
  p1_.id IN (?)

SELECT e0_.id AS id_0, e0_.idtoken AS idtoken_1, e0_.nom AS nom_2, e0_.societe_id AS societe_id_3, e0_.wall_id AS wall_id_4 FROM espace e0_ INNER JOIN projet p1_ ON e0_.id = p1_.espace_id WHERE p1_.id IN (6);

#	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\Bundle\PortailBundle\Repository\EspaceRepository->findByProjets (line 33)
7	App\Bundle\AppBundle\Service\InfoServices->getInfo (line 107)
8	App\Twig\GlobalVariableExtension->getGlobals (line 100)
9	Twig\ExtensionSet->getGlobals (line 361)
10	Twig\Environment->getGlobals (line 908)
11	Twig\Template->yield (line 398)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
19	App\Bundle\AppBundle\Controller\NotificationController->notificationsNewCount (line 78)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

0.45 ms
(2.47%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.permissions AS permissions_3, t0.deleted AS deleted_4, t0.idtoken AS idtoken_5, t0.societe_id AS societe_id_6 FROM role t0 WHERE t0.id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.permissions AS permissions_3,
  t0.deleted AS deleted_4,
  t0.idtoken AS idtoken_5,
  t0.societe_id AS societe_id_6
FROM
  role t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.permissions AS permissions_3, t0.deleted AS deleted_4, t0.idtoken AS idtoken_5, t0.societe_id AS societe_id_6 FROM role t0 WHERE t0.id = 9;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Bundle\AppBundle\Entity\Role::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
6	Proxies\__CG__\App\Bundle\AppBundle\Entity\Role->__get (line 129)
7	App\Bundle\AppBundle\Entity\Role->getPermission (line 151)
8	App\Service\UserPermissionServices->getPermissions (line 22)
9	App\Twig\GlobalVariableExtension->getGlobals (line 101)
10	Twig\ExtensionSet->getGlobals (line 361)
11	Twig\Environment->getGlobals (line 908)
12	Twig\Template->yield (line 398)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
20	App\Bundle\AppBundle\Controller\NotificationController->notificationsNewCount (line 78)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.42 ms
(2.34%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.user_id AS user_id_4 FROM parametre_user t0 WHERE t0.user_id = ? AND t0.type = ? LIMIT 1

Parameters:

[
  3
  "accept_cgu"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.valeur AS valeur_3,
  t0.user_id AS user_id_4
FROM
  parametre_user t0
WHERE
  t0.user_id = ?
  AND t0.type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.user_id AS user_id_4 FROM parametre_user t0 WHERE t0.user_id = 3 AND t0.type = 'accept_cgu' 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	App\Bundle\AppBundle\Service\ParametreUserService->getParametre (line 22)
5	App\EventSubscriber\GlobalContextSubscriber->onKernelController (line 69)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.39 ms
(2.16%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.espace_id AS espace_id_4 FROM parametre_espace t0 WHERE t0.espace_id IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.valeur AS valeur_3,
  t0.espace_id AS espace_id_4
FROM
  parametre_espace t0
WHERE
  t0.espace_id IS NULL

SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.espace_id AS espace_id_4 FROM parametre_espace t0 WHERE t0.espace_id IS NULL;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Bundle\AppBundle\Service\InfoServices->getInfo (line 86)
5	App\Twig\GlobalVariableExtension->getGlobals (line 100)
6	Twig\ExtensionSet->getGlobals (line 361)
7	Twig\Environment->getGlobals (line 908)
8	Twig\Template->yield (line 398)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
16	App\Bundle\AppBundle\Controller\NotificationController->notificationsNewCount (line 78)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.39 ms
(2.15%)

SELECT t0.id AS id_1, t0.bundle_name AS bundle_name_2, t0.active AS active_3, t0.societe_id AS societe_id_4 FROM subscription t0 WHERE t0.societe_id = ?

Parameters:

[
  23
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.bundle_name AS bundle_name_2,
  t0.active AS active_3,
  t0.societe_id AS societe_id_4
FROM
  subscription t0
WHERE
  t0.societe_id = ?

SELECT t0.id AS id_1, t0.bundle_name AS bundle_name_2, t0.active AS active_3, t0.societe_id AS societe_id_4 FROM subscription t0 WHERE t0.societe_id = 23;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Service\BundleManager->getActiveBundles (line 45)
5	App\Service\MenuService->getMenuItems (line 51)
6	App\Twig\GlobalVariableExtension->getGlobals (line 46)
7	Twig\ExtensionSet->getGlobals (line 361)
8	Twig\Environment->getGlobals (line 908)
9	Twig\Template->yield (line 398)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Environment->render (line 333)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
17	App\Bundle\AppBundle\Controller\NotificationController->notificationsNewCount (line 78)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	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\Bundle\AdminBundle\Entity\Subscription	13
App\Bundle\ProjetBundle\Entity\TypeContrepartie	11
App\Bundle\AdminBundle\Entity\Parametre	7
App\Bundle\ProjetBundle\Entity\Formule	6
App\Bundle\AdminBundle\Entity\Societe	5
App\Bundle\AppBundle\Entity\User	4
App\Bundle\ProjetBundle\Entity\CategorieContrepartie	4
App\Bundle\ProjetBundle\Entity\Projet	4
App\Bundle\PortailBundle\Entity\Espace	4
App\Bundle\WallBundle\Entity\Wall	4
App\Bundle\ProjetBundle\Entity\TypeMecenat	3
App\Bundle\ProjetBundle\Entity\ProjetPresentation	3
App\Bundle\AppBundle\Entity\Role	2
App\Bundle\ProjetBundle\Entity\NiveauMecenat	2
App\Bundle\AdminBundle\Entity\TypeSociete	1
App\Bundle\AdminBundle\Entity\Departement	1
App\Bundle\AppBundle\Entity\ParametreUser	1

Entities Mapping

Class	Mapping errors
App\Bundle\AdminBundle\Entity\Societe	No errors.
App\Bundle\AppBundle\Entity\User	The association App\Bundle\AppBundle\Entity\User#mecene refers to the inverse side field App\Bundle\ProjetBundle\Entity\Mecene#users which does not exist.
App\Bundle\CommercialBundle\Entity\Banque	No errors.
App\Bundle\AdminBundle\Entity\TypeSociete	No errors.
App\Bundle\AdminBundle\Entity\Departement	No errors.
App\Bundle\AdminBundle\Entity\SecteurActivite	No errors.
App\Bundle\AdminBundle\Entity\Parametre	No errors.
App\Bundle\ProjetBundle\Entity\Mecene	If association App\Bundle\ProjetBundle\Entity\Mecene#societe is many-to-many, then the inversed side App\Bundle\AdminBundle\Entity\Societe#mecenes has to be many-to-many as well.
App\Bundle\CommercialBundle\Entity\Facture	No errors.
App\Bundle\ProjetBundle\Entity\FactureProjet	The association App\Bundle\ProjetBundle\Entity\FactureProjet#convention refers to the inverse side field App\Bundle\ProjetBundle\Entity\Convention#factures which does not exist. The mappings App\Bundle\ProjetBundle\Entity\FactureProjet#apport and App\Bundle\ProjetBundle\Entity\Apport#factures are inconsistent with each other.
App\Bundle\CommercialBundle\Entity\Produit	The association App\Bundle\CommercialBundle\Entity\Produit#taxe refers to the inverse side field App\Bundle\CommercialBundle\Entity\Taxe#produits which does not exist.
App\Bundle\ProjetBundle\Entity\Projet	The association App\Bundle\ProjetBundle\Entity\Projet#presentation refers to the inverse side field App\Bundle\ProjetBundle\Entity\ProjetPresentation#societe which does not exist.
App\Bundle\AppBundle\Entity\Role	No errors.
App\Bundle\ProjetBundle\Entity\Ticket	The mappings App\Bundle\ProjetBundle\Entity\Ticket#assignedTo and App\Bundle\AppBundle\Entity\User#tickets are inconsistent with each other.
App\Bundle\AdminBundle\Entity\Subscription	No errors.
App\Bundle\AdminBundle\Entity\SubscriptionModule	No errors.
App\Bundle\CommercialBundle\Entity\Taxe	No errors.
App\Bundle\ProjetBundle\Entity\Commentaire	The mappings App\Bundle\ProjetBundle\Entity\Commentaire#user and App\Bundle\AppBundle\Entity\User#commentaires are inconsistent with each other.
App\Bundle\ProjetBundle\Entity\Contrepartie	No errors.
App\Bundle\ProjetBundle\Entity\TypeMecenat	No errors.
App\Bundle\ProjetBundle\Entity\Formule	No errors.
App\Bundle\ProjetBundle\Entity\NiveauMecenat	No errors.
App\Bundle\ProjetBundle\Entity\TypeContrepartie	No errors.
App\Bundle\ProjetBundle\Entity\CategorieContrepartie	No errors.
App\Bundle\ProjetBundle\Entity\Convention	No errors.
App\Bundle\ProjetBundle\Entity\Modele	The mappings App\Bundle\ProjetBundle\Entity\Modele#updatedBy and App\Bundle\AppBundle\Entity\User#modeles are inconsistent with each other.
App\Bundle\ProjetBundle\Entity\DocumentConvention	The mappings App\Bundle\ProjetBundle\Entity\DocumentConvention#updatedBy and App\Bundle\AppBundle\Entity\User#documentConventions are inconsistent with each other.
App\Bundle\ProjetBundle\Entity\RecuFiscal	No errors.
App\Bundle\ProjetBundle\Entity\Apport	The mappings App\Bundle\ProjetBundle\Entity\Apport#factures and App\Bundle\ProjetBundle\Entity\FactureProjet#societe are inconsistent with each other.
App\Bundle\ProjetBundle\Entity\Historique	No errors.
App\Bundle\GalerieBundle\Entity\Galerie	No errors.
App\Bundle\GalerieBundle\Entity\Photo	No errors.
App\Bundle\EvenementBundle\Entity\Evenement	The association App\Bundle\EvenementBundle\Entity\Evenement#projet refers to the inverse side field App\Bundle\ProjetBundle\Entity\Projet#evenements which does not exist.
App\Bundle\EvenementBundle\Entity\Inscription	No errors.
App\Bundle\WallBundle\Entity\Wall	No errors.
App\Bundle\WallBundle\Entity\Post	No errors.
App\Bundle\EvenementBundle\Entity\Participation	No errors.
App\Bundle\PortailBundle\Entity\Espace	No errors.
App\Bundle\PortailBundle\Entity\Annonce	No errors.
App\Bundle\PortailBundle\Entity\Offre	No errors.
App\Bundle\PortailBundle\Entity\PartenaireMois	No errors.
App\Bundle\ProjetBundle\Entity\SocieteMecene	No errors.
App\Bundle\ProjetBundle\Entity\Tag	No errors.
App\Entity\Groupe	No errors.
App\Bundle\AppBundle\Entity\Permission	No errors.
App\Bundle\ProjetBundle\Entity\Tache	No errors.
App\Bundle\ProjetBundle\Entity\CommunicationProjet	No errors.
App\Bundle\AppBundle\Entity\Notification	No errors.
App\Bundle\AppBundle\Entity\NotificationUser	No errors.
App\Bundle\MessagerieBundle\Entity\Message	The mappings App\Bundle\MessagerieBundle\Entity\Message#root and App\Bundle\MessagerieBundle\Entity\Message#messages are inconsistent with each other.
App\Bundle\MessagerieBundle\Entity\Conversation	No errors.
App\Bundle\MessagerieBundle\Entity\MessageRecipient	No errors.
App\Bundle\WallBundle\Entity\Commentaire	No errors.
App\Bundle\WallBundle\Entity\Reaction	No errors.
App\Bundle\ProjetBundle\Entity\ProjetPresentation	No errors.
App\Bundle\ProjetBundle\Entity\Prospection	No errors.
App\Bundle\ProjetBundle\Entity\Proposition	No errors.
App\Bundle\AppBundle\Entity\ParametreUser	No errors.
App\Bundle\ProjetBundle\Entity\Realisation	No errors.
App\Bundle\ProjetBundle\Entity\FormuleContrepartieOption	No errors.
App\Bundle\PortailBundle\Entity\ParametreEspace	The association App\Bundle\PortailBundle\Entity\ParametreEspace#espace refers to the inverse side field App\Bundle\PortailBundle\Entity\Espace#parametres which does not exist.

Symfony Profiler

GET https://demo.fundup.fr/index.php/portail/notifications/new-count

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping