POST https://business-n2a.myn2a.online/api/platform-login?platform=0

Query Metrics

4 Database Queries
4 Different statements
3.15 ms Query time
2 Invalid entities
10 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.08 ms
(34.34%)
1
SELECT c0_.id AS id_0, c0_.role_code AS role_code_1, c0_.date_debut AS date_debut_2, c0_.date_fin AS date_fin_3, p1_.id AS id_4, p1_.code AS code_5, p1_.nom AS nom_6, p1_.description AS description_7, p1_.prix AS prix_8, p1_.logo AS logo_9, p1_.banniere AS banniere_10, p1_.presentation AS presentation_11, p1_.site_officiel AS site_officiel_12, p1_.lien_plateforme AS lien_plateforme_13, p1_.base_prefix AS base_prefix_14, p1_.base_suffix AS base_suffix_15, p1_.api_service AS api_service_16, p1_.api_provisionning AS api_provisionning_17, p1_.db_host AS db_host_18, p1_.db_name AS db_name_19, p1_.db_user AS db_user_20, p1_.db_pass AS db_pass_21, p1_.base_url AS base_url_22, p1_.api_key AS api_key_23, p1_.numero_bpay AS numero_bpay_24, p1_.portail AS portail_25, p1_.ordre_portail AS ordre_portail_26, p1_.sous_compte_bpay AS sous_compte_bpay_27, p1_.updated_at AS updated_at_28, e2_.id AS id_29, e2_.nom AS nom_30, e2_.libelle AS libelle_31, e2_.logo AS logo_32, e2_.telephone AS telephone_33, e2_.email AS email_34, e2_.dgi_token AS dgi_token_35, e2_.site_web AS site_web_36, e2_.slogan AS slogan_37, e2_.gps AS gps_38, e2_.address AS address_39, e2_.code AS code_40, e2_.livrado AS livrado_41, e2_.businesspay AS businesspay_42, e2_.bpay_account AS bpay_account_43, e2_.businesspay_account AS businesspay_account_44, e2_.cashline_account AS cashline_account_45, e2_.careconcept_account AS careconcept_account_46, e2_.instantmark_account AS instantmark_account_47, e3_.id AS id_48, e3_.libelle AS libelle_49, e3_.logo AS logo_50, e3_.telephone AS telephone_51, e3_.email AS email_52, e3_.site_web AS site_web_53, e3_.gps AS gps_54, e3_.address AS address_55, e3_.description AS description_56, e3_.ifu AS ifu_57, e3_.rccm AS rccm_58, e3_.dgi_token AS dgi_token_59, e3_.bpay_account AS bpay_account_60, e3_.careconcept_account AS careconcept_account_61, e3_.businesspay_account AS businesspay_account_62, e3_.cashline_account AS cashline_account_63, e3_.instantmark_account AS instantmark_account_64, c0_.user_id AS user_id_65, c0_.entreprise_id AS entreprise_id_66, c0_.enseigne_id AS enseigne_id_67, c0_.plateforme_id AS plateforme_id_68, e2_.pays_id AS pays_id_69, e2_.entreprise_id AS entreprise_id_70, e2_.secteur_activite_id AS secteur_activite_id_71, e2_.pack_id AS pack_id_72, e2_.mode_integration_id AS mode_integration_id_73, e3_.user_id AS user_id_74, e3_.pays_id AS pays_id_75 FROM collaboration c0_ LEFT JOIN plateforme p1_ ON c0_.plateforme_id = p1_.id LEFT JOIN enseigne e2_ ON c0_.enseigne_id = e2_.id LEFT JOIN entreprise e3_ ON c0_.entreprise_id = e3_.id WHERE c0_.user_id = ? AND (c0_.date_fin IS NULL OR c0_.date_fin > ?) ORDER BY c0_.date_debut DESC
Parameters:
[
  37
  "2026-01-24 22:38:44"
]
0.84 ms
(26.71%)
1
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.email AS email_5, t0.telephone AS telephone_6, t0.ifu AS ifu_7, t0.password AS password_8, t0.roles AS roles_9, t0.photo_profil AS photo_profil_10, t0.type_compte AS type_compte_11, t0.confirmation_token AS confirmation_token_12, t0.reset_password_token AS reset_password_token_13, t0.reset_password_requested_at AS reset_password_requested_at_14, t0.is_verified AS is_verified_15, t0.confirmed_at AS confirmed_at_16, t0.last_confirmation_email_sent_at AS last_confirmation_email_sent_at_17, t0.bpay_account AS bpay_account_18, t0.careconcept_account AS careconcept_account_19, t0.businesspay_account AS businesspay_account_20, t0.cashline_account AS cashline_account_21, t0.instantmark_account AS instantmark_account_22 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "honorine.beakou@danone.com"
]
0.73 ms
(23.18%)
1
SELECT t0.code AS code_1, t0.name AS name_2 FROM role t0 INNER JOIN user_role ON t0.code = user_role.role_code WHERE user_role.user_id = ?
Parameters:
[
  37
]
0.50 ms
(15.77%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.description AS description_4 FROM mode_integration t0 WHERE t0.id = ?
Parameters:
[
  2
]

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\Users 2
App\Entity\Collaboration 1
App\Entity\Plateforme 1
App\Entity\Enseigne 1
App\Entity\Pays 1
App\Entity\Entreprise 1
App\Entity\SecteurActivite 1
App\Entity\Pack 1
App\Entity\ModeIntegration 1

Entities Mapping

Class Mapping errors
App\Entity\Users No errors.
App\Entity\Entreprise No errors.
App\Entity\Role No errors.
App\Entity\Collaboration No errors.
App\Entity\Plateforme No errors.
App\Entity\Enseigne
  • The field App\Entity\Enseigne#packAbonnements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PackAbonnement#enseigne does not contain the required 'inversedBy="packAbonnements"' attribute.
App\Entity\Pays No errors.
App\Entity\SecteurActivite
  • The association App\Entity\SecteurActivite#entreprises refers to the owning side field App\Entity\Entreprise#secteurActivite which does not exist.
App\Entity\Pack No errors.
App\Entity\ModeIntegration No errors.
App\Entity\PackAbonnement No errors.