cerca
Richmond JR
Cardigan Richmond JR
[RCB0077]
Codice prodotto: 06610990
Prezzo:  
Variante prodotto
 
COLORE
TAGLIA
DISP.
QUANTITÀ
COLORE: Grigio Scuro
TAGLIA : 2
DISP. : 2
QUANTITÀ :

COLORE: Grigio Scuro
TAGLIA : 6
DISP. : 2
QUANTITÀ :

Descrizione

MADE IN ITALY: lavorato a maglia, maniche lunghe, chiusura sul fronte, zip, due tasche.

Collezione

AUTUNNO/INVERNO

Composizione

100%VIRGIN WOOL

ALTRI PRODOTTI DELLO STESSO BRAND

ABSOLUT JOY  
ABSOLUT JOY  
ABSOLUT JOY  
ABSOLUT JOY  
ABSOLUT JOY  
ABSOLUT JOY  
ABSOLUT JOY  
ABSOLUT JOY  
ABSOLUT JOY  
ABSOLUT JOY  
ABSOLUT JOY  
ABSOLUT JOY  

NEWSLETTER

RICEVI SCONTI E PROMOZIONI ESCLUSIVE ISCRIVENDOTI
ALLA NOSTRA NEWSLETTER

 
Vesto Italiano S.R.L. Unipersonale - C.F./P.Iva 04050650409 - Reg. imprese FC 327669 - Cap. Soc. EUR 10.000 i.v.
Current Parse Time: 1.201 s with 79 queries
QUERY DEBUG:
Array
(
    [QUERIES] => Array
        (
            [0] => select distinct c.categories_id, c.parent_id, cd.categories_name from categories c inner join categories_description cd on c.categories_id=cd.categories_id inner join products_to_categories p2c on c.categories_id=p2c.categories_id   
    inner join products p ON (p.products_id=p2c.products_id)
        inner join products_description pd ON (p.products_id=pd.products_id)
        left join manufacturers m using(manufacturers_id) where cd.language_id=4 and 1=1  and p.products_status = '1'
            [1] => select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
            [2] => select languages_id, name, code, image, directory from languages order by sort_order
            [3] => select banners_id, date_scheduled from banners where date_scheduled != ''
            [4] => select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id
            [5] => select specials_id from specials where status = '0' and now() >= date_inizio and date_inizio > 0 and now() < expires_date and expires_date > 0
            [6] => select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0
            [7] => select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0
            [8] => select p2c.categories_id from products p, products_to_categories p2c where p.products_id = '232325' and p.products_status = '1' and p.products_id = p2c.products_id limit 1
            [9] => select parent_id from categories where categories_id = '166'
            [10] => select parent_id from categories where categories_id = '157'
            [11] => select parent_id from categories where categories_id = '155'
            [12] => select parent_id from categories where categories_id = '154'
            [13] => select categories_name,categories_description,meta_title,meta_description,meta_keyword from categories_description where categories_id = '154' and language_id = '4'
            [14] => select categories_name,categories_description,meta_title,meta_description,meta_keyword from categories_description where categories_id = '155' and language_id = '4'
            [15] => select categories_name,categories_description,meta_title,meta_description,meta_keyword from categories_description where categories_id = '157' and language_id = '4'
            [16] => select categories_name,categories_description,meta_title,meta_description,meta_keyword from categories_description where categories_id = '166' and language_id = '4'
            [17] => select products_model,products_name,products_page_title,products_page_description 
    from products inner join products_description 
    on products.products_id=products_description.products_id where products.products_id = '232325' and language_id = '4'
            [18] => select count(*) as total from products_to_categories where categories_id = '166'
            [19] => select * from traduzioni
            [20] => select distinct taglia from products_to_categories p2c inner join categories c ON (p2c.categories_id = c.categories_id)
    inner join products p ON (p.products_id=p2c.products_id) inner join products_description pd on (p.products_id=pd.products_id) inner join categories_description cd on (cd.categories_id=c.categories_id) inner join manufacturers m on (m.manufacturers_id=p.manufacturers_id) where p.products_status = '1' and p.products_id = pd.products_id and cd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id  and p.products_price_rivenditore > 0  and p.products_forsale_rivenditore=1  and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and pd.language_id = '4' and c.categories_tree like '%;166;%'  order by taglia
            [21] => select distinct colore1 from products_to_categories p2c inner join categories c ON (p2c.categories_id = c.categories_id)
    inner join products p ON (p.products_id=p2c.products_id) inner join products_description pd on (p.products_id=pd.products_id) inner join categories_description cd on (cd.categories_id=c.categories_id)  inner join manufacturers m on (m.manufacturers_id=p.manufacturers_id) where p.products_status = '1' and p.products_id = pd.products_id and cd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id  and p.products_price_rivenditore > 0  and p.products_forsale_rivenditore=1  and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and pd.language_id = '4' and c.categories_tree like '%;166;%'  order by colore1
            [22] => select distinct season_code, season_id from products p left join season s ON(s.season_id = p.stagione) order by season_id
            [23] => select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id=4 and c.parent_id = 0 and c.visibile = 1 and cd.categories_id>0 order by sort_order, cd.categories_name
            [24] => select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id=4 and c.parent_id = 0 and c.visibile = 1 and cd.categories_id>0 order by sort_order, cd.categories_name
            [25] => select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and c.visibile = 1 and cd.language_id=4 and c.parent_id = 0 and cd.categories_id>0 order by sort_order, cd.categories_name
            [26] => SELECT c.categories_tree, c.categories_id, cd.categories_name, c.categories_image, c.parent_id
                      FROM categories c, categories_description cd
                      WHERE 
                        c.categories_id = cd.categories_id
                        and c.visibile = 1 
                        AND cd.language_id=4 
                        AND (c.parent_id in (select categories_id from  categories where parent_id=38) or c.parent_id=38)
                        AND (c.categories_id=39 or c.categories_id=108 or c.categories_id=139)       
                        and c.parent_id = 38
                        AND cd.categories_id>0
            [27] => SELECT c.categories_tree, c.categories_id, cd.categories_name, c.categories_image, c.parent_id
                      FROM categories c, categories_description cd
                      WHERE 
                        c.categories_id = cd.categories_id
                        and c.visibile = 1 
                        AND cd.language_id=4 
                        AND (c.parent_id in (select categories_id from  categories where parent_id=1) or c.parent_id=1)
                        AND (c.categories_id=2 or c.categories_id=94 or c.categories_id=98 or c.categories_id=100 or c.categories_id=138)       
                        and c.parent_id = 1
                        AND cd.categories_id>0
            [28] => SELECT c.categories_tree, c.categories_id, cd.categories_name, c.categories_image, c.parent_id
                      FROM categories c, categories_description cd
                      WHERE 
                        c.categories_id = cd.categories_id
                        and c.visibile = 1 
                        AND cd.language_id=4 
                        AND (c.parent_id in (select categories_id from  categories where parent_id=154) or c.parent_id=154)
                        AND (c.categories_id=155 or c.categories_id=156)       
                        and c.parent_id = 154
                        AND cd.categories_id>0
            [29] => select p.products_id,p.listino, p.consel, p.MPN,p.trasportogratis, pd.products_name,p.products_sconto,p.products_sconto_rivenditore,p.products_forsale,
        pd.products_description,pd.products_cartec,pd.products_note,pd.products_materiale,p.products_submodel, p.products_model, p.products_quantity,p.colore1 as color,
        p.products_image,pd.products_submodel_desc,p.articolo,p.modello,ad.nome as colore1,p.stagione,products_barcode, pi.products_image1, pi.products_image2, pi.products_image3, pi.products_image4, pi.products_image5,p.arrivo,p.produttore,
        pi.products_image6, pi.products_image7, pi.products_image8, pi.products_image9,  pd.products_url, p.products_price_listino, p.products_price_gross, p.products_price, p.products_tax_class_id,p.products_price_rivenditore,
        p.products_date_added, p.products_date_available, p.manufacturers_id, tm.manufacturers_name,c.tipocat,c.categories_id,c.categories_tree,p.products_weight_im, 
        p.products_lotto, p.products_stock, tax_class_title,p.video, multivar,
        IF(s.status, s.specials_new_products_price_gross, NULL) as specials_new_products_price_gross,
        IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price , products_submodel
        FROM products p inner join products_description pd on pd.products_id = p.products_id
        inner join products_to_categories p2c on p.products_id=p2c.products_id
        inner join categories c on c.categories_id=p2c.categories_id
        left join specials s on p.products_id = s.products_id
        left join products_images pi on p.products_id=pi.products_id
        left join manufacturers tm on p.manufacturers_id=tm.manufacturers_id
        left join attributi_desc ad on (p.colore1=ad.id_attributo and ad.languages_id = '4')
        left join tax_class tc ON (p.products_tax_class_id = tc.tax_class_id)
        WHERE p.products_status = '1' 
        AND p.products_id = '232325'
        AND pd.language_id = '4' and p.products_price_rivenditore > 0 
            [30] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=232325 and (expires_date > now() or expires_date IS NULL) and status=1
            [31] => 
    select
    p.products_id,p.taglia,ad.nome as colore1,p.colore1 as color,
    pd.products_submodel_desc,pd.products_note,p.products_sconto,p.products_sconto_rivenditore,
    p.products_price_gross,p.products_quantity,at.color,p.products_image,p.produttore, products_submodel
    from products p 
    inner join products_description pd on p.products_id=pd.products_id
    left join attributi at on p.colore1=at.id_attributo
    left join attributi at1 on p.taglia=at1.id_attributo
    left join attributi_desc ad on (at.id_attributo=ad.id_attributo and ad.languages_id = '4') 
    where
    p.products_status='1'  and p.products_price_rivenditore > 0  AND pd.language_id = '4'
    and p.products_model='RCB0077'  order by p.colore1,at1.posizione
            [32] => SELECT products_price,products_price_gross FROM products WHERE products_id=232325
            [33] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=232325 and (expires_date > now() or expires_date IS NULL) and status=1
            [34] => SELECT products_price,products_price_gross FROM products WHERE products_id=232326
            [35] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=232326 and (expires_date > now() or expires_date IS NULL) and status=1
            [36] => SELECT products_price,products_price_gross FROM products WHERE products_id=232327
            [37] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=232327 and (expires_date > now() or expires_date IS NULL) and status=1
            [38] => SELECT products_price,products_price_gross FROM products WHERE products_id=232328
            [39] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=232328 and (expires_date > now() or expires_date IS NULL) and status=1
            [40] => SELECT products_price,products_price_gross FROM products WHERE products_id=232329
            [41] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=232329 and (expires_date > now() or expires_date IS NULL) and status=1
            [42] => SELECT products_price,products_price_gross FROM products WHERE products_id=232330
            [43] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=232330 and (expires_date > now() or expires_date IS NULL) and status=1
            [44] => SELECT products_price,products_price_gross FROM products WHERE products_id=232331
            [45] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=232331 and (expires_date > now() or expires_date IS NULL) and status=1
            [46] => SELECT products_price,products_price_gross FROM products WHERE products_id=232332
            [47] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=232332 and (expires_date > now() or expires_date IS NULL) and status=1
            [48] => SELECT products_price,products_price_gross FROM products WHERE products_id=232333
            [49] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=232333 and (expires_date > now() or expires_date IS NULL) and status=1
            [50] => SELECT products_price,products_price_gross FROM products WHERE products_id=232334
            [51] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=232334 and (expires_date > now() or expires_date IS NULL) and status=1
            [52] => SELECT products_price,products_price_gross FROM products WHERE products_id=232335
            [53] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=232335 and (expires_date > now() or expires_date IS NULL) and status=1
            [54] => SELECT products_price,products_price_gross FROM products WHERE products_id=232336
            [55] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=232336 and (expires_date > now() or expires_date IS NULL) and status=1
            [56] => SELECT products_price,products_price_gross FROM products WHERE products_id=232337
            [57] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=232337 and (expires_date > now() or expires_date IS NULL) and status=1
            [58] => select distinct p.products_model, m.manufacturers_name, p.products_quantity,p.products_image, m.manufacturers_id, p.trasportogratis, p.colore1,p.colore2,p.novita,p.products_sconto,p.products_sconto_rivenditore,p.multivar,p.products_price_rivenditore,
                          p.products_submodel,p.products_id, pd.products_name, pd.products_description,pd.products_materiale,p2c.categories_id,cd.categories_name,p.products_forsale,
                          p.products_price_gross ,p.products_price, p.products_price_listino,p.listino,p.products_tax_class_id,
                          SUM(p.products_quantity) as qta_tot
                           from products p left join manufacturers m using(manufacturers_id) 
                         left join specials s on p.products_id = s.products_id
                         inner join products_description pd on p.products_id=pd.products_id 
                         inner join products_to_categories p2c on p.products_id=p2c.products_id 
                         inner join categories c on c.categories_id=p2c.categories_id 
                         inner join categories_description cd on c.categories_id=cd.categories_id 
                         inner join products_kit pk on p.products_id = pk.pop_products_id_slave
                          where p.products_status = '1' and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and cd.language_id = '4'  and pk.pop_products_id_master=232325 and p.products_price_rivenditore > 0  and p.products_forsale_rivenditore=1  group by p.products_model,p.colore1 
            [59] => SELECT products_submodel FROM products WHERE products_id = 232325
            [60] => SELECT products_price,products_price_gross FROM products WHERE products_id=232325
            [61] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=232325 and (expires_date > now() or expires_date IS NULL) and status=1
            [62] => select distinct sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '105') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '15242') and tr.tax_class_id = '0' group by tr.tax_priority
            [63] => SELECT products_submodel FROM products WHERE products_id = 232325
            [64] => SELECT products_price,products_price_gross FROM products WHERE products_id=232329
            [65] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=232329 and (expires_date > now() or expires_date IS NULL) and status=1
            [66] => select p.products_id, p.MPN, m.manufacturers_name, p.products_image,pd.products_name,pd.products_description, p.products_quantity, p.products_tax_class_id, s.status AS specstat,p.trasportogratis, IF(s.status, s.specials_new_products_price_gross, NULL) AS specials_new_products_price_gross, p.products_price_gross, p.products_price, p.products_forsale, p.products_submodel, p.products_price_listino,p.listino,  products_model, colore1 AS color FROM products p
                   LEFT JOIN manufacturers m USING(manufacturers_id)
                   LEFT JOIN specials s ON p.products_id = s.products_id
                   INNER JOIN products_description pd ON p.products_id=pd.products_id
                   LEFT JOIN products_related_products n ON p.products_id = n.pop_products_id_slave  where p.products_status = '1' AND p.products_id = pd.products_id  and p.products_price_rivenditore > 0 AND p.products_forsale_rivenditore=1  AND pd.language_id = '4'  and p.manufacturers_id = '178' group by p.products_model order by rand(767425210) DESC limit 12
            [67] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=237128 and (expires_date > now() or expires_date IS NULL) and status=1
            [68] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=234948 and (expires_date > now() or expires_date IS NULL) and status=1
            [69] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=235713 and (expires_date > now() or expires_date IS NULL) and status=1
            [70] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=236586 and (expires_date > now() or expires_date IS NULL) and status=1
            [71] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=232630 and (expires_date > now() or expires_date IS NULL) and status=1
            [72] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=238693 and (expires_date > now() or expires_date IS NULL) and status=1
            [73] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=237663 and (expires_date > now() or expires_date IS NULL) and status=1
            [74] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=236411 and (expires_date > now() or expires_date IS NULL) and status=1
            [75] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=232797 and (expires_date > now() or expires_date IS NULL) and status=1
            [76] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=229188 and (expires_date > now() or expires_date IS NULL) and status=1
            [77] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=236946 and (expires_date > now() or expires_date IS NULL) and status=1
            [78] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=234680 and (expires_date > now() or expires_date IS NULL) and status=1
        )

    [TIME] => Array
        (
            [0] => 0.004717
            [1] => 0.000395
            [2] => 0.000364
            [3] => 0.000761
            [4] => 0.038453
            [5] => 0.000320
            [6] => 0.000137
            [7] => 0.000199
            [8] => 0.000308
            [9] => 0.000150
            [10] => 0.000112
            [11] => 0.000117
            [12] => 0.000099
            [13] => 0.000143
            [14] => 0.000136
            [15] => 0.000134
            [16] => 0.000158
            [17] => 0.000221
            [18] => 0.000608
            [19] => 0.000455
            [20] => 0.379687
            [21] => 0.326437
            [22] => 0.199481
            [23] => 0.001096
            [24] => 0.000437
            [25] => 0.000388
            [26] => 0.001293
            [27] => 0.000602
            [28] => 0.000388
            [29] => 0.001266
            [30] => 0.000336
            [31] => 0.001250
            [32] => 0.000194
            [33] => 0.000243
            [34] => 0.000209
            [35] => 0.000229
            [36] => 0.000202
            [37] => 0.000238
            [38] => 0.000220
            [39] => 0.004951
            [40] => 0.001325
            [41] => 0.000353
            [42] => 0.000237
            [43] => 0.000290
            [44] => 0.000229
            [45] => 0.000273
            [46] => 0.000189
            [47] => 0.000212
            [48] => 0.000140
            [49] => 0.000205
            [50] => 0.000165
            [51] => 0.000240
            [52] => 0.000236
            [53] => 0.000356
            [54] => 0.000225
            [55] => 0.000265
            [56] => 0.000236
            [57] => 0.000256
            [58] => 0.005171
            [59] => 0.000376
            [60] => 0.000232
            [61] => 0.000387
            [62] => 0.000506
            [63] => 0.000230
            [64] => 0.000237
            [65] => 0.000290
            [66] => 0.145971
            [67] => 0.000568
            [68] => 0.000292
            [69] => 0.000308
            [70] => 0.000283
            [71] => 0.000266
            [72] => 0.000238
            [73] => 0.000265
            [74] => 0.000242
            [75] => 0.000179
            [76] => 0.000173
            [77] => 0.000185
            [78] => 0.000245
        )

)

SESSION:
Array
(
    [session_product_listing] => 
)

COOKIE:
Array
(
)
POST:
Array
(
)

GET:
Array
(
    [page] => detail
    [products_id] => 232325
    [products_name] => cardigan_richmond_jr.html
)