Temps de génération: 0.10730910301208 Nombre requete SQL: 3
0 | 1 | |
---|---|---|
0 | SELECT fk_promo FROM netlegis.caddie WHERE idx_caddie = :id | 0.00063800811767578 |
1 | SELECT *, IF(cp.qte > 1 AND (SELECT COUNT(*) FROM netlegis.produit_prix pp WH... | 0.0018351078033447 |
2 | SELECT t.*, tag.label as tag, tag.url as tag_slug, "legisocial" as site FROM ... | 0.00098919868469238 |
SELECT *, IF(cp.qte > 1 AND (SELECT COUNT(*) FROM netlegis.produit_prix pp WHERE pp.fk_produit = p.idx_produit), (SELECT pp.prix_ht FROM netlegis.produit_prix pp WHERE cp.qte >= pp.qte AND pp.fk_produit = p.idx_produit ORDER BY pp.qte DESC LIMIT 1), p.prix_ht) as prix_ht, p.pack FROM netlegis.caddie_produit cp INNER JOIN netlegis.produit p ON p.idx_produit = cp.fk_produit WHERE cp.fk_caddie = :idx_caddie
SELECT t.*, tag.label as tag, tag.url as tag_slug, "legisocial" as site FROM legisocial.outil_urgence t LEFT JOIN cms_tag tag ON t.tag_id = tag.id WHERE t.id = :id