Query Metrics

11 Database Queries
6 Different statements
4.87 ms Query time
1 Invalid entities
17 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.60 ms
(32.80%)
2
SELECT t0.clef AS clef_1, t0.valeur AS valeur_2 FROM app_config t0 WHERE t0.clef = ?
Parameters:
[
  "maintenance_mode"
]
0.94 ms
(19.39%)
5
SELECT t0.id AS id_1, t0.numero_carte AS numero_carte_2, t0.points_actuels AS points_actuels_3, t0.points_totaux AS points_totaux_4, t0.created_at AS created_at_5, t0.user_uuid AS user_uuid_6 FROM fidelity_card t0 WHERE t0.user_uuid = ?
Parameters:
[
  "c3e7bd9e-da51-4d2e-b58e-fe3a133c1ad4"
]
0.71 ms
(14.59%)
1
SELECT t0.uuid AS uuid_1, t0.email AS email_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.telephone AS telephone_5, t0.ifu AS ifu_6, t0.photo AS photo_7, t0.roles AS roles_8, t0.position_updated_at AS position_updated_at_9, t0.type_compte AS type_compte_10, t0.created_at AS created_at_11, t0.last_login_at AS last_login_at_12, t0.bpay_account AS bpay_account_13, t0.business_pay_account AS business_pay_account_14, t0.care_concept_account AS care_concept_account_15, t0.cashline_account AS cashline_account_16, t0.current_lat AS current_lat_17, t0.current_lon AS current_lon_18, t19.id AS id_20, t19.numero_carte AS numero_carte_21, t19.points_actuels AS points_actuels_22, t19.points_totaux AS points_totaux_23, t19.created_at AS created_at_24, t19.user_uuid AS user_uuid_25 FROM users t0 LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid WHERE t0.uuid = ?
Parameters:
[
  "5744ad07-6692-4bf5-aabf-613bece4c3e8"
]
0.59 ms
(12.18%)
1
SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.description AS description_2, h0_.position AS position_3, h0_.path AS path_4, h0_.level AS level_5, h0_.children_count AS children_count_6, h0_.created_at AS created_at_7, h1_.id AS id_8, h1_.role_in_unit AS role_in_unit_9, h1_.is_manager AS is_manager_10, h1_.start_date AS start_date_11, h1_.end_date AS end_date_12, h1_.assigned_at AS assigned_at_13, u2_.uuid AS uuid_14, u2_.email AS email_15, u2_.prenom AS prenom_16, u2_.nom AS nom_17, u2_.telephone AS telephone_18, u2_.ifu AS ifu_19, u2_.photo AS photo_20, u2_.roles AS roles_21, u2_.position_updated_at AS position_updated_at_22, u2_.type_compte AS type_compte_23, u2_.created_at AS created_at_24, u2_.last_login_at AS last_login_at_25, u2_.bpay_account AS bpay_account_26, u2_.business_pay_account AS business_pay_account_27, u2_.care_concept_account AS care_concept_account_28, u2_.cashline_account AS cashline_account_29, u2_.current_lat AS current_lat_30, u2_.current_lon AS current_lon_31, h0_.manager_uuid AS manager_uuid_32, h0_.enseigne_id AS enseigne_id_33, h0_.type_entity_id AS type_entity_id_34, h0_.parent_id AS parent_id_35, h1_.user_uuid AS user_uuid_36, h1_.unit_id AS unit_id_37 FROM hr_organizational_unit h0_ LEFT JOIN hr_user_unit h1_ ON h0_.id = h1_.unit_id LEFT JOIN users u2_ ON h1_.user_uuid = u2_.uuid WHERE h0_.id = ?
Parameters:
[
  "69a7c20a-0fa5-4ac5-acb7-7af46b574d86"
]
0.55 ms
(11.38%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.libelle AS libelle_4, t0.main_db_host AS main_db_host_5, t0.main_db_name AS main_db_name_6, t0.main_db_user AS main_db_user_7, t0.main_db_pass AS main_db_pass_8, t0.base_url AS base_url_9, t0.api_key AS api_key_10, t0.dgi_token AS dgi_token_11 FROM enseignes t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "YLWE"
]
0.47 ms
(9.66%)
1
SELECT t0.uuid AS uuid_1, t0.email AS email_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.telephone AS telephone_5, t0.ifu AS ifu_6, t0.photo AS photo_7, t0.roles AS roles_8, t0.position_updated_at AS position_updated_at_9, t0.type_compte AS type_compte_10, t0.created_at AS created_at_11, t0.last_login_at AS last_login_at_12, t0.bpay_account AS bpay_account_13, t0.business_pay_account AS business_pay_account_14, t0.care_concept_account AS care_concept_account_15, t0.cashline_account AS cashline_account_16, t0.current_lat AS current_lat_17, t0.current_lon AS current_lon_18, t19.id AS id_20, t19.numero_carte AS numero_carte_21, t19.points_actuels AS points_actuels_22, t19.points_totaux AS points_totaux_23, t19.created_at AS created_at_24, t19.user_uuid AS user_uuid_25 FROM users t0 LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid WHERE t0.email = ? LIMIT 1
Parameters:
[
  "f_singbo@n2a.online"
]

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 6
App\Entity\HR\UserOrganizationalUnit 5
App\Entity\AppConfig 2
App\Entity\HR\OrganizationalUnit 2
App\Entity\Enseigne 1
App\Entity\HR\UnitType 1

Entities Mapping

Class Mapping errors
App\Entity\AppConfig No errors.
App\Entity\Users No errors.
App\Entity\FidelityCard No errors.
App\Entity\Reward No errors.
App\Entity\HR\UserOrganizationalUnit No errors.
App\Entity\Enseigne No errors.
App\Entity\PointDeVente No errors.
App\Entity\RewardType No errors.
App\Entity\RedemptionType No errors.
App\Entity\HR\OrganizationalUnit No errors.
App\Entity\HR\UnitType
  • The field App\Entity\HR\UnitType#units is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\HR\OrganizationalUnit#typeEntity does not contain the required 'inversedBy="units"' attribute.