7
0.90 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 "
"0006677107 "
"0006686415 "
"0006694572 "
"0006698519 "
"0006698520 "
"0006739061 "
"0006740454 "
"0006740455 "
"0006740456 "
"0006740457 "
"0006740458 "
"0006740459 "
"0006740460 "
"0006741581 "
"0006745312 "
"0006745313 "
"0006745314 "
"0006745315 "
"0006761590 "
"0006762314 "
"0006762528 "
"0006762529 "
"0006762530 "
"0006769736 "
"0006769737 "
"0006769738 "
"0006769739 "
"0006769740 "
"0006769741 "
"0006769742 "
]
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 ('0006677107' , '0006686415' , '0006694572' , '0006698519' , '0006698520' , '0006739061' , '0006740454' , '0006740455' , '0006740456' , '0006740457' , '0006740458' , '0006740459' , '0006740460' , '0006741581' , '0006745312' , '0006745313' , '0006745314' , '0006745315' , '0006761590' , '0006762314' , '0006762528' , '0006762529' , '0006762530' , '0006769736' , '0006769737' , '0006769738' , '0006769739' , '0006769740' , '0006769741' , '0006769742' ) ORDER BY p0_ . stock DESC ;
Copy