| 0.0002 |
SELECT t1.*
FROM siteuri as t1
WHERE 1 AND LOWER(domeniu) = 'lanterne.ro'
|
| 0.0001 |
SELECT *
FROM (`languages`)
WHERE `afisat_front` = '1'
ORDER BY `order` ASC
|
| 0.0001 |
SELECT t1.*
FROM siteuri as t1
WHERE 1 AND LOWER(domeniu) = 'lanterne.ro'
|
| 0.0001 |
SELECT domeniu, site_id
FROM siteuri as t1
WHERE 1
|
| 0.0000 |
SELECT domeniu
FROM siteuri as t1
WHERE 1 AND site_id = 2
|
| 0.0001 |
SELECT t1.*
FROM siteuri as t1
WHERE 1 AND active = '1'
|
| 0.0001 |
SELECT t1.*
FROM themes as t1
WHERE 1 AND theme_id = 0
|
| 0.0001 |
SELECT t1.*
FROM discounts_site as t1
WHERE 1 AND active = '1' AND site_id = 1
|
| 0.0001 |
SELECT title, url_key, `order`, section, on_menu, top, bottom, t1.page_id
FROM pages as t1
LEFT JOIN pages_details as t2 ON t1.page_id = t2.page_id
WHERE 1 AND site_id = 1 AND lang_id = 1 AND active = '1'
ORDER BY `order` ASC
|
| 0.0001 |
SELECT t1.category_id, t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND lang_id = 1 AND active = '1' AND parent_id = 0
ORDER BY `order` ASC
|
| 0.0001 |
SELECT category_name, url_key, url_key_site_1, `order` , t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND lang_id = 1 AND active = '1'
AND parent_id IN (0,11,14,15,18,19)
ORDER BY `order` ASC
|
| 0.0031 |
SELECT t2.url_key, t2.title, t1.product_id, t3.filename, category_id
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
LEFT JOIN products_images as t3 ON t1.product_id = t3.product_id
WHERE 1 AND t1.active = '1' AND removed = '0'
AND lang_id = '1'
AND set_new = '1' AND DATE_ADD(set_new_date, INTERVAL 60 DAY) >= DATE(NOW())
GROUP BY t1.product_id
ORDER BY set_new_date DESC LIMIT 0,7
|
| 0.0001 |
SELECT value FROM _useful_data WHERE name = 'bestselled_ids'
|
| 0.0036 |
SELECT t2.url_key, t2.title, t1.product_id, t3.filename, category_id
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
LEFT JOIN products_images as t3 ON t1.product_id = t3.product_id
WHERE 1 AND t1.active = '1' AND removed = '0'
AND lang_id = '1'
AND t1.product_id IN ( 228,25,358,578,574,429,674,849,1046,629,469,711,599,233,793,698,431,405,144,106,760,191,553,153,71,751,31,466,361,424,940,506,652,647,713,631,792,762,208,417,635,609,580,505,795,450,498,739,41,743,979,185,728,349,141,618,507,367,434,794,97,372,560,595,766,318,767,999,514,704,1085,719,712,291,832,1043,911,781,646,893,257,296,729,763,437,193,377,76,619,625,454,714,460,504,517,465,639,1149,834,1054 )
GROUP BY t1.product_id
ORDER BY FIELD(t1.product_id, 228,25,358,578,574,429,674,849,1046,629,469,711,599,233,793,698,431,405,144,106,760,191,553,153,71,751,31,466,361,424,940,506,652,647,713,631,792,762,208,417,635,609,580,505,795,450,498,739,41,743,979,185,728,349,141,618,507,367,434,794,97,372,560,595,766,318,767,999,514,704,1085,719,712,291,832,1043,911,781,646,893,257,296,729,763,437,193,377,76,619,625,454,714,460,504,517,465,639,1149,834,1054) LIMIT 0,7
|
| 0.0004 |
SELECT t1.*, t2.*
FROM categories_certificate as t1
LEFT JOIN categories_certificate_details as t2 ON t1.category_certificate_id = t2.category_certificate_id
WHERE 1 AND lang_id = 1 AND active = '1'
AND t1.category_certificate_id IN ( SELECT category_certificate_id as id1 FROM categories_certificate as c1
WHERE ( c1.parent_id = 0 OR c1.parent_id IN ( SELECT category_certificate_id as id FROM categories_certificate as c
WHERE c.parent_id = 0 )
)
)
ORDER BY `order` ASC
|
| 0.0001 |
SELECT partner_link_id, partner_link_type, partner_link_title, partner_link_url, partner_link_file, partner_link_script
FROM partner_links as t1
WHERE 1 AND active = '1' AND site_id = 1
ORDER BY `order` ASC
|
| 0.0001 |
SELECT t1.*
FROM anunturi as t1
WHERE 1 AND active = '1'
AND anunt_id IN (SELECT anunt_id FROM anunturi_site WHERE site_id = '1' )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY `order` DESC
|
| 0.0001 |
SELECT t1.*, t2.*
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND lang_id = 1 AND active = '1' AND t1.category_id = '18'
|
| 0.0001 |
SELECT * FROM categories_details WHERE 1 AND category_id = 18
AND lang_id = 1
AND site_id = 1
|
| 0.0001 |
SELECT parent_id
FROM categories
WHERE category_id = 18
|
| 0.0001 |
SELECT t2.category_id, category_name, url_key, url_key_site_1
FROM categories as t1
LEFT JOIN categories_details as t2
ON t1.category_id = t2.category_id
WHERE t1.category_id = 0 AND lang_id = 1
|
| 0.0001 |
SELECT category_name, url_key, url_key_site_1, `order` , t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND lang_id = 1 AND active = '1' AND t1.parent_id = '18'
|
| 0.0001 |
SELECT t2.category_id, category_name, url_key, url_key_site_1
FROM categories as t1
LEFT JOIN categories_details as t2
ON t1.category_id = t2.category_id
WHERE t1.parent_id = 18 AND lang_id = 1
|
| 0.0000 |
SELECT t2.category_id, category_name, url_key, url_key_site_1
FROM categories as t1
LEFT JOIN categories_details as t2
ON t1.category_id = t2.category_id
WHERE t1.parent_id = 2 AND lang_id = 1
|
| 0.0000 |
SELECT t2.category_id, category_name, url_key, url_key_site_1
FROM categories as t1
LEFT JOIN categories_details as t2
ON t1.category_id = t2.category_id
WHERE t1.parent_id = 12 AND lang_id = 1
|
| 0.0000 |
SELECT t2.category_id, category_name, url_key, url_key_site_1
FROM categories as t1
LEFT JOIN categories_details as t2
ON t1.category_id = t2.category_id
WHERE t1.parent_id = 13 AND lang_id = 1
|
| 0.0010 |
SELECT count(t1.product_id) as nr
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
WHERE 1 AND t1.active = '1' AND removed = '0'
AND lang_id = '1'
AND category_id IN (18,13,12,2)
|
| 0.0001 |
SELECT s.value
FROM settings as s
LEFT JOIN settings_details as sd ON s.setting_id = sd.setting_id
WHERE 1 AND name = 'currency'
|
| 0.0100 |
SELECT t1.*, t2.*, t3.filename
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
LEFT JOIN products_images as t3 ON t1.product_id = t3.product_id
WHERE 1 AND t1.active = '1' AND removed = '0'
AND lang_id = '1'
AND category_id IN (18,13,12,2)
GROUP BY t1.product_id
ORDER BY (IF(stock>0,1,0)) DESC, set_recomandat DESC, t1.product_id desc LIMIT 0,20
|
| 0.0001 |
SELECT t1.*
FROM messages_stoc_epuizat as t1
WHERE 1 AND message_stoc_epuizat_id = 1 AND active = '1'
|
| 0.0003 |
SELECT price, pret_achizitie, category_id, t1.product_id
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
WHERE 1 AND t1.product_id = '1289'
|
| 0.0005 |
SELECT t1.fara_discount , t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND t1.category_id = 12
LIMIT 0,1
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 1289 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT t1.*
FROM discounts_category as t1
WHERE 1 AND active = '1' AND category_id = 12
|
| 0.0001 |
SELECT t1.*
FROM products_quantity_offers as t1
WHERE 1 AND active = '1'
AND product_id = 1289
AND price < 35
ORDER BY quantity ASC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'produs_gratuit'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 1289 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 1289 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT round((sum(rating)/count(rating)),1) as rating, count(rating) as rating_counters
FROM products_comments as t1
WHERE 1 AND product_id = 1289
AND active = '1'
AND rating > 0
AND site_id = 1
|
| 0.0000 |
SELECT t1.*
FROM messages_stoc_epuizat as t1
WHERE 1 AND message_stoc_epuizat_id = 1 AND active = '1'
|
| 0.0002 |
SELECT price, pret_achizitie, category_id, t1.product_id
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
WHERE 1 AND t1.product_id = '1281'
|
| 0.0001 |
SELECT t1.fara_discount , t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND t1.category_id = 13
LIMIT 0,1
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 1281 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT t1.*
FROM discounts_category as t1
WHERE 1 AND active = '1' AND category_id = 13
|
| 0.0000 |
SELECT t1.*
FROM products_quantity_offers as t1
WHERE 1 AND active = '1'
AND product_id = 1281
AND price < 75
ORDER BY quantity ASC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'produs_gratuit'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 1281 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 1281 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT round((sum(rating)/count(rating)),1) as rating, count(rating) as rating_counters
FROM products_comments as t1
WHERE 1 AND product_id = 1281
AND active = '1'
AND rating > 0
AND site_id = 1
|
| 0.0000 |
SELECT t1.*
FROM messages_stoc_epuizat as t1
WHERE 1 AND message_stoc_epuizat_id = 1 AND active = '1'
|
| 0.0002 |
SELECT price, pret_achizitie, category_id, t1.product_id
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
WHERE 1 AND t1.product_id = '1221'
|
| 0.0001 |
SELECT t1.fara_discount , t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND t1.category_id = 12
LIMIT 0,1
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 1221 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT t1.*
FROM discounts_category as t1
WHERE 1 AND active = '1' AND category_id = 12
|
| 0.0000 |
SELECT t1.*
FROM products_quantity_offers as t1
WHERE 1 AND active = '1'
AND product_id = 1221
AND price < 30
ORDER BY quantity ASC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'produs_gratuit'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 1221 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 1221 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT round((sum(rating)/count(rating)),1) as rating, count(rating) as rating_counters
FROM products_comments as t1
WHERE 1 AND product_id = 1221
AND active = '1'
AND rating > 0
AND site_id = 1
|
| 0.0000 |
SELECT t1.*
FROM messages_stoc_epuizat as t1
WHERE 1 AND message_stoc_epuizat_id = 1 AND active = '1'
|
| 0.0002 |
SELECT price, pret_achizitie, category_id, t1.product_id
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
WHERE 1 AND t1.product_id = '1151'
|
| 0.0001 |
SELECT t1.fara_discount , t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND t1.category_id = 12
LIMIT 0,1
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 1151 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT t1.*
FROM discounts_category as t1
WHERE 1 AND active = '1' AND category_id = 12
|
| 0.0001 |
SELECT t1.*
FROM products_quantity_offers as t1
WHERE 1 AND active = '1'
AND product_id = 1151
AND price < 30
ORDER BY quantity ASC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'produs_gratuit'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 1151 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 1151 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT round((sum(rating)/count(rating)),1) as rating, count(rating) as rating_counters
FROM products_comments as t1
WHERE 1 AND product_id = 1151
AND active = '1'
AND rating > 0
AND site_id = 1
|
| 0.0000 |
SELECT t1.*
FROM messages_stoc_epuizat as t1
WHERE 1 AND message_stoc_epuizat_id = 1 AND active = '1'
|
| 0.0002 |
SELECT price, pret_achizitie, category_id, t1.product_id
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
WHERE 1 AND t1.product_id = '1025'
|
| 0.0001 |
SELECT t1.fara_discount , t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND t1.category_id = 12
LIMIT 0,1
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 1025 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT t1.*
FROM discounts_category as t1
WHERE 1 AND active = '1' AND category_id = 12
|
| 0.0000 |
SELECT t1.*
FROM products_quantity_offers as t1
WHERE 1 AND active = '1'
AND product_id = 1025
AND price < 15
ORDER BY quantity ASC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'produs_gratuit'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 1025 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 1025 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT round((sum(rating)/count(rating)),1) as rating, count(rating) as rating_counters
FROM products_comments as t1
WHERE 1 AND product_id = 1025
AND active = '1'
AND rating > 0
AND site_id = 1
|
| 0.0000 |
SELECT t1.*
FROM messages_stoc_epuizat as t1
WHERE 1 AND message_stoc_epuizat_id = 1 AND active = '1'
|
| 0.0002 |
SELECT price, pret_achizitie, category_id, t1.product_id
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
WHERE 1 AND t1.product_id = '996'
|
| 0.0002 |
SELECT t1.fara_discount , t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND t1.category_id = 13
LIMIT 0,1
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 996 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT t1.*
FROM discounts_category as t1
WHERE 1 AND active = '1' AND category_id = 13
|
| 0.0000 |
SELECT t1.*
FROM products_quantity_offers as t1
WHERE 1 AND active = '1'
AND product_id = 996
AND price < 3
ORDER BY quantity ASC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'produs_gratuit'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 996 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 996 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT round((sum(rating)/count(rating)),1) as rating, count(rating) as rating_counters
FROM products_comments as t1
WHERE 1 AND product_id = 996
AND active = '1'
AND rating > 0
AND site_id = 1
|
| 0.0000 |
SELECT t1.*
FROM messages_stoc_epuizat as t1
WHERE 1 AND message_stoc_epuizat_id = 1 AND active = '1'
|
| 0.0002 |
SELECT price, pret_achizitie, category_id, t1.product_id
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
WHERE 1 AND t1.product_id = '936'
|
| 0.0001 |
SELECT t1.fara_discount , t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND t1.category_id = 13
LIMIT 0,1
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 936 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT t1.*
FROM discounts_category as t1
WHERE 1 AND active = '1' AND category_id = 13
|
| 0.0000 |
SELECT t1.*
FROM products_quantity_offers as t1
WHERE 1 AND active = '1'
AND product_id = 936
AND price < 8
ORDER BY quantity ASC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'produs_gratuit'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 936 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 936 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT round((sum(rating)/count(rating)),1) as rating, count(rating) as rating_counters
FROM products_comments as t1
WHERE 1 AND product_id = 936
AND active = '1'
AND rating > 0
AND site_id = 1
|
| 0.0000 |
SELECT t1.*
FROM messages_stoc_epuizat as t1
WHERE 1 AND message_stoc_epuizat_id = 1 AND active = '1'
|
| 0.0002 |
SELECT price, pret_achizitie, category_id, t1.product_id
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
WHERE 1 AND t1.product_id = '910'
|
| 0.0001 |
SELECT t1.fara_discount , t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND t1.category_id = 12
LIMIT 0,1
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 910 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT t1.*
FROM discounts_category as t1
WHERE 1 AND active = '1' AND category_id = 12
|
| 0.0001 |
SELECT t1.*
FROM products_quantity_offers as t1
WHERE 1 AND active = '1'
AND product_id = 910
AND price < 50
ORDER BY quantity ASC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'produs_gratuit'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 910 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 910 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT round((sum(rating)/count(rating)),1) as rating, count(rating) as rating_counters
FROM products_comments as t1
WHERE 1 AND product_id = 910
AND active = '1'
AND rating > 0
AND site_id = 1
|
| 0.0000 |
SELECT t1.*
FROM messages_stoc_epuizat as t1
WHERE 1 AND message_stoc_epuizat_id = 1 AND active = '1'
|
| 0.0002 |
SELECT price, pret_achizitie, category_id, t1.product_id
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
WHERE 1 AND t1.product_id = '727'
|
| 0.0001 |
SELECT t1.fara_discount , t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND t1.category_id = 12
LIMIT 0,1
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 727 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT t1.*
FROM discounts_category as t1
WHERE 1 AND active = '1' AND category_id = 12
|
| 0.0001 |
SELECT t1.*
FROM products_quantity_offers as t1
WHERE 1 AND active = '1'
AND product_id = 727
AND price < 20
ORDER BY quantity ASC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'produs_gratuit'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 727 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 727 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT round((sum(rating)/count(rating)),1) as rating, count(rating) as rating_counters
FROM products_comments as t1
WHERE 1 AND product_id = 727
AND active = '1'
AND rating > 0
AND site_id = 1
|
| 0.0000 |
SELECT t1.*
FROM messages_stoc_epuizat as t1
WHERE 1 AND message_stoc_epuizat_id = 1 AND active = '1'
|
| 0.0002 |
SELECT price, pret_achizitie, category_id, t1.product_id
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
WHERE 1 AND t1.product_id = '462'
|
| 0.0001 |
SELECT t1.fara_discount , t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND t1.category_id = 12
LIMIT 0,1
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 462 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT t1.*
FROM discounts_category as t1
WHERE 1 AND active = '1' AND category_id = 12
|
| 0.0001 |
SELECT t1.*
FROM products_quantity_offers as t1
WHERE 1 AND active = '1'
AND product_id = 462
AND price < 25
ORDER BY quantity ASC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'produs_gratuit'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 462 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 462 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT round((sum(rating)/count(rating)),1) as rating, count(rating) as rating_counters
FROM products_comments as t1
WHERE 1 AND product_id = 462
AND active = '1'
AND rating > 0
AND site_id = 1
|
| 0.0000 |
SELECT t1.*
FROM messages_stoc_epuizat as t1
WHERE 1 AND message_stoc_epuizat_id = 1 AND active = '1'
|
| 0.0002 |
SELECT price, pret_achizitie, category_id, t1.product_id
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
WHERE 1 AND t1.product_id = '460'
|
| 0.0001 |
SELECT t1.fara_discount , t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND t1.category_id = 12
LIMIT 0,1
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 460 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT t1.*
FROM discounts_category as t1
WHERE 1 AND active = '1' AND category_id = 12
|
| 0.0001 |
SELECT t1.*
FROM products_quantity_offers as t1
WHERE 1 AND active = '1'
AND product_id = 460
AND price < 25
ORDER BY quantity ASC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'produs_gratuit'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 460 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 460 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT round((sum(rating)/count(rating)),1) as rating, count(rating) as rating_counters
FROM products_comments as t1
WHERE 1 AND product_id = 460
AND active = '1'
AND rating > 0
AND site_id = 1
|
| 0.0000 |
SELECT t1.*
FROM messages_stoc_epuizat as t1
WHERE 1 AND message_stoc_epuizat_id = 1 AND active = '1'
|
| 0.0002 |
SELECT price, pret_achizitie, category_id, t1.product_id
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
WHERE 1 AND t1.product_id = '313'
|
| 0.0001 |
SELECT t1.fara_discount , t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND t1.category_id = 13
LIMIT 0,1
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 313 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT t1.*
FROM discounts_category as t1
WHERE 1 AND active = '1' AND category_id = 13
|
| 0.0001 |
SELECT t1.*
FROM products_quantity_offers as t1
WHERE 1 AND active = '1'
AND product_id = 313
AND price < 7
ORDER BY quantity ASC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'produs_gratuit'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 313 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 313 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT round((sum(rating)/count(rating)),1) as rating, count(rating) as rating_counters
FROM products_comments as t1
WHERE 1 AND product_id = 313
AND active = '1'
AND rating > 0
AND site_id = 1
|
| 0.0000 |
SELECT t1.*
FROM messages_stoc_epuizat as t1
WHERE 1 AND message_stoc_epuizat_id = 1 AND active = '1'
|
| 0.0002 |
SELECT price, pret_achizitie, category_id, t1.product_id
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
WHERE 1 AND t1.product_id = '312'
|
| 0.0001 |
SELECT t1.fara_discount , t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND t1.category_id = 13
LIMIT 0,1
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 312 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT t1.*
FROM discounts_category as t1
WHERE 1 AND active = '1' AND category_id = 13
|
| 0.0000 |
SELECT t1.*
FROM products_quantity_offers as t1
WHERE 1 AND active = '1'
AND product_id = 312
AND price < 4
ORDER BY quantity ASC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'produs_gratuit'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 312 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 312 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT round((sum(rating)/count(rating)),1) as rating, count(rating) as rating_counters
FROM products_comments as t1
WHERE 1 AND product_id = 312
AND active = '1'
AND rating > 0
AND site_id = 1
|
| 0.0000 |
SELECT t1.*
FROM messages_stoc_epuizat as t1
WHERE 1 AND message_stoc_epuizat_id = 1 AND active = '1'
|
| 0.0002 |
SELECT price, pret_achizitie, category_id, t1.product_id
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
WHERE 1 AND t1.product_id = '303'
|
| 0.0001 |
SELECT t1.fara_discount , t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND t1.category_id = 13
LIMIT 0,1
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 303 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT t1.*
FROM discounts_category as t1
WHERE 1 AND active = '1' AND category_id = 13
|
| 0.0000 |
SELECT t1.*
FROM products_quantity_offers as t1
WHERE 1 AND active = '1'
AND product_id = 303
AND price < 7
ORDER BY quantity ASC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'produs_gratuit'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 303 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 303 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT round((sum(rating)/count(rating)),1) as rating, count(rating) as rating_counters
FROM products_comments as t1
WHERE 1 AND product_id = 303
AND active = '1'
AND rating > 0
AND site_id = 1
|
| 0.0001 |
SELECT t1.*
FROM messages_stoc_epuizat as t1
WHERE 1 AND message_stoc_epuizat_id = 1 AND active = '1'
|
| 0.0002 |
SELECT price, pret_achizitie, category_id, t1.product_id
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
WHERE 1 AND t1.product_id = '264'
|
| 0.0002 |
SELECT t1.fara_discount , t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND t1.category_id = 12
LIMIT 0,1
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 264 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM discounts_category as t1
WHERE 1 AND active = '1' AND category_id = 12
|
| 0.0001 |
SELECT t1.*
FROM products_quantity_offers as t1
WHERE 1 AND active = '1'
AND product_id = 264
AND price < 28
ORDER BY quantity ASC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'produs_gratuit'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 264 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 264 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT round((sum(rating)/count(rating)),1) as rating, count(rating) as rating_counters
FROM products_comments as t1
WHERE 1 AND product_id = 264
AND active = '1'
AND rating > 0
AND site_id = 1
|
| 0.0001 |
SELECT t1.*
FROM messages_stoc_epuizat as t1
WHERE 1 AND message_stoc_epuizat_id = 1 AND active = '1'
|
| 0.0003 |
SELECT price, pret_achizitie, category_id, t1.product_id
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
WHERE 1 AND t1.product_id = '263'
|
| 0.0002 |
SELECT t1.fara_discount , t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND t1.category_id = 12
LIMIT 0,1
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 263 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM discounts_category as t1
WHERE 1 AND active = '1' AND category_id = 12
|
| 0.0001 |
SELECT t1.*
FROM products_quantity_offers as t1
WHERE 1 AND active = '1'
AND product_id = 263
AND price < 28
ORDER BY quantity ASC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'produs_gratuit'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 263 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 263 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT round((sum(rating)/count(rating)),1) as rating, count(rating) as rating_counters
FROM products_comments as t1
WHERE 1 AND product_id = 263
AND active = '1'
AND rating > 0
AND site_id = 1
|
| 0.0001 |
SELECT t1.*
FROM messages_stoc_epuizat as t1
WHERE 1 AND message_stoc_epuizat_id = 1 AND active = '1'
|
| 0.0002 |
SELECT price, pret_achizitie, category_id, t1.product_id
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
WHERE 1 AND t1.product_id = '244'
|
| 0.0002 |
SELECT t1.fara_discount , t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND t1.category_id = 13
LIMIT 0,1
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 244 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM discounts_category as t1
WHERE 1 AND active = '1' AND category_id = 13
|
| 0.0001 |
SELECT t1.*
FROM products_quantity_offers as t1
WHERE 1 AND active = '1'
AND product_id = 244
AND price < 13
ORDER BY quantity ASC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'produs_gratuit'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 244 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 244 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT round((sum(rating)/count(rating)),1) as rating, count(rating) as rating_counters
FROM products_comments as t1
WHERE 1 AND product_id = 244
AND active = '1'
AND rating > 0
AND site_id = 1
|
| 0.0001 |
SELECT t1.*
FROM messages_stoc_epuizat as t1
WHERE 1 AND message_stoc_epuizat_id = 1 AND active = '1'
|
| 0.0002 |
SELECT price, pret_achizitie, category_id, t1.product_id
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
WHERE 1 AND t1.product_id = '243'
|
| 0.0002 |
SELECT t1.fara_discount , t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND t1.category_id = 13
LIMIT 0,1
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 243 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM discounts_category as t1
WHERE 1 AND active = '1' AND category_id = 13
|
| 0.0001 |
SELECT t1.*
FROM products_quantity_offers as t1
WHERE 1 AND active = '1'
AND product_id = 243
AND price < 10
ORDER BY quantity ASC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'produs_gratuit'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 243 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 243 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT round((sum(rating)/count(rating)),1) as rating, count(rating) as rating_counters
FROM products_comments as t1
WHERE 1 AND product_id = 243
AND active = '1'
AND rating > 0
AND site_id = 1
|
| 0.0000 |
SELECT t1.*
FROM messages_stoc_epuizat as t1
WHERE 1 AND message_stoc_epuizat_id = 1 AND active = '1'
|
| 0.0002 |
SELECT price, pret_achizitie, category_id, t1.product_id
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
WHERE 1 AND t1.product_id = '242'
|
| 0.0001 |
SELECT t1.fara_discount , t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND t1.category_id = 13
LIMIT 0,1
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 242 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM discounts_category as t1
WHERE 1 AND active = '1' AND category_id = 13
|
| 0.0001 |
SELECT t1.*
FROM products_quantity_offers as t1
WHERE 1 AND active = '1'
AND product_id = 242
AND price < 8
ORDER BY quantity ASC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'produs_gratuit'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 242 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 242 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT round((sum(rating)/count(rating)),1) as rating, count(rating) as rating_counters
FROM products_comments as t1
WHERE 1 AND product_id = 242
AND active = '1'
AND rating > 0
AND site_id = 1
|
| 0.0000 |
SELECT t1.*
FROM messages_stoc_epuizat as t1
WHERE 1 AND message_stoc_epuizat_id = 1 AND active = '1'
|
| 0.0002 |
SELECT price, pret_achizitie, category_id, t1.product_id
FROM products as t1
LEFT JOIN products_details as t2 ON t1.product_id = t2.product_id
WHERE 1 AND t1.product_id = '241'
|
| 0.0001 |
SELECT t1.fara_discount , t1.category_id, parent_id, lang_id
FROM categories as t1
LEFT JOIN categories_details as t2 ON t1.category_id = t2.category_id
WHERE site_id = 0 AND t1.category_id = 13
LIMIT 0,1
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 241 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT t1.*
FROM discounts_category as t1
WHERE 1 AND active = '1' AND category_id = 13
|
| 0.0001 |
SELECT t1.*
FROM products_quantity_offers as t1
WHERE 1 AND active = '1'
AND product_id = 241
AND price < 8
ORDER BY quantity ASC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'produs_gratuit'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 241 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0001 |
SELECT t1.*
FROM promotions as t1
WHERE 1 AND active = '1'
AND type = 'reducere'
AND promotion_id IN ( SELECT distinct promotion_id
FROM promotions_products
WHERE product_id = 241 )
AND date_start <= '2019-03-25'
AND date_end >= '2019-03-25'
ORDER BY promotion_id DESC
|
| 0.0000 |
SELECT round((sum(rating)/count(rating)),1) as rating, count(rating) as rating_counters
FROM products_comments as t1
WHERE 1 AND product_id = 241
AND active = '1'
AND rating > 0
AND site_id = 1
|
| 0.0001 |
SELECT sd.value
FROM settings as s
LEFT JOIN settings_details as sd ON s.setting_id = sd.setting_id
WHERE 1 AND name = 'text_alerta_cookie' AND sd.lang_id = 1
|
| 0.0002 |
SELECT SUM(quantity) as total
FROM cart
WHERE session_id = '2847c1ce723f1670c5b93be6418cdf4b'
|
| 0.0002 |
SELECT SUM(quantity*(price - discount_value)) as total
FROM cart
WHERE session_id = '2847c1ce723f1670c5b93be6418cdf4b'
|
| 0.0001 |
SELECT s.value
FROM settings as s
LEFT JOIN settings_details as sd ON s.setting_id = sd.setting_id
WHERE 1 AND name = 'currency'
|
| 0.0001 |
SELECT s.value
FROM settings as s
LEFT JOIN settings_details as sd ON s.setting_id = sd.setting_id
WHERE 1 AND name = 'link_anpc'
|
| 0.0001 |
SELECT s.value
FROM settings as s
LEFT JOIN settings_details as sd ON s.setting_id = sd.setting_id
WHERE 1 AND name = 'facebook_page'
|
Nou
Pret
