Sram Argentina

de 848 productos

Inicio Filtros Menu 0 U$S0,0
Top

Al navegar por este sitio aceptás el uso de cookies para agilizar tu experiencia de compra.  

(default) 12 queries took 6 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1BEGIN000
2INSERT INTO `nubix_fitnet`.`visits` (`convert`, `order`, `cart`, `contact`, `register`, `news`, `device_id`, `browser_id`, `os_id`, `channel`, `amount`, `cart_amount`, `user_id`, `utm_source`, `utm_medium`, `utm_campaign`, `referer`, `land`, `search`, `social_id`, `order_id`, `auto_location`, `ip`, `modified`, `created`) VALUES (0, 0, 0, 0, 0, 0, 3, 0, 0, 4, 0, 0, NULL, NULL, '', '', '/', 'https://www.fitnet.com.ar/marca/sram.html', '', 8, NULL, 'El Monte / United States', '216.73.216.209', '2026-05-18 02:22:44', '2026-05-18 02:22:44')110
3COMMIT000
4SELECT `Marca`.`id`, `Marca`.`habilitada`, `Marca`.`parent_id`, `Marca`.`store`, `Marca`.`nombre`, `Marca`.`slug`, `Marca`.`borrada`, `Marca`.`destacada`, `Marca`.`hot_off`, `Marca`.`meta_title`, `Marca`.`meta_description`, `Marca`.`store_slide_id`, `Marca`.`slide_id`, `Marca`.`imagen`, `Marca`.`thumb`, `Marca`.`redirect`, `Marca`.`redirect_url`, `Marca`.`info_categs_ids`, `Marca`.`store_items_l1`, `Marca`.`store_items_l2`, `Marca`.`store_items_l3`, `Marca`.`store_items_l1_title`, `Marca`.`store_items_l2_title`, `Marca`.`store_items_l3_title` FROM `nubix_fitnet`.`marcas` AS `Marca` WHERE `Marca`.`borrada` = 0 AND `Marca`.`slug` = 'sram' ORDER BY `Marca`.`habilitada` DESC LIMIT 1111
5SELECT `Marca`.`id`, `Marca`.`nombre`, `Marca`.`slug`, `Marca`.`imagen`, `Marca`.`habilitada`, `Marca`.`meta_title` FROM `nubix_fitnet`.`marcas` AS `Marca` WHERE `Marca`.`parent_id` = 5 AND `Marca`.`borrada` = 0 AND `Marca`.`habilitada` = 1 ORDER BY `Marca`.`nombre` ASC001
6SELECT `Categoria`.`id`, `Categoria`.`parent_id`, `Categoria`.`root_id`, `Categoria`.`nombre`, `Categoria`.`slug`, `Categoria`.`meta_title` FROM `nubix_fitnet`.`categorias` AS `Categoria` WHERE `Categoria`.`leaf` = 1 AND `Categoria`.`id` IN (636, 285, 231, 162, 559, 73, 81, 84, 70, 87, 583, 61, 82, 143, 120, 68, 86, 69, 209, 437, 83, 440, 436, 85, 592, 370, 108, 109, 438, 371, 464, 571, 206, 169, 546, 71, 72, 210, 402, 403, 560, 586, 453, 458, 556, 522, 587, 59, 584, 590, 544, 375, 113, 639, 641, 547, 64, 595, 561, 629, 95, 553, 112, 612) AND `Categoria`.`habilitada` = 162621
7SELECT `Categoria`.`id`, `Categoria`.`nombre` FROM `nubix_fitnet`.`categorias` AS `Categoria` WHERE `Categoria`.`parent_id` IS NULL10100
8SELECT `Categoria`.`id`, `Categoria`.`nombre` FROM `nubix_fitnet`.`categorias` AS `Categoria` WHERE `Categoria`.`leaf` = 0 AND `Categoria`.`id` IN (51, 51, 50, 56, 49, 49, 51, 49, 49, 49, 50, 51, 51, 51, 51, 51, 51, 56, 56, 110, 110, 118, 141, 5, 10, 199, 51, 56, 149, 149, 373, 555, 430, 49, 51, 555, 535, 536, 56, 50, 425, 430, 430, 430, 430, 425, 49, 536, 536, 536, 562, 552, 555, 536, 58, 58, 51, 214, 628, 624, 628, 628) AND `Categoria`.`habilitada` = 123231
9SELECT `Slide`.`id`, `Slide`.`home`, `Slide`.`delay`, `Slide`.`kbytes`, `Slide`.`mobile_kbytes`, `Slide`.`random`, `Slide`.`date_from0`, `Slide`.`date_to0`, `Slide`.`date_from1`, `Slide`.`date_to1`, `Slide`.`date_from2`, `Slide`.`date_to2`, `Slide`.`date_from3`, `Slide`.`date_to3`, `Slide`.`date_from4`, `Slide`.`date_to4`, `Slide`.`date_from5`, `Slide`.`date_to5`, `Slide`.`date_from6`, `Slide`.`date_to6`, `Slide`.`date_from7`, `Slide`.`date_to7`, `Slide`.`date_from8`, `Slide`.`date_to8`, `Slide`.`date_from9`, `Slide`.`date_to9`, `Slide`.`layout`, `Slide`.`titulo0`, `Slide`.`titulo1`, `Slide`.`titulo2`, `Slide`.`titulo3`, `Slide`.`titulo4`, `Slide`.`titulo5`, `Slide`.`titulo6`, `Slide`.`titulo7`, `Slide`.`titulo8`, `Slide`.`titulo9`, `Slide`.`bajada0`, `Slide`.`bajada1`, `Slide`.`bajada2`, `Slide`.`bajada3`, `Slide`.`bajada4`, `Slide`.`bajada5`, `Slide`.`bajada6`, `Slide`.`bajada7`, `Slide`.`bajada8`, `Slide`.`bajada9`, `Slide`.`file0`, `Slide`.`file1`, `Slide`.`file2`, `Slide`.`file3`, `Slide`.`file4`, `Slide`.`file5`, `Slide`.`file6`, `Slide`.`file7`, `Slide`.`file8`, `Slide`.`file9`, `Slide`.`file_mobile0`, `Slide`.`file_mobile1`, `Slide`.`file_mobile2`, `Slide`.`file_mobile3`, `Slide`.`file_mobile4`, `Slide`.`file_mobile5`, `Slide`.`file_mobile6`, `Slide`.`file_mobile7`, `Slide`.`file_mobile8`, `Slide`.`file_mobile9`, `Slide`.`front_file0`, `Slide`.`front_file1`, `Slide`.`front_file2`, `Slide`.`front_file3`, `Slide`.`front_file4`, `Slide`.`front_file5`, `Slide`.`front_file6`, `Slide`.`front_file7`, `Slide`.`front_file8`, `Slide`.`front_file9`, `Slide`.`url0`, `Slide`.`url1`, `Slide`.`url2`, `Slide`.`url3`, `Slide`.`url4`, `Slide`.`url5`, `Slide`.`url6`, `Slide`.`url7`, `Slide`.`url8`, `Slide`.`url9`, `Slide`.`url2_0`, `Slide`.`url2_1`, `Slide`.`url2_2`, `Slide`.`url2_3`, `Slide`.`url2_4`, `Slide`.`url2_5`, `Slide`.`url2_6`, `Slide`.`url2_7`, `Slide`.`url2_8`, `Slide`.`url2_9`, `Slide`.`habilitado0`, `Slide`.`habilitado1`, `Slide`.`habilitado2`, `Slide`.`habilitado3`, `Slide`.`habilitado4`, `Slide`.`habilitado5`, `Slide`.`habilitado6`, `Slide`.`habilitado7`, `Slide`.`habilitado8`, `Slide`.`habilitado9`, `Slide`.`posicion0`, `Slide`.`posicion1`, `Slide`.`posicion2`, `Slide`.`posicion3`, `Slide`.`posicion4`, `Slide`.`posicion5`, `Slide`.`posicion6`, `Slide`.`posicion7`, `Slide`.`posicion8`, `Slide`.`posicion9`, `Slide`.`nombre`, `Slide`.`text_button0`, `Slide`.`text_button1`, `Slide`.`text_button2`, `Slide`.`text_button3`, `Slide`.`text_button4`, `Slide`.`text_button5`, `Slide`.`text_button6`, `Slide`.`text_button7`, `Slide`.`text_button8`, `Slide`.`text_button9`, `Slide`.`text_button2_0`, `Slide`.`text_button2_1`, `Slide`.`text_button2_2`, `Slide`.`text_button2_3`, `Slide`.`text_button2_4`, `Slide`.`text_button2_5`, `Slide`.`text_button2_6`, `Slide`.`text_button2_7`, `Slide`.`text_button2_8`, `Slide`.`text_button2_9`, `Slide`.`created`, `Slide`.`modified`, `Slide`.`created_by`, `Slide`.`modified_by`, `Slide`.`bg_color0`, `Slide`.`bg_color1`, `Slide`.`bg_color2`, `Slide`.`bg_color3`, `Slide`.`bg_color4`, `Slide`.`bg_color5`, `Slide`.`bg_color6`, `Slide`.`bg_color7`, `Slide`.`bg_color8`, `Slide`.`bg_color9`, `Slide`.`html`, `Slide`.`profiles_ids`, `Slide`.`video0`, `Slide`.`video1`, `Slide`.`video2`, `Slide`.`video3`, `Slide`.`video4`, `Slide`.`video5`, `Slide`.`video6`, `Slide`.`video7`, `Slide`.`video8`, `Slide`.`video9`, `Slide`.`devices` FROM `nubix_fitnet`.`slides` AS `Slide` WHERE `Slide`.`layout` = 'cartzilla' AND `devices` IN (1, 2) AND `Slide`.`id` = 1 AND ((`Slide`.`profiles_ids` IS NULL) OR (`Slide`.`profiles_ids` LIKE '%/1/%')) LIMIT 1111
10SELECT `Banner`.`id`, `Banner`.`tipo`, `Banner`.`file`, `Banner`.`url`, `Banner`.`nombre`, `Banner`.`codigo`, `Banner`.`popup` FROM `nubix_fitnet`.`banners` AS `Banner` WHERE `Banner`.`layout` = 'cartzilla' AND `Banner`.`habilitado` = 1 AND `Banner`.`posicion_id` = 4 AND ((`Banner`.`marca_id` = 5) OR (`Banner`.`destacado` = 1)) ORDER BY `Banner`.`lft` ASC000
11SELECT `Valoracion`.`created`, `Valoracion`.`pedido_id`, `Valoracion`.`name`, `Valoracion`.`comentario`, `Valoracion`.`valoracion`, `Articulo`.`nombre`, `Articulo`.`id`, `Articulo`.`slug`, `Articulo`.`meta_title`, `Articulo`.`marca_id`, `Articulo`.`img1_list`, `Articulo`.`thumb1`, `Articulo`.`thumb2`, `Articulo`.`thumb3`, `Articulo`.`thumb4`, `Articulo`.`thumb5`, `Articulo`.`thumb6`, `Articulo`.`thumb7`, `Articulo`.`thumb8`, `Articulo`.`thumb9`, `Articulo`.`thumb10`, `Articulo`.`thumb11`, `Articulo`.`thumb12`, `Articulo`.`thumb13`, `Articulo`.`thumb14`, `Articulo`.`thumb15`, `Articulo`.`thumb16`, `Articulo`.`thumb17`, `Articulo`.`thumb18`, `Articulo`.`thumb19`, `Articulo`.`thumb20` FROM `nubix_fitnet`.`valoraciones` AS `Valoracion` LEFT JOIN `nubix_fitnet`.`articulos` AS `Articulo` ON (`Valoracion`.`articulo_id` = `Articulo`.`id`) LEFT JOIN `nubix_fitnet`.`usuarios` AS `Usuario` ON (`Valoracion`.`usuario_id` = `Usuario`.`id`) WHERE `Valoracion`.`estado` = 3 AND `Valoracion`.`deleted` = 0 AND `Articulo`.`archived` = 0 AND `Articulo`.`borrado` = 0 AND `Articulo`.`discontinuado` = 0 AND `Articulo`.`stock_id` = 1 AND `Articulo`.`marca_id` = 5 ORDER BY `Valoracion`.`created` DESC LIMIT 12001
12SELECT `Banner`.`id`, `Banner`.`tipo`, `Banner`.`file`, `Banner`.`url`, `Banner`.`nombre`, `Banner`.`codigo`, `Banner`.`popup` FROM `nubix_fitnet`.`banners` AS `Banner` WHERE `Banner`.`layout` = 'cartzilla' AND `Banner`.`habilitado` = 1 AND `Banner`.`posicion_id` = 2 AND ((`Banner`.`marca_id` = 5) OR (`Banner`.`destacado` = 1)) ORDER BY `Banner`.`lft` ASC000