7
0.82 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 "
"0005083476 "
"0005083477 "
"0005083478 "
"0005083479 "
"0005083480 "
"0005083481 "
"0005083482 "
"0005083487 "
"0005083497 "
"0005083499 "
"0005083501 "
"0005083502 "
"0005083503 "
"0005083504 "
"0005083506 "
"0005083507 "
"0005083864 "
"0005083865 "
"0005084616 "
"0005084617 "
"0005084618 "
"0005084657 "
"0005084665 "
"0005084664 "
"0005084663 "
"0005084662 "
"0005084661 "
"0005084659 "
"0005084658 "
"0005084652 "
]
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 ('0005083476' , '0005083477' , '0005083478' , '0005083479' , '0005083480' , '0005083481' , '0005083482' , '0005083487' , '0005083497' , '0005083499' , '0005083501' , '0005083502' , '0005083503' , '0005083504' , '0005083506' , '0005083507' , '0005083864' , '0005083865' , '0005084616' , '0005084617' , '0005084618' , '0005084657' , '0005084665' , '0005084664' , '0005084663' , '0005084662' , '0005084661' , '0005084659' , '0005084658' , '0005084652' ) ORDER BY p0_ . stock DESC ;
Copy