GET https://dev.fundup.fr/notifications/dropdown

Query Metrics

6 Database Queries
6 Different statements
4.86 ms Query time
6 Invalid entities
3 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.79 ms
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.qr_token AS qr_token_6, t0.user_type AS user_type_7, t0.is_admin AS is_admin_8, t0.email AS email_9, t0.password AS password_10, t0.image AS image_11, t0.signature_path AS signature_path_12, t0.signature_uploaded_at AS signature_uploaded_at_13, t0.signature_auto_enabled AS signature_auto_enabled_14, t0.statut AS statut_15, t0.fonction AS fonction_16, t0.adresse AS adresse_17, t0.code_postal AS code_postal_18, t0.ville AS ville_19, t0.pays AS pays_20, t0.telephone AS telephone_21, t0.token AS token_22, t0.deleted AS deleted_23, t0.archive AS archive_24, t0.telephone_fixe AS telephone_fixe_25, t0.entreprise AS entreprise_26, t0.linkedin AS linkedin_27, t0.siteweb AS siteweb_28, t0.idtoken AS idtoken_29, t0.role_id AS role_id_30, t0.mecene_id AS mecene_id_31, t0.soc_id AS soc_id_32 FROM user t0 WHERE t0.id = ?
Parameters:
[
  3
]
2 0.76 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.metadata AS metadata_4, t0.user_id AS user_id_5 FROM parametre_user t0 WHERE t0.user_id = ? AND t0.type = ? LIMIT 1
Parameters:
[
  3
  "accept_cgu"
]
3 0.60 ms
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
]
4 0.60 ms
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:
[
  3
]
5 0.56 ms
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:
[
  3
]
6 1.55 ms
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_.icon AS icon_7, n0_.color AS color_8, n0_.target_entity AS target_entity_9, n0_.target_entity_id AS target_entity_id_10, n0_.lu AS lu_11, n0_.created_at AS created_at_12, n0_.read_at AS read_at_13, n0_.priority AS priority_14, n0_.metadata AS metadata_15, n0_.expires_at AS expires_at_16, n0_.updated_at AS updated_at_17, n0_.destinataire_id AS destinataire_id_18, n0_.societe_id AS societe_id_19, n0_.projet_id AS projet_id_20 FROM notification n0_ WHERE n0_.destinataire_id = ? AND (n0_.expires_at IS NULL OR n0_.expires_at > ?) ORDER BY n0_.created_at DESC LIMIT 10
Parameters:
[
  3
  "2026-10-06 12:32:04"
]

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\AppBundle\Entity\User 1
App\Bundle\AppBundle\Entity\Role 1
App\Bundle\AppBundle\Entity\ParametreUser 1

Entities Mapping

Class Mapping 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\AppBundle\Entity\Role 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\AdminBundle\Entity\Societe No errors.
App\Bundle\AppBundle\Entity\Permission No errors.
App\Bundle\ProjetBundle\Entity\Projet No errors.
App\Bundle\ProjetBundle\Entity\Tache No errors.
App\Bundle\AppBundle\Entity\Equipe 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\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\Historique No errors.
App\Bundle\ProjetBundle\Entity\CommunicationProjet No errors.
App\Bundle\EvenementBundle\Entity\Evenement No errors.
App\Bundle\EvenementBundle\Entity\Inscription 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\Post No errors.
App\Bundle\WallBundle\Entity\Commentaire No errors.
App\Bundle\WallBundle\Entity\Reaction No errors.
App\Bundle\EvenementBundle\Entity\Participation 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\PortailBundle\Entity\Annonce No errors.
App\Bundle\PortailBundle\Entity\Offre No errors.
App\Bundle\PortailBundle\Entity\PartenaireMois No errors.
App\Bundle\AppBundle\Entity\ParametreUser No errors.