| 0.0003 |
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` = 'ud63hfk5sjsg969n2bpetpor0cgk6iv2'
AND `c`.`shops_id` = 1
ORDER BY `cart_id` ASC
|
| 0.0487 |
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_to_categories` `ptc`
JOIN `categories` `c` ON `c`.`categories_id` = `ptc`.`categories_id`
JOIN `categories_shops` `cs` ON `c`.`categories_id` = `cs`.`categories_id` AND `cs`.`shops_id` = 1
JOIN `products` `p` ON `p`.`products_id` = `ptc`.`products_id`
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 `ptc`.`categories_id` = 5
GROUP BY `p`.`products_id`
ORDER BY `p`.`products_date_available` DESC, `p`.`products_id` DESC
LIMIT 1664, 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` = 2479
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` = 2479
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` = 2479
AND (`pm`.`products_folder` != '' AND `pm`.`products_folder` IS NOT NULL)
ORDER BY `name` ASC
|
| 0.0002 |
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` = 2479
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
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` = 2473
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` = 2473
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` = 2473
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` = 2473
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
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` = 1316
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
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` = 1316
ORDER BY `artists_name` ASC
|
| 0.0001 |
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` = 1316
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` = 1316
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0001 |
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` = 2430
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
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` = 2430
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` = 2430
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` = 2430
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
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` = 2428
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
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` = 2428
ORDER BY `artists_name` ASC
|
| 0.0001 |
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` = 2428
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` = 2428
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
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` = 2425
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
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` = 2425
ORDER BY `artists_name` ASC
|
| 0.0001 |
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` = 2425
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` = 2425
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0002 |
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` = 2406
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
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` = 2406
ORDER BY `artists_name` ASC
|
| 0.0001 |
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` = 2406
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` = 2406
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0001 |
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` = 2402
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
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` = 2402
ORDER BY `artists_name` ASC
|
| 0.0001 |
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` = 2402
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` = 2402
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0001 |
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` = 2367
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
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` = 2367
ORDER BY `artists_name` ASC
|
| 0.0001 |
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` = 2367
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` = 2367
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0001 |
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` = 2365
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
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` = 2365
ORDER BY `artists_name` ASC
|
| 0.0001 |
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` = 2365
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` = 2365
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0001 |
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` = 2359
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
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` = 2359
ORDER BY `artists_name` ASC
|
| 0.0001 |
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` = 2359
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` = 2359
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0001 |
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` = 2339
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
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` = 2339
ORDER BY `artists_name` ASC
|
| 0.0001 |
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` = 2339
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` = 2339
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0001 |
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` = 2337
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
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` = 2337
ORDER BY `artists_name` ASC
|
| 0.0001 |
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` = 2337
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` = 2337
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0001 |
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` = 2336
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
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` = 2336
ORDER BY `artists_name` ASC
|
| 0.0001 |
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` = 2336
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` = 2336
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0001 |
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` = 2335
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
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` = 2335
ORDER BY `artists_name` ASC
|
| 0.0001 |
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` = 2335
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` = 2335
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0001 |
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` = 2328
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
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` = 2328
ORDER BY `artists_name` ASC
|
| 0.0001 |
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` = 2328
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` = 2328
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0001 |
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` = 2324
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
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` = 2324
ORDER BY `artists_name` ASC
|
| 0.0001 |
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` = 2324
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` = 2324
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0001 |
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` = 2317
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
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` = 2317
ORDER BY `artists_name` ASC
|
| 0.0001 |
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` = 2317
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` = 2317
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0001 |
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` = 2278
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
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` = 2278
ORDER BY `artists_name` ASC
|
| 0.0001 |
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` = 2278
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` = 2278
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0001 |
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` = 1792
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
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` = 1792
ORDER BY `artists_name` ASC
|
| 0.0001 |
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` = 1792
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` = 1792
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0001 |
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` = 2291
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
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` = 2291
ORDER BY `artists_name` ASC
|
| 0.0001 |
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` = 2291
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` = 2291
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0001 |
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` = 2286
GROUP BY `p`.`products_id`
LIMIT 1
|
| 0.0001 |
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` = 2286
ORDER BY `artists_name` ASC
|
| 0.0001 |
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` = 2286
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` = 2286
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0291 |
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_to_categories` `ptc`
JOIN `categories` `c` ON `c`.`categories_id` = `ptc`.`categories_id`
JOIN `categories_shops` `cs` ON `c`.`categories_id` = `cs`.`categories_id` AND `cs`.`shops_id` = 1
JOIN `products` `p` ON `p`.`products_id` = `ptc`.`products_id`
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 `ptc`.`categories_id` = 5
GROUP BY `p`.`products_id`
ORDER BY `p`.`products_date_available` DESC, `p`.`products_id` DESC
|
