| 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.0531 |
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 1696, 32
|
| 0.0004 |
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` = 2189
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` = 2189
ORDER BY `artists_name` ASC
|
| 0.0004 |
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` = 2189
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` = 2189
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` = 2174
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` = 2174
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` = 2174
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` = 2174
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` = 2171
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` = 2171
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` = 2171
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` = 2171
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` = 2158
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` = 2158
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` = 2158
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` = 2158
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` = 2153
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` = 2153
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` = 2153
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` = 2153
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` = 2147
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` = 2147
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` = 2147
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` = 2147
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` = 2146
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` = 2146
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` = 2146
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` = 2146
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` = 2134
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` = 2134
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` = 2134
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` = 2134
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` = 2124
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` = 2124
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` = 2124
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` = 2124
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` = 2047
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` = 2047
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` = 2047
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` = 2047
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` = 2046
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` = 2046
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` = 2046
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` = 2046
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` = 2045
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` = 2045
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` = 2045
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` = 2045
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` = 2044
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` = 2044
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` = 2044
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` = 2044
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` = 2042
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` = 2042
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` = 2042
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` = 2042
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` = 2040
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` = 2040
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` = 2040
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` = 2040
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` = 2039
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` = 2039
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` = 2039
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` = 2039
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` = 2038
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` = 2038
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` = 2038
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` = 2038
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` = 2036
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` = 2036
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` = 2036
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` = 2036
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` = 2030
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` = 2030
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` = 2030
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` = 2030
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` = 2027
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` = 2027
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` = 2027
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` = 2027
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` = 2023
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` = 2023
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` = 2023
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` = 2023
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` = 2010
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` = 2010
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` = 2010
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` = 2010
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` = 2009
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` = 2009
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` = 2009
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` = 2009
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` = 2007
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` = 2007
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` = 2007
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` = 2007
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` = 1999
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` = 1999
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` = 1999
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` = 1999
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` = 1991
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` = 1991
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` = 1991
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` = 1991
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` = 1990
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` = 1990
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` = 1990
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` = 1990
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` = 1988
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` = 1988
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` = 1988
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` = 1988
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` = 1979
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` = 1979
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` = 1979
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` = 1979
ORDER BY `patrib`.`products_options_sort_order` DESC
|
| 0.0284 |
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
|
