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 "
"Deux Roues "
"0006771170 "
"0006771169 "
"0006771168 "
"0006771167 "
"0006771166 "
"0006771165 "
"0006771164 "
"0006771163 "
"0006769745 "
"0006769744 "
"0006769743 "
"0006769742 "
"0006769741 "
"0006769740 "
"0006769739 "
"0006769738 "
"0006769737 "
"0006769736 "
"0006762530 "
"0006762529 "
"0006762528 "
"0006762314 "
"0006761590 "
"0006745315 "
"0006745314 "
"0006745313 "
"0006627734 "
"0006627679 "
"0006627680 "
"0006627733 "
]
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 ('0006771170' , '0006771169' , '0006771168' , '0006771167' , '0006771166' , '0006771165' , '0006771164' , '0006771163' , '0006769745' , '0006769744' , '0006769743' , '0006769742' , '0006769741' , '0006769740' , '0006769739' , '0006769738' , '0006769737' , '0006769736' , '0006762530' , '0006762529' , '0006762528' , '0006762314' , '0006761590' , '0006745315' , '0006745314' , '0006745313' , '0006627734' , '0006627679' , '0006627680' , '0006627733' ) ORDER BY p0_ . stock DESC ;
Copy