GET https://point-pneus.fr/boutique/41?type_categorie=Manutention

Query Metrics

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

Queries

Group similar statements

# Time Info
1 22.00 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"
  "Manutention"
]
2 18.57 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"
  "Manutention"
]
3 25.84 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"
  "Manutention"
]
4 21.68 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"
  "Manutention"
]
5 24.39 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"
  "Manutention"
]
6 24.80 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 1200
Parameters:
[
  "PNEUS NEUFS"
  "Manutention"
]
7 0.85 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"
  "Manutention"
  "0006782778"
  "0006855186"
  "0006855187"
  "0006855188"
  "0006855189"
  "0006855190"
  "0006855192"
  "0006855193"
  "0006855194"
  "0006855196"
  "0006855197"
  "0006867400"
  "0006867401"
  "0006879730"
  "0006879809"
  "0006933043"
  "0006933044"
  "0006952711"
  "0006952712"
  "0006952713"
  "0006952714"
  "0006963665"
]

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.