7
0.86 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 "
"Poids Lourds "
"0005885656 "
"0005885658 "
"0005885659 "
"0005885660 "
"0005885661 "
"0005885662 "
"0005885663 "
"0005885664 "
"0005885665 "
"0005885667 "
"0005885669 "
"0005885671 "
"0005885672 "
"0005885673 "
"0005885674 "
"0005885676 "
"0005885678 "
"0005885941 "
"0005885942 "
"0005885943 "
"0005885944 "
"0005886814 "
"0005889586 "
"0005890921 "
"0005890922 "
"0005937616 "
"0005940373 "
"0005940371 "
"0005937617 "
"0005940374 "
]
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
Copy
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 = 'Poids Lourds' AND p0_ . id IN ('0005885656' , '0005885658' , '0005885659' , '0005885660' , '0005885661' , '0005885662' , '0005885663' , '0005885664' , '0005885665' , '0005885667' , '0005885669' , '0005885671' , '0005885672' , '0005885673' , '0005885674' , '0005885676' , '0005885678' , '0005885941' , '0005885942' , '0005885943' , '0005885944' , '0005886814' , '0005889586' , '0005890921' , '0005890922' , '0005937616' , '0005940373' , '0005940371' , '0005937617' , '0005940374' ) ORDER BY p0_ . stock DESC ;
Copy