https://teste-symfony5.intranet-mariestopesbf.org/1/edit

Query Metrics

25 Database Queries
7 Different statements
35.16 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
15.50 ms
(44.09%)
19
SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.key_name AS key_name_4, t0.locale AS locale_5, t0.content AS content_6, t0.domain AS domain_7 FROM translation t0 WHERE t0.entity_type = ? AND t0.entity_id = ? AND t0.key_name = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "Catalogue"
  1
  "designation"
  "en"
]
15.34 ms
(43.61%)
1
SELECT t0.id AS id_1, t0.passwordChangedAt AS passwordChangedAt_2, t0.username AS username_3, t0.username_canonical AS username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.locked AS locked_13, t0.expired AS expired_14, t0.expires_at AS expires_at_15, t0.roles AS roles_16, t0.credentials_expired AS credentials_expired_17, t0.credentials_expire_at AS credentials_expire_at_18, t0.nom AS nom_19, t0.idsup AS idsup_20, t0.equipe AS equipe_21, t0.prenom AS prenom_22, t0.poste AS poste_23, t0.service AS service_24, t0.tel AS tel_25, t0.zone AS zone_26, t0.locale AS locale_27, t0.supH_id AS supH_id_28, t0.images_id AS images_id_29, t0.reviewtec_id AS reviewtec_id_30, t0.approb_id AS approb_id_31 FROM mstopeuser t0 WHERE t0.id = ?
Parameters:
[
  9
]
1.76 ms
(5.01%)
1
SELECT t0.id AS id_1, t0.type_article AS type_article_2, t0.designation AS designation_3, t0.description AS description_4, t0.code_article AS code_article_5, t0.asset AS asset_6, t0.stockable AS stockable_7, t0.unite AS unite_8, t0.prix AS prix_9, t0.date_creer AS date_creer_10, t0.date_modif AS date_modif_11, t0.prix_ht AS prix_ht_12, t0.taxe AS taxe_13, t0.min_stock AS min_stock_14, t0.max_stock AS max_stock_15, t0.stock_securite AS stock_securite_16, t0.type_mrp AS type_mrp_17, t0.supplier_lead_time AS supplier_lead_time_18, t0.procurement_lead_time AS procurement_lead_time_19, t0.monthly_consumption AS monthly_consumption_20, t0.categorycatalogue_id AS categorycatalogue_id_21, t0.sous_category_catalogue_id AS sous_category_catalogue_id_22, t0.asset_code_famille_id AS asset_code_famille_id_23, t0.asset_code_category_id AS asset_code_category_id_24, t0.image_id AS image_id_25, t0.user_id AS user_id_26 FROM Catalogue t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.92 ms
(2.63%)
1
SELECT t0.id AS id_1, t0.delai_grace_peremption_jours AS delai_grace_peremption_jours_2, t0.libelle AS libelle_3, t0.code AS code_4, t0.codComp AS codComp_5 FROM CategoryCatalogue t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.67 ms
(1.91%)
1
SELECT f0_.id AS id_0, f0_.libele AS libele_1, f0_.nomequip AS nomequip_2 FROM famille_j f0_
Parameters:
[]
0.63 ms
(1.79%)
1
SELECT c0_.id AS id_0, c0_.delai_grace_peremption_jours AS delai_grace_peremption_jours_1, c0_.libelle AS libelle_2, c0_.code AS code_3, c0_.codComp AS codComp_4 FROM CategoryCatalogue c0_
Parameters:
[]
0.34 ms
(0.97%)
1
SELECT c0_.id AS id_0, c0_.duree_amortissement AS duree_amortissement_1, c0_.methode_amortissement AS methode_amortissement_2, c0_.libele AS libele_3, c0_.nomequip AS nomequip_4, c0_.famille_id AS famille_id_5 FROM category_j c0_ WHERE 1 = 0 ORDER BY c0_.libele ASC
Parameters:
[]

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\User No errors.
App\Entity\SupH No errors.
App\Entity\ImageS No errors.
App\Entity\ReviewTec No errors.
App\Entity\Approb No errors.
App\Entity\Catalogue No errors.
App\Entity\CategoryCatalogue
  • The field App\Entity\CategoryCatalogue#lignePlanMappings is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CategoryCatalogueLignePlan#categorie does not contain the required 'inversedBy: "lignePlanMappings"' attribute.
App\Entity\SousCategoryCatalogue No errors.
App\Entity\FamilleJ No errors.
App\Entity\CategoryJ No errors.
App\Entity\Image No errors.
App\Entity\Translation No errors.
App\Entity\CategoryCatalogueLignePlan No errors.
App\Entity\CategorieMarche No errors.