Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation 7
• Security
• Twig
• HTTP Client
• Doctrine 3
• Debug
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

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 = ?

[
  "PNEUS NEUFS"
  "Tourisme"
]

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 = ?

SELECT COUNT(p0_.tubless) AS sclr_0 FROM pneus p0_ WHERE p0_.tubless = 1 AND p0_.libelle_famille = 'PNEUS NEUFS' AND p0_.prix_ttc > 1 AND p0_.type_categorie = 'Tourisme';

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 = ?

[
  "PNEUS NEUFS"
  "Tourisme"
]

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 = ?

SELECT COUNT(p0_.runflat) AS sclr_0 FROM pneus p0_ WHERE p0_.runflat = 1 AND p0_.libelle_famille = 'PNEUS NEUFS' AND p0_.prix_ttc > 1 AND p0_.type_categorie = 'Tourisme';

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

[
  "PNEUS NEUFS"
  "Tourisme"
]

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

SELECT p0_.libelle_marque AS libelle_marque_0, COUNT(p0_.libelle_marque) AS sclr_1 FROM pneus p0_ WHERE p0_.libelle_famille = 'PNEUS NEUFS' AND p0_.prix_ttc > 1 AND p0_.type_categorie = 'Tourisme' GROUP BY p0_.libelle_marque ORDER BY p0_.libelle_marque ASC;

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 = ?

[
  "PNEUS NEUFS"
  "Tourisme"
]

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 = ?

SELECT MIN(p0_.prix_ttc) AS sclr_0, MAX(p0_.prix_ttc) AS sclr_1 FROM pneus p0_ WHERE p0_.libelle_famille = 'PNEUS NEUFS' AND p0_.prix_ttc > 1 AND p0_.type_categorie = 'Tourisme';

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM pneus p0_ WHERE p0_.libelle_famille = ? AND p0_.prix_ttc > 1 AND p0_.type_categorie = ?

[
  "PNEUS NEUFS"
  "Tourisme"
]

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  pneus p0_
WHERE
  p0_.libelle_famille = ?
  AND p0_.prix_ttc > 1
  AND p0_.type_categorie = ?

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM pneus p0_ WHERE p0_.libelle_famille = 'PNEUS NEUFS' AND p0_.prix_ttc > 1 AND p0_.type_categorie = 'Tourisme';

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 15000

[
  "PNEUS NEUFS"
  "Tourisme"
]

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 15000

SELECT DISTINCT p0_.id AS id_0, p0_.stock AS stock_1 FROM pneus p0_ WHERE p0_.libelle_famille = 'PNEUS NEUFS' AND p0_.prix_ttc > 1 AND p0_.type_categorie = 'Tourisme' ORDER BY p0_.stock DESC LIMIT 30 OFFSET 15000;

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

[
  "PNEUS NEUFS"
  "Tourisme"
  "0005406692"
  "0005406693"
  "0005406696"
  "0005406697"
  "0005406698"
  "0005406703"
  "0005406704"
  "0005407301"
  "0005407302"
  "0005410369"
  "0005410372"
  "0005410373"
  "0005410374"
  "0005410375"
  "0005410376"
  "0005410379"
  "0005410385"
  "0005410793"
  "0005410883"
  "0005410884"
  "0005410886"
  "0005413352"
  "0005413353"
  "0005413354"
  "0005413355"
  "0005413433"
  "0005415789"
  "0005415795"
  "0005415815"
  "0005416329"
]

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

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 = 'PNEUS NEUFS' AND p0_.prix_ttc > 1 AND p0_.type_categorie = 'Tourisme' AND p0_.id IN ('0005406692', '0005406693', '0005406696', '0005406697', '0005406698', '0005406703', '0005406704', '0005407301', '0005407302', '0005410369', '0005410372', '0005410373', '0005410374', '0005410375', '0005410376', '0005410379', '0005410385', '0005410793', '0005410883', '0005410884', '0005410886', '0005413352', '0005413353', '0005413354', '0005413355', '0005413433', '0005415789', '0005415795', '0005415815', '0005416329') ORDER BY p0_.stock DESC;