| 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` = '74itqua6faq3pkmu206kj43tg2bq1jfg'
AND `c`.`shops_id` = 1
ORDER BY `cart_id` ASC
|
| 0.0005 |
SELECT `a`.`artist_id` as `artists_id`, CONCAT(UCASE(LEFT(a.artist_name, 1)), LCASE(SUBSTRING(a.artist_name, 2))) as artists_name, `a`.`artist_url` as `artists_url`
FROM `artists` `a`
WHERE `a`.`artist_id` = 38
LIMIT 1
|
| 0.0071 |
SELECT `p`.`products_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
FROM `products` `p`
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
JOIN `manufacturers` `m` ON `m`.`manufacturers_id` = `p`.`manufacturers_id`
JOIN `categories_shops` `cs` ON `ptc`.`categories_id` = `cs`.`categories_id` AND `cs`.`shops_id` = 1
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
LEFT JOIN `products_artists` `pa` ON `pa`.`products_id` = `p`.`products_id`
LEFT JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
WHERE `p`.`products_status` = 1
AND `pa`.`artists_id` = 38
GROUP BY `p`.`products_id`
ORDER BY `p`.`products_date_available` DESC, `p`.`products_id` DESC
LIMIT 32
|
| 0.0003 |
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` = 1822
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0002 |
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` = 1822
ORDER BY `artists_name` ASC
|
| 0.0002 |
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` = 1822
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0001 |
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` = 1822
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0055 |
SELECT `p`.`products_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
FROM `products` `p`
JOIN `products_to_categories` `ptc` ON `ptc`.`products_id` = `p`.`products_id`
JOIN `manufacturers` `m` ON `m`.`manufacturers_id` = `p`.`manufacturers_id`
JOIN `categories_shops` `cs` ON `ptc`.`categories_id` = `cs`.`categories_id` AND `cs`.`shops_id` = 1
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
LEFT JOIN `products_artists` `pa` ON `pa`.`products_id` = `p`.`products_id`
LEFT JOIN `artists` `a` ON `a`.`artist_id` = `pa`.`artists_id`
LEFT JOIN `specials` `s` ON `p`.`products_id` = `s`.`products_id`
WHERE `p`.`products_status` = 1
AND `pa`.`artists_id` = 38
GROUP BY `p`.`products_id`
ORDER BY `p`.`products_date_available` DESC, `p`.`products_id` DESC
|
