45 produit(s)
  • (7.8810ms) SELECT * FROM parameter order by name asc
  • (1.6440ms) SELECT * FROM product_cat WHERE id=23 LIMIT 1
  • (1.4570ms) select v.id, v.name from product as p, product_vendor as v where p.productVendorId=v.id AND p.productCatId=23 group by productVendorId order by name ASC
  • (0.6240ms) select min(dimHeight) as min, max(dimHeight) as max from product WHERE dimHeight IS NOT NULL AND productCatId=23
  • (0.6260ms) select min(dimWidth) as min, max(dimWidth) as max from product WHERE dimWidth IS NOT NULL AND productCatId=23
  • (0.5980ms) select min(dimDepth) as min, max(dimDepth) as max from product WHERE dimDepth IS NOT NULL AND productCatId=23
  • (0.5920ms) select count(id) as c FROM product WHERE isCustom=1 AND productCatId=23
  • (0.8660ms) select * from product_cat WHERE parentId=23 AND isAvailable=1 ORDER BY position ASC, name DESC
  • (0.5850ms) SELECT * FROM article WHERE code='PRODUCT_LIST' LIMIT 1
  • (0.5430ms) select count(*) as counter from product WHERE productCatId=23 AND isAvailable=1 ORDER BY id desc
  • (3.0630ms) select * from product WHERE productCatId=23 AND isAvailable=1 ORDER BY position ASC, name DESC LIMIT 0,100
  • (0.7430ms) SELECT * FROM product_cat WHERE id=23 LIMIT 1
  • (0.7320ms) SELECT * FROM product_cat WHERE id=16 LIMIT 1
  • (0.5740ms) select * from menu WHERE type!='I' AND parentId=1 ORDER BY position ASC
  • (0.4950ms) select * from menu WHERE type!='I' AND parentId=27 ORDER BY position ASC
  • (0.5310ms) select * from menu WHERE type!='I' AND parentId=11 ORDER BY position ASC
  • (0.5950ms) select * from menu WHERE type!='I' AND parentId=2 ORDER BY position ASC
  • (0.6130ms) select * from menu WHERE type!='I' AND parentId=3 ORDER BY position ASC
  • (0.6360ms) select * from menu WHERE type!='I' AND parentId=4 ORDER BY position ASC
  • (0.8620ms) SELECT * FROM article WHERE code='FOOTER_TEXT' LIMIT 1