| 0.0008 |
SELECT `c`.`cart_id`, `c`.`customers_id`, `c`.`session_id`, `c`.`products_name`, `c`.`products_id`, `c`.`is_free`, `c`.`is_virtual`, `c`.`qty`, `c`.`weight`, `c`.`tax`, `c`.`ht_price`, `c`.`final_price`, `c`.`options_id`, `c`.`options_values_id`, `c`.`is_gift`
FROM `cart` `c`
WHERE `c`.`session_id` = 'if1g7mb4v8pkhqk7vs7mktv1jk2dluum'
AND `c`.`shops_id` = 1
ORDER BY `cart_id` ASC
|
| 0.0010 |
SELECT `p`.`products_id`, `p`.`products_exclusive`, `p`.`products_selection`, `pd`.`products_description`, `p`.`products_image`, `p`.`products_image_2`, `p`.`products_tax_class_id`, `p`.`products_backinstock`, `p`.`products_date_added`, `p`.`products_date_available`, `pd`.`products_name`, `pd`.`products_url`, `ps`.`shops_id`, `m`.`manufacturers_id`, `m`.`manufacturers_name`, `m`.`manufacturers_url`, `p`.`style_id` as `styles_id`, `p`.`products_quantity`, `p`.`products_weight`, `st`.`style_name` as `styles_name`, `ptc`.`categories_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price, `p`.`products_status`
FROM `products` `p`
JOIN `products_description` `pd` ON `p`.`products_id` = `pd`.`products_id` AND `pd`.`language_id` = 2
JOIN `products_shops` `ps` ON `p`.`products_id` = `ps`.`products_id` AND `ps`.`shops_id` = 1
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
LEFT JOIN `manufacturers` `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
LEFT JOIN `styles` `st` ON `st`.`style_id` = `p`.`style_id`
WHERE `p`.`products_id` = 10140
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0007 |
SELECT `pa`.`artists_id`, `artist_name` as `artists_name`, `artist_url` as `artists_url`
FROM `products_artists` `pa`
JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
WHERE `pa`.`products_id` = 10140
ORDER BY `artists_name` ASC
|
| 0.0007 |
SELECT `pmt`.`products_mp3_tracks_id`, `pmt`.`products_id`, `pmt`.`filename`, `pmt`.`name`, `pmt`.`duration`, `pmt`.`duration_preview`, `pmt`.`bpm`, `pmt`.`waveform`, `pm`.`products_folder`
FROM `products_mp3_tracks` `pmt`
JOIN `products_mp3` `pm` ON `pm`.`products_id` = `pmt`.`products_id`
WHERE `pmt`.`products_id` = 10140
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0006 |
SELECT distinct popt.products_options_id, popt.products_options_name, popt.products_options_track_stock
FROM `products_options` `popt`
JOIN `products_attributes` `patrib` ON `patrib`.`options_id` = `popt`.`products_options_id` AND `popt`.`language_id` = 2
WHERE `patrib`.`products_id` = 10140
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0034 |
select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p, products_shops ps where opa.products_id = '10140' and opa.orders_id = opb.orders_id and opb.products_id != '10140' and ps.products_id = p.products_id and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' and ps.shops_id = 1 and p.products_status = '1' and p.products_quantity >= 1 group by p.products_id order by o.date_purchased desc limit 24
|
| 0.0005 |
select map.products_id from products map, products_to_categories ptc, products_shops ps WHERE map.products_id!= '10140' AND map.manufacturers_id='1864' AND map.products_status='1' and map.products_quantity >= 1 AND map.products_id = ptc.products_id AND ps.products_id = ptc.products_id AND ps.shops_id = 1 order by map.products_id desc limit 24
|
| 0.0011 |
select distinct(pa.products_id) from products_artists pa join products p on p.products_id = pa.products_id join products_shops ps on p.products_id = ps.products_id where p.products_status = '1' and p.products_quantity >= 1 and pa.products_id != '10140' and ps.shops_id = 1 and pa.artists_id IN (541,4941,3733,1804,5273) limit 24
|
