7
0.81 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 "
"Deux Roues "
"0005741739 "
"0005741738 "
"0005741737 "
"0005741730 "
"0005741727 "
"0005741725 "
"0005741724 "
"0005741723 "
"0005741722 "
"0005741721 "
"0005741720 "
"0005741719 "
"0005741718 "
"0005741717 "
"0005741716 "
"0005741715 "
"0005741714 "
"0005741713 "
"0005741712 "
"0005741711 "
"0005741710 "
"0005741709 "
"0005741708 "
"0005741707 "
"0005741706 "
"0005741705 "
"0005741704 "
"0005741703 "
"0005741679 "
"0005741680 "
]
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 = 'Deux Roues' AND p0_ . id IN ('0005741739' , '0005741738' , '0005741737' , '0005741730' , '0005741727' , '0005741725' , '0005741724' , '0005741723' , '0005741722' , '0005741721' , '0005741720' , '0005741719' , '0005741718' , '0005741717' , '0005741716' , '0005741715' , '0005741714' , '0005741713' , '0005741712' , '0005741711' , '0005741710' , '0005741709' , '0005741708' , '0005741707' , '0005741706' , '0005741705' , '0005741704' , '0005741703' , '0005741679' , '0005741680' ) ORDER BY p0_ . stock DESC ;
Copy