Query Metrics
25
Database Queries
7
Different statements
35.16 ms
Query time
1
Invalid entities
Grouped Statements
| 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 |
|
| 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. |