GET http://5.250.181.167/boutique/27?type_categorie=G%C3%A9nie%20Civil

Query Metrics

7 Database Queries
7 Different statements
134.68 ms Query time
4 Invalid entities

Queries

Group similar statements

# Time Info
1 20.99 ms
SELECT COUNT(p0_.tubless) AS sclr_0 FROM pneus p0_ WHERE p0_.tubless = 1 AND p0_.libelle_famille = ? AND p0_.prix_ttc > 1 AND p0_.type_categorie = ?
Parameters:
[
  "PNEUS NEUFS"
  "Génie Civil"
]
2 17.79 ms
SELECT COUNT(p0_.runflat) AS sclr_0 FROM pneus p0_ WHERE p0_.runflat = 1 AND p0_.libelle_famille = ? AND p0_.prix_ttc > 1 AND p0_.type_categorie = ?
Parameters:
[
  "PNEUS NEUFS"
  "Génie Civil"
]
3 24.75 ms
SELECT p0_.libelle_marque AS libelle_marque_0, COUNT(p0_.libelle_marque) AS sclr_1 FROM pneus p0_ WHERE p0_.libelle_famille = ? AND p0_.prix_ttc > 1 AND p0_.type_categorie = ? GROUP BY p0_.libelle_marque ORDER BY p0_.libelle_marque ASC
Parameters:
[
  "PNEUS NEUFS"
  "Génie Civil"
]
4 21.86 ms
SELECT MIN(p0_.prix_ttc) AS sclr_0, MAX(p0_.prix_ttc) AS sclr_1 FROM pneus p0_ WHERE p0_.libelle_famille = ? AND p0_.prix_ttc > 1 AND p0_.type_categorie = ?
Parameters:
[
  "PNEUS NEUFS"
  "Génie Civil"
]
5 23.90 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM pneus p0_ WHERE p0_.libelle_famille = ? AND p0_.prix_ttc > 1 AND p0_.type_categorie = ?
Parameters:
[
  "PNEUS NEUFS"
  "Génie Civil"
]
6 24.53 ms
SELECT DISTINCT p0_.id AS id_0, p0_.stock AS stock_1 FROM pneus p0_ WHERE p0_.libelle_famille = ? AND p0_.prix_ttc > 1 AND p0_.type_categorie = ? ORDER BY p0_.stock DESC LIMIT 30 OFFSET 780
Parameters:
[
  "PNEUS NEUFS"
  "Génie Civil"
]
7 0.87 ms
SELECT p0_.id AS id_0, p0_.marque AS marque_1, p0_.famille AS famille_2, p0_.categorie AS categorie_3, p0_.code_manuf AS code_manuf_4, p0_.code_ean AS code_ean_5, p0_.libelle_categorie AS libelle_categorie_6, p0_.libelle_marque AS libelle_marque_7, p0_.libelle_famille AS libelle_famille_8, p0_.libelle AS libelle_9, p0_.profil AS profil_10, p0_.url_profil AS url_profil_11, p0_.type_categorie AS type_categorie_12, p0_.largeur AS largeur_13, p0_.serie AS serie_14, p0_.structure AS structure_15, p0_.diametre AS diametre_16, p0_.indice_charge AS indice_charge_17, p0_.indice_vitesse AS indice_vitesse_18, p0_.tubless AS tubless_19, p0_.renfort AS renfort_20, p0_.runflat AS runflat_21, p0_.consommation AS consommation_22, p0_.freinage AS freinage_23, p0_.nb_decibels AS nb_decibels_24, p0_.bruit AS bruit_25, p0_.classe_pneu AS classe_pneu_26, p0_.prix_ht AS prix_ht_27, p0_.prix_ttc AS prix_ttc_28, p0_.hauteur_pneus AS hauteur_pneus_29, p0_.gam AS gam_30, p0_.saison AS saison_31, p0_.toutes_saisons AS toutes_saisons_32, p0_.promo AS promo_33, p0_.stock AS stock_34 FROM pneus p0_ WHERE p0_.libelle_famille = ? AND p0_.prix_ttc > 1 AND p0_.type_categorie = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.stock DESC
Parameters:
[
  "PNEUS NEUFS"
  "Génie Civil"
  "0006957835"
  "0006957836"
  "0006957837"
  "0006957838"
  "0006957839"
  "0006957840"
  "0006957841"
  "0006957842"
  "0006957843"
  "0006957844"
  "0006957845"
  "0006957846"
  "0006957847"
  "0006957848"
  "0006957849"
  "0006957850"
  "0006957851"
  "0006957852"
  "0006957853"
  "0006957854"
  "0006957855"
  "0006957856"
  "0006957969"
]

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\Pneus
  • The association App\Entity\Pneus#commandeProduits refers to the owning side field App\Entity\CommandeProduit#id_Produit which does not exist.
App\Entity\CommandePresta
  • The mappings App\Entity\CommandePresta#id_commande and App\Entity\Commande#commandePrestas are inconsistent with each other.
App\Entity\CommandeProduit
  • The mappings App\Entity\CommandeProduit#id_produit and App\Entity\Pneus#commandeProduits are inconsistent with each other.
  • The mappings App\Entity\CommandeProduit#id_commande and App\Entity\Commande#commandeProduits are inconsistent with each other.
App\Entity\Commande
  • The association App\Entity\Commande#commandePrestas refers to the owning side field App\Entity\CommandePresta#id_Commande which does not exist.
  • The association App\Entity\Commande#commandeProduits refers to the owning side field App\Entity\CommandeProduit#id_Commande which does not exist.
App\Entity\User No errors.
App\Entity\StatutCommande No errors.