Promotii

eConvenabil sa cumperi cadouri pentru tine si cei dragi la preturi promotionale! Doar oferte la pret mic. Cadouri ieftine si idei de cadouri cu oferte de pret mic. Cadouri Valentines Day, Martisoare 1 Martie, Cadouri 8 Martie

Nu au fost gasite produse.

Propune un produs
  URI STRING  
/reduceri
  CLASS/METHOD  
products/reduceri
  MEMORY USAGE  
2,993,376 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0077
Controller Execution Time ( Products / Reduceri )  0.1149
Total Execution Time  0.1226
  GET DATA  
No GET data exists
  POST DATA  
No POST data exists
  DATABASE:  lanterne-ro   QUERIES: 27   
0.0079     SELECT t1.* 
                    
FROM siteuri as t1                    
                    WHERE 1  
AND LOWER(domeniu) = 'lanterne.ro'  
                     
                  
0.0001   SELECT *
FROM (`languages`)
WHERE `afisat_front` = '1'
ORDER BY `orderAS
0.0004     SELECT t1.* 
                    
FROM siteuri as t1                    
                    WHERE 1  
AND LOWER(domeniu) = 'lanterne.ro'  
                     
                  
0.0002     SELECT domeniusite_id 
                    FROM siteuri 
as t1                    
                    WHERE 1 
                     
                  
0.0001     SELECT domeniu 
                    FROM siteuri 
as t1                    
                    WHERE 1 
AND site_id 
                     
                  
0.0002     SELECT t1.* 
                    
FROM siteuri as t1                    
                    WHERE 1  
AND  active '1' 
                     
                  
0.0002     SELECT t1.* 
                    
FROM themes as t1                    
                    WHERE 1 
AND theme_id 
                     
                  
0.0001     SELECT t1.* 
                    
FROM discounts_site as t1                    
                    WHERE 1  
AND active '1' AND site_id 
                     
                  
0.0001     SELECT titleurl_key, `order`, sectionon_menutopbottomt1.page_id 
                    FROM pages 
as t1
                    LEFT JOIN pages_details 
as t2 ON t1.page_id t2.page_id
                    WHERE 1  
AND site_id AND lang_id AND active '1' 
                     
ORDER BY `orderASC  
                  
0.0001     SELECT  t1.category_idt1.category_idparent_idlang_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 AND active '1' AND parent_id 0
                     ORDER BY 
`orderASC  
                  
0.0001     SELECT  category_nameurl_keyurl_key_site_1, `order` , t1.category_idparent_idlang_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 AND active '1' 
                                
AND parent_id IN (0,11,14,15,18,19) 
                     
ORDER BY `orderASC  
                  
0.0023     SELECT t2.url_keyt2.titlet1.product_idt3.filenamecategory_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_dateINTERVAL 60 DAY) >= DATE(NOW())
                    
                    
GROUP BY t1.product_id
                    ORDER BY set_new_date DESC  LIMIT 0
,7
                  
0.0000    SELECT value FROM _useful_data WHERE name 'bestselled_ids' 
0.0001     SELECT t2.url_keyt2.titlet1.product_idt3.filenamecategory_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_id228,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.0001     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 AND active '1' 
                                    
AND t1.category_certificate_id IN (    SELECT category_certificate_id as id1 FROM categories_certificate as c1 
                                                            WHERE 
(    c1.parent_id OR c1.parent_id IN (    SELECT category_certificate_id as id FROM categories_certificate as 
                                                                                                    WHERE c
.parent_id ) 
                                                                    )  
                                                        ) 
                     
ORDER BY `orderASC  
                  
0.0001     SELECT partner_link_idpartner_link_typepartner_link_titlepartner_link_urlpartner_link_filepartner_link_script  
                    FROM partner_links 
as t1                    
                    WHERE 1  
AND active '1' AND site_id 
                     ORDER BY 
`orderASC  
                  
0.0049     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 `orderDESC 
                  
0.0001     SELECT t1.*, t2.* 
                    
FROM pages as t1
                    LEFT JOIN pages_details 
as t2 ON t1.page_id t2.page_id
                    WHERE 1  
AND site_id AND  lang_id AND active '1' AND section 'reduceri' 
                     
                  
0.0029     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 active '1'  AND removed '0'
                    
AND lang_id '1'
                    
AND t1.product_id IN (     SELECT distinct promotions_products.product_id
                                            FROM promotions_products
                                            WHERE promotion_id IN 
(    SELECT promotion_id 
                                                                    FROM promotions 
                                                                    WHERE active 
'1'                                                                    
                                                                    
AND date_start     <= '2019-03-25'
                                                                    
AND date_end     >= '2019-03-25'                                                                        
                                                                    
)                                                                                                                                                        
                                        )                    
                
                     
                  
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.0244     SELECT t1.*, t2.* 
                    
FROM products as t1
                    LEFT JOIN products_details 
as t2 ON t1.product_id t2.product_id
                    
                    
                    
                    WHERE 1  
AND active '1'  AND removed '0'
                    
AND lang_id '1'
                    
AND t1.product_id IN (     SELECT distinct promotions_products.product_id
                                            FROM promotions_products
                                            WHERE promotion_id IN 
(    SELECT promotion_id 
                                                                    FROM promotions 
                                                                    WHERE active 
'1'                                                                    
                                                                    
AND date_start     <= '2019-03-25'
                                                                    
AND date_end     >= '2019-03-25'                                                                        
                                                                    
)                                                                                                                                                        
                                        )                    
                
                    
ORDER BY (IF(stock>0,1,0)) DESCset_recomandat DESCt1.product_id desc  LIMIT 0,18
                  
0.0002     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.0011     SELECT SUM(quantity) as total 
                    FROM cart                    
                    WHERE session_id 
'3d819913e9073f1272e23e744fe07a62'  
0.0002     SELECT SUM(quantity*(price discount_value)) as total 
                    FROM cart                    
                    WHERE session_id 
'3d819913e9073f1272e23e744fe07a62'  
0.0000     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.0000     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'