GET https://developpement.rebootfrance.fr/public/apercuProduit/1243

Query Metrics

31 Database Queries
10 Different statements
4.62 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.55 ms
SELECT t0.id AS id_1, t0.modele AS modele_2, t0.description AS description_3, t0.description_supplementaire AS description_supplementaire_4, t0.premiere_image AS premiere_image_5, t0.images AS images_6, t0.recommandation_boutique AS recommandation_boutique_7, t0.recommandation_don AS recommandation_don_8, t0.avis_technicien AS avis_technicien_9, t0.categorie_produits_id AS categorie_produits_id_10, t0.marque_id AS marque_id_11 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  "1243"
]
2 0.16 ms
SELECT g0_.id AS id_0, g0_.nom AS nom_1, g0_.description AS description_2, g0_.rang AS rang_3 FROM grade g0_ WHERE g0_.rang = ?
Parameters:
[
  1
]
3 0.29 ms
SELECT p0_.id AS id_0, p0_.codeinterne AS codeinterne_1, p0_.produit_id AS produit_id_2, p0_.statut_piece_id AS statut_piece_id_3, p0_.grade_id AS grade_id_4, p0_.lot_id AS lot_id_5, p0_.emplacement_stock_id AS emplacement_stock_id_6, p0_.cart_id AS cart_id_7, p0_.devis_id AS devis_id_8 FROM piece_individuelle p0_ INNER JOIN statut_piece s1_ ON p0_.statut_piece_id = s1_.id WHERE p0_.produit_id = ? AND p0_.grade_id = ? AND s1_.is_disponible = 1 AND p0_.codeinterne = 0 ORDER BY p0_.id ASC LIMIT 1000
Parameters:
[
  "1243"
  1
]
4 0.25 ms
SELECT t0.id AS id_1, t0.prix AS prix_2, t0.grade_id AS grade_id_3, t0.produit_id AS produit_id_4 FROM produit_grade_prix t0 WHERE t0.produit_id = ? ORDER BY t0.grade_id ASC
Parameters:
[
  1243
]
5 0.17 ms
SELECT g0_.id AS id_0, g0_.nom AS nom_1, g0_.description AS description_2, g0_.rang AS rang_3 FROM grade g0_ WHERE g0_.rang = ?
Parameters:
[
  2
]
6 0.29 ms
SELECT p0_.id AS id_0, p0_.codeinterne AS codeinterne_1, p0_.produit_id AS produit_id_2, p0_.statut_piece_id AS statut_piece_id_3, p0_.grade_id AS grade_id_4, p0_.lot_id AS lot_id_5, p0_.emplacement_stock_id AS emplacement_stock_id_6, p0_.cart_id AS cart_id_7, p0_.devis_id AS devis_id_8 FROM piece_individuelle p0_ INNER JOIN statut_piece s1_ ON p0_.statut_piece_id = s1_.id WHERE p0_.produit_id = ? AND p0_.grade_id = ? AND s1_.is_disponible = 1 AND p0_.codeinterne = 0 ORDER BY p0_.id ASC LIMIT 1000
Parameters:
[
  "1243"
  25
]
7 0.16 ms
SELECT g0_.id AS id_0, g0_.nom AS nom_1, g0_.description AS description_2, g0_.rang AS rang_3 FROM grade g0_ WHERE g0_.rang = ?
Parameters:
[
  3
]
8 0.21 ms
SELECT p0_.id AS id_0, p0_.codeinterne AS codeinterne_1, p0_.produit_id AS produit_id_2, p0_.statut_piece_id AS statut_piece_id_3, p0_.grade_id AS grade_id_4, p0_.lot_id AS lot_id_5, p0_.emplacement_stock_id AS emplacement_stock_id_6, p0_.cart_id AS cart_id_7, p0_.devis_id AS devis_id_8 FROM piece_individuelle p0_ INNER JOIN statut_piece s1_ ON p0_.statut_piece_id = s1_.id WHERE p0_.produit_id = ? AND p0_.grade_id = ? AND s1_.is_disponible = 1 AND p0_.codeinterne = 0 ORDER BY p0_.id ASC LIMIT 1000
Parameters:
[
  "1243"
  23
]
9 0.13 ms
SELECT g0_.id AS id_0, g0_.nom AS nom_1, g0_.description AS description_2, g0_.rang AS rang_3 FROM grade g0_ WHERE g0_.rang = ?
Parameters:
[
  4
]
10 0.21 ms
SELECT p0_.id AS id_0, p0_.codeinterne AS codeinterne_1, p0_.produit_id AS produit_id_2, p0_.statut_piece_id AS statut_piece_id_3, p0_.grade_id AS grade_id_4, p0_.lot_id AS lot_id_5, p0_.emplacement_stock_id AS emplacement_stock_id_6, p0_.cart_id AS cart_id_7, p0_.devis_id AS devis_id_8 FROM piece_individuelle p0_ INNER JOIN statut_piece s1_ ON p0_.statut_piece_id = s1_.id WHERE p0_.produit_id = ? AND p0_.grade_id = ? AND s1_.is_disponible = 1 AND p0_.codeinterne = 0 ORDER BY p0_.id ASC LIMIT 1000
Parameters:
[
  "1243"
  24
]
11 0.10 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.float_val AS float_val_2, s0_.string_val AS string_val_3, s0_.text_val AS text_val_4 FROM site_param s0_ WHERE s0_.name = ?
Parameters:
[
  "backgroundColor"
]
12 0.09 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.float_val AS float_val_2, s0_.string_val AS string_val_3, s0_.text_val AS text_val_4 FROM site_param s0_ WHERE s0_.name = ?
Parameters:
[
  "backgroundColorAlpha"
]
13 0.09 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.float_val AS float_val_2, s0_.string_val AS string_val_3, s0_.text_val AS text_val_4 FROM site_param s0_ WHERE s0_.name = ?
Parameters:
[
  "titleColor"
]
14 0.09 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.float_val AS float_val_2, s0_.string_val AS string_val_3, s0_.text_val AS text_val_4 FROM site_param s0_ WHERE s0_.name = ?
Parameters:
[
  "titleColorAlpha"
]
15 0.09 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.float_val AS float_val_2, s0_.string_val AS string_val_3, s0_.text_val AS text_val_4 FROM site_param s0_ WHERE s0_.name = ?
Parameters:
[
  "accentColor"
]
16 0.09 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.float_val AS float_val_2, s0_.string_val AS string_val_3, s0_.text_val AS text_val_4 FROM site_param s0_ WHERE s0_.name = ?
Parameters:
[
  "accentColorAlpha"
]
17 0.09 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.float_val AS float_val_2, s0_.string_val AS string_val_3, s0_.text_val AS text_val_4 FROM site_param s0_ WHERE s0_.name = ?
Parameters:
[
  "fontFamily"
]
18 0.05 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.float_val AS float_val_2, s0_.string_val AS string_val_3, s0_.text_val AS text_val_4 FROM site_param s0_ WHERE s0_.name = ?
Parameters:
[
  "fontFamilyMenu"
]
19 0.04 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.float_val AS float_val_2, s0_.string_val AS string_val_3, s0_.text_val AS text_val_4 FROM site_param s0_ WHERE s0_.name = ?
Parameters:
[
  "logoPrincipal"
]
20 0.04 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.float_val AS float_val_2, s0_.string_val AS string_val_3, s0_.text_val AS text_val_4 FROM site_param s0_ WHERE s0_.name = ?
Parameters:
[
  "logoSecondaire"
]
21 0.09 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.is_creable AS is_creable_4, t0.is_in_filter AS is_in_filter_5, t0.rang AS rang_6, t0.parent_id AS parent_id_7 FROM categorie_produits t0 WHERE t0.id = ?
Parameters:
[
  32
]
22 0.16 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM marque t0 WHERE t0.id = ?
Parameters:
[
  4
]
23 0.23 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.valeur AS valeur_4, t0.indispensable_on_create AS indispensable_on_create_5, t0.image AS image_6 FROM carac_techniques t0 INNER JOIN produit_carac_techniques ON t0.id = produit_carac_techniques.carac_techniques_id WHERE produit_carac_techniques.produit_id = ?
Parameters:
[
  1243
]
24 0.10 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.is_creable AS is_creable_4, t0.is_in_filter AS is_in_filter_5, t0.rang AS rang_6, t0.parent_id AS parent_id_7 FROM categorie_produits t0 INNER JOIN categorie_produits_carac_techniques ON t0.id = categorie_produits_carac_techniques.categorie_produits_id WHERE categorie_produits_carac_techniques.carac_techniques_id = ? ORDER BY t0.rang ASC
Parameters:
[
  166
]
25 0.11 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.is_creable AS is_creable_4, t0.is_in_filter AS is_in_filter_5, t0.rang AS rang_6, t0.parent_id AS parent_id_7 FROM categorie_produits t0 INNER JOIN categorie_produits_carac_techniques ON t0.id = categorie_produits_carac_techniques.categorie_produits_id WHERE categorie_produits_carac_techniques.carac_techniques_id = ? ORDER BY t0.rang ASC
Parameters:
[
  161
]
26 0.09 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.is_creable AS is_creable_4, t0.is_in_filter AS is_in_filter_5, t0.rang AS rang_6, t0.parent_id AS parent_id_7 FROM categorie_produits t0 INNER JOIN categorie_produits_carac_techniques ON t0.id = categorie_produits_carac_techniques.categorie_produits_id WHERE categorie_produits_carac_techniques.carac_techniques_id = ? ORDER BY t0.rang ASC
Parameters:
[
  257
]
27 0.09 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.is_creable AS is_creable_4, t0.is_in_filter AS is_in_filter_5, t0.rang AS rang_6, t0.parent_id AS parent_id_7 FROM categorie_produits t0 INNER JOIN categorie_produits_carac_techniques ON t0.id = categorie_produits_carac_techniques.categorie_produits_id WHERE categorie_produits_carac_techniques.carac_techniques_id = ? ORDER BY t0.rang ASC
Parameters:
[
  272
]
28 0.09 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.is_creable AS is_creable_4, t0.is_in_filter AS is_in_filter_5, t0.rang AS rang_6, t0.parent_id AS parent_id_7 FROM categorie_produits t0 INNER JOIN categorie_produits_carac_techniques ON t0.id = categorie_produits_carac_techniques.categorie_produits_id WHERE categorie_produits_carac_techniques.carac_techniques_id = ? ORDER BY t0.rang ASC
Parameters:
[
  313
]
29 0.21 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.is_creable AS is_creable_4, t0.is_in_filter AS is_in_filter_5, t0.rang AS rang_6, t0.parent_id AS parent_id_7 FROM categorie_produits t0 INNER JOIN categorie_produits_carac_techniques ON t0.id = categorie_produits_carac_techniques.categorie_produits_id WHERE categorie_produits_carac_techniques.carac_techniques_id = ? ORDER BY t0.rang ASC
Parameters:
[
  376
]
30 0.13 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.is_creable AS is_creable_4, t0.is_in_filter AS is_in_filter_5, t0.rang AS rang_6, t0.parent_id AS parent_id_7 FROM categorie_produits t0 INNER JOIN categorie_produits_carac_techniques ON t0.id = categorie_produits_carac_techniques.categorie_produits_id WHERE categorie_produits_carac_techniques.carac_techniques_id = ? ORDER BY t0.rang ASC
Parameters:
[
  380
]
31 0.11 ms
SELECT t0.id AS id_1, t0.codeinterne AS codeinterne_2, t0.produit_id AS produit_id_3, t0.statut_piece_id AS statut_piece_id_4, t0.grade_id AS grade_id_5, t0.lot_id AS lot_id_6, t0.emplacement_stock_id AS emplacement_stock_id_7, t0.cart_id AS cart_id_8, t0.devis_id AS devis_id_9 FROM piece_individuelle t0 WHERE t0.produit_id = ?
Parameters:
[
  1243
]

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\Produit No errors.
App\Entity\CategorieProduits No errors.
App\Entity\Marque No errors.
App\Entity\CaracTechniques No errors.
App\Entity\CaracPhysiques No errors.
App\Entity\PieceIndividuelle No errors.
App\Entity\ProduitGradePrix No errors.
App\Entity\Grade No errors.
App\Entity\StatutPiece No errors.
App\Entity\Lot No errors.
App\Entity\EmplacementStock No errors.
App\Entity\Cart No errors.
App\Entity\Devis No errors.
App\Entity\EntreeRepertoire No errors.
App\Entity\JournalEntreePiece
  • The mappings App\Entity\JournalEntreePiece#responsable and App\Entity\User#journalEntreePieces are inconsistent with each other.
App\Entity\JournalSortie No errors.
App\Entity\Commande
  • The mappings App\Entity\Commande#adresseLivraison and App\Entity\Adresse#commandes are inconsistent with each other.
App\Entity\SiteParam No errors.