CIOSA Autopartes

PUNTOS DE REFERENCIA

Loading Time: Base Classes	0.0006
Controller Execution Time ( Autopartes / Remap )	3.6177
Total Execution Time	3.6183

DATOS GET

No hay ningún dato GET

USO DE MEMORIA

3,078,664 bytes

DATOS POST

No hay ningún dato POST

CADENA URI

autopartes/balero/Todo

CLASE/MÉTODO

autopartes/balero

BASE DE DATOS: ciosa_mx (Autopartes:$db) CONSULTAS: 210 (0.3737 segundos) (Mostrar)

0.0004	SELECT * FROM `pedidose` WHERE `pedido` IS NULL
0.0003	SELECT `codigo`, `descripcion` FROM `catalogos` WHERE `descripcion` = 'balero'
0.0003	SELECT `codigo`, `descripcion` FROM `subgrupos` WHERE `codigo` = '020309'
0.0010	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `p`.`subgrupo` = '020309' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0004	`select FOUND_ROWS() as total`
0.0004	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('02466','02699','02703','10810','10811','10812','10813','10815','10818','10821','10822','10824','10826','10828','10829','41377','44676C','44677C','44678C','44679C','44680C','44681C','44682C','44684C','44685C','44686C','44689C','44690C','44692C','44693C','44694C','44695C','44696C','44697C','44699C','44701C','44702C','44703C','44704C','44706C','44709C','44711C','44712C','44713C','44716C','44717C','44718C','44719C','44720C','44721C','44722C','46949C','49147C','49148C','49151C','49153C','6000-2RSC','6000-TTC','6001-2RSC','6002-2RSC','6003-2RSC','6004-2RSC','6005-2RSC','608-2RSC','609-2RSC','6200-2RSC','62000-2RSC','6201-2RSC','6202-2RSC','6203-2RSC','6203-TT','6204-2RSC','6205-2RSC','6209-2RSC','62201-2RS-C3','62304-2RSC','62306-2RS-C3','629-2RSC','63001-2RSC','63003-2RSC','6301-2RSC','6302-2RSC','6303-2RSC','6305-2RSC','6306-2RSC','6333-2RSC','6336-2RSC','6902-2RSC','6903-2RSC','6904-2RSC','8-101C','8-9106C','949100-3820','9491002790C','B1027D','B1050DC','B1051D','B1583DC','B17-127DC','B1747D','B1799C','B8-23DC','B874D','B879D','B885D','NB-110','W6305-2RSC','W6306-2RSC') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0003	SELECT * FROM `prexclusiones` WHERE `promocion` = '1299'
0.0000	SELECT SQL_CALC_FOUND_ROWS sg.* FROM `subgrupos` `sg` WHERE `p`.`subgrupo` = '020309' AND codigo = 020309 ORDER BY `descripcion` LIMIT 10
0.0005	SELECT distinct(p.codigo) FROM `_productos` `_p` LEFT JOIN `especificaciones_tecnicas_producto` `ep` ON `ep`.`id_producto`=`_p`.`id` LEFT JOIN `especificaciones_tecnicas_atributos` `ea` ON `ep`.`id_especificacion`=`ea`.`id` INNER JOIN `productos` `p` ON `p`.`codigo`=`_p`.`codigo` INNER JOIN `subgrupos` `sgp` ON `sgp`.`codigo`=`p`.`subgrupo` WHERE `_p`.`codigo` IN('02466', '02699', '02703', '10810', '10811', '10812', '10813', '10815', '10818', '10821', '10822', '10824', '10826', '10828', '10829', '41377', '44676C', '44677C', '44678C', '44679C', '44680C', '44681C', '44682C', '44684C', '44685C', '44686C', '44689C', '44690C', '44692C', '44693C', '44694C', '44695C', '44696C', '44697C', '44699C', '44701C', '44702C', '44703C', '44704C', '44706C', '44709C', '44711C', '44712C', '44713C', '44716C', '44717C', '44718C', '44719C', '44720C', '44721C', '44722C', '46949C', '49147C', '49148C', '49151C', '49153C', '6000-2RSC', '6000-TTC', '6001-2RSC', '6002-2RSC', '6003-2RSC', '6004-2RSC', '6005-2RSC', '608-2RSC', '609-2RSC', '6200-2RSC', '62000-2RSC', '6201-2RSC', '6202-2RSC', '6203-2RSC', '6203-TT', '6204-2RSC', '6205-2RSC', '6209-2RSC', '62201-2RS-C3', '62304-2RSC', '62306-2RS-C3', '629-2RSC', '63001-2RSC', '63003-2RSC', '6301-2RSC', '6302-2RSC', '6303-2RSC', '6305-2RSC', '6306-2RSC', '6333-2RSC', '6336-2RSC', '6902-2RSC', '6903-2RSC', '6904-2RSC', '8-101C', '8-9106C', '949100-3820', '9491002790C', 'B1027D', 'B1050DC', 'B1051D', 'B1583DC', 'B17-127DC', 'B1747D', 'B1799C', 'B8-23DC', 'B874D', 'B879D', 'B885D', 'NB-110', 'W6305-2RSC', 'W6306-2RSC') AND `p`.`mostrar` != 'NM' AND ( ( `sgp`.`descripcion` IN('BALERO') ) )
0.0008	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `p`.`subgrupo` = '020309' AND `p`.`status` = '00' AND `p`.`codigo` IN('02466', '02699', '02703', '10810', '10811', '10812', '10813', '10815', '10818', '10821', '10822', '10824', '10826', '10828', '10829', '41377', '44676C', '44677C', '44678C', '44679C', '44680C', '44681C', '44682C', '44684C', '44685C', '44686C', '44689C', '44690C', '44692C', '44693C', '44694C', '44695C', '44696C', '44697C', '44699C', '44701C', '44702C', '44703C', '44704C', '44706C', '44709C', '44711C', '44712C', '44713C', '44716C', '44717C', '44718C', '44719C', '44720C', '44721C', '44722C', '46949C', '49147C', '49148C', '49151C', '49153C', '6000-2RSC', '6000-TTC', '6001-2RSC', '6002-2RSC', '6003-2RSC', '6004-2RSC', '6005-2RSC', '608-2RSC', '609-2RSC', '6200-2RSC', '62000-2RSC', '6201-2RSC', '6202-2RSC', '6203-2RSC', '6203-TT', '6204-2RSC', '6205-2RSC', '6209-2RSC', '62201-2RS-C3', '62304-2RSC', '62306-2RS-C3', '629-2RSC', '63001-2RSC', '63003-2RSC', '6301-2RSC', '6302-2RSC', '6303-2RSC', '6305-2RSC', '6306-2RSC', '6333-2RSC', '6336-2RSC', '6902-2RSC', '6903-2RSC', '6904-2RSC', '8-101C', '8-9106C', '949100-3820', '9491002790C', 'B1027D', 'B1050DC', 'B1051D', 'B1583DC', 'B17-127DC', 'B1747D', 'B1799C', 'B8-23DC', 'B874D', 'B879D', 'B885D', 'NB-110', 'W6305-2RSC', 'W6306-2RSC') GROUP BY `p`.`codigo`
0.0004	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('02466','02699','02703','10810','10811','10812','10813','10815','10818','10821','10822','10824','10826','10828','10829','41377','44676C','44677C','44678C','44679C','44680C','44681C','44682C','44684C','44685C','44686C','44689C','44690C','44692C','44693C','44694C','44695C','44696C','44697C','44699C','44701C','44702C','44703C','44704C','44706C','44709C','44711C','44712C','44713C','44716C','44717C','44718C','44719C','44720C','44721C','44722C','46949C','49147C','49148C','49151C','49153C','6000-2RSC','6000-TTC','6001-2RSC','6002-2RSC','6003-2RSC','6004-2RSC','6005-2RSC','608-2RSC','609-2RSC','6200-2RSC','62000-2RSC','6201-2RSC','6202-2RSC','6203-2RSC','6203-TT','6204-2RSC','6205-2RSC','6209-2RSC','62201-2RS-C3','62304-2RSC','62306-2RS-C3','629-2RSC','63001-2RSC','63003-2RSC','6301-2RSC','6302-2RSC','6303-2RSC','6305-2RSC','6306-2RSC','6333-2RSC','6336-2RSC','6902-2RSC','6903-2RSC','6904-2RSC','8-101C','8-9106C','949100-3820','9491002790C','B1027D','B1050DC','B1051D','B1583DC','B17-127DC','B1747D','B1799C','B8-23DC','B874D','B879D','B885D','NB-110','W6305-2RSC','W6306-2RSC') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0000	SELECT SQL_CALC_FOUND_ROWS sg.* FROM `subgrupos` `sg` WHERE `p`.`subgrupo` = '020309' AND codigo = 020309 ORDER BY `descripcion` LIMIT 10
0.0409	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `p`.`subgrupo` = '020309' AND `p`.`status` = '00' AND `p`.`codigo` IN('02466', '02699', '02703', '10810', '10811', '10812', '10813', '10815', '10818', '10821', '10822', '10824', '10826', '10828', '10829', '41377', '44676C', '44677C', '44678C', '44679C', '44680C', '44681C', '44682C', '44684C', '44685C', '44686C', '44689C', '44690C', '44692C', '44693C', '44694C', '44695C', '44696C', '44697C', '44699C', '44701C', '44702C', '44703C', '44704C', '44706C', '44709C', '44711C', '44712C', '44713C', '44716C', '44717C', '44718C', '44719C', '44720C', '44721C', '44722C', '46949C', '49147C', '49148C', '49151C', '49153C', '6000-2RSC', '6000-TTC', '6001-2RSC', '6002-2RSC', '6003-2RSC', '6004-2RSC', '6005-2RSC', '608-2RSC', '609-2RSC', '6200-2RSC', '62000-2RSC', '6201-2RSC', '6202-2RSC', '6203-2RSC', '6203-TT', '6204-2RSC', '6205-2RSC', '6209-2RSC', '62201-2RS-C3', '62304-2RSC', '62306-2RS-C3', '629-2RSC', '63001-2RSC', '63003-2RSC', '6301-2RSC', '6302-2RSC', '6303-2RSC', '6305-2RSC', '6306-2RSC', '6333-2RSC', '6336-2RSC', '6902-2RSC', '6903-2RSC', '6904-2RSC', '8-101C', '8-9106C', '949100-3820', '9491002790C', 'B1027D', 'B1050DC', 'B1051D', 'B1583DC', 'B17-127DC', 'B1747D', 'B1799C', 'B8-23DC', 'B874D', 'B879D', 'B885D', 'NB-110', 'W6305-2RSC', 'W6306-2RSC') GROUP BY `p`.`codigo` LIMIT 12
0.0025	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('02466','02699','02703','10810','10811','10812','10813','10815','10818','10821','10822','10824') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0000	SELECT SQL_CALC_FOUND_ROWS sg.* FROM `subgrupos` `sg` WHERE `p`.`subgrupo` = '020309' AND codigo = 020309 ORDER BY `descripcion` LIMIT 10
0.0003	SELECT COUNT(ea.nombre) AS resultado, ea.nombre FROM `especificaciones_tecnicas_producto` `ep` INNER JOIN `especificaciones_tecnicas_atributos` `ea` ON `ep`.`id_especificacion`=`ea`.`id` INNER JOIN `_productos` `_p` ON `ep`.`id_producto`=`_p`.`id` WHERE `_p`.`codigo` IN('02466', '02699', '02703', '10810', '10811', '10812', '10813', '10815', '10818', '10821', '10822', '10824', '10826', '10828', '10829', '41377', '44676C', '44677C', '44678C', '44679C', '44680C', '44681C', '44682C', '44684C', '44685C', '44686C', '44689C', '44690C', '44692C', '44693C', '44694C', '44695C', '44696C', '44697C', '44699C', '44701C', '44702C', '44703C', '44704C', '44706C', '44709C', '44711C', '44712C', '44713C', '44716C', '44717C', '44718C', '44719C', '44720C', '44721C', '44722C', '46949C', '49147C', '49148C', '49151C', '49153C', '6000-2RSC', '6000-TTC', '6001-2RSC', '6002-2RSC', '6003-2RSC', '6004-2RSC', '6005-2RSC', '608-2RSC', '609-2RSC', '6200-2RSC', '62000-2RSC', '6201-2RSC', '6202-2RSC', '6203-2RSC', '6203-TT', '6204-2RSC', '6205-2RSC', '6209-2RSC', '62201-2RS-C3', '62304-2RSC', '62306-2RS-C3', '629-2RSC', '63001-2RSC', '63003-2RSC', '6301-2RSC', '6302-2RSC', '6303-2RSC', '6305-2RSC', '6306-2RSC', '6333-2RSC', '6336-2RSC', '6902-2RSC', '6903-2RSC', '6904-2RSC', '8-101C', '8-9106C', '949100-3820', '9491002790C', 'B1027D', 'B1050DC', 'B1051D', 'B1583DC', 'B17-127DC', 'B1747D', 'B1799C', 'B8-23DC', 'B874D', 'B879D', 'B885D', 'NB-110', 'W6305-2RSC', 'W6306-2RSC') AND `ea`.`mostrarFiltro` = '1' GROUP BY `nombre` ORDER BY `resultado` DESC
0.0002	SELECT COUNT(ep.descripcion_especificacion) AS resultado, ea.nombre, ea.componente, ea.orden, ep.descripcion_especificacion, ea.id as id FROM `especificaciones_tecnicas_producto` `ep` INNER JOIN `especificaciones_tecnicas_atributos` `ea` ON `ep`.`id_especificacion`=`ea`.`id` INNER JOIN `_productos` `_p` ON `ep`.`id_producto`=`_p`.`id` WHERE `_p`.`codigo` IN('02466', '02699', '02703', '10810', '10811', '10812', '10813', '10815', '10818', '10821', '10822', '10824', '10826', '10828', '10829', '41377', '44676C', '44677C', '44678C', '44679C', '44680C', '44681C', '44682C', '44684C', '44685C', '44686C', '44689C', '44690C', '44692C', '44693C', '44694C', '44695C', '44696C', '44697C', '44699C', '44701C', '44702C', '44703C', '44704C', '44706C', '44709C', '44711C', '44712C', '44713C', '44716C', '44717C', '44718C', '44719C', '44720C', '44721C', '44722C', '46949C', '49147C', '49148C', '49151C', '49153C', '6000-2RSC', '6000-TTC', '6001-2RSC', '6002-2RSC', '6003-2RSC', '6004-2RSC', '6005-2RSC', '608-2RSC', '609-2RSC', '6200-2RSC', '62000-2RSC', '6201-2RSC', '6202-2RSC', '6203-2RSC', '6203-TT', '6204-2RSC', '6205-2RSC', '6209-2RSC', '62201-2RS-C3', '62304-2RSC', '62306-2RS-C3', '629-2RSC', '63001-2RSC', '63003-2RSC', '6301-2RSC', '6302-2RSC', '6303-2RSC', '6305-2RSC', '6306-2RSC', '6333-2RSC', '6336-2RSC', '6902-2RSC', '6903-2RSC', '6904-2RSC', '8-101C', '8-9106C', '949100-3820', '9491002790C', 'B1027D', 'B1050DC', 'B1051D', 'B1583DC', 'B17-127DC', 'B1747D', 'B1799C', 'B8-23DC', 'B874D', 'B879D', 'B885D', 'NB-110', 'W6305-2RSC', 'W6306-2RSC') AND `ea`.`mostrarFiltro` = '1' GROUP BY `descripcion_especificacion` ORDER BY `ea`.`orden` ASC, `descripcion_especificacion` ASC
0.0003	SELECT count(*) as resultado, 'Tipo' as nombre, 1 as componente, -1 as orden, 'Nuevo' as descripcion_especificacion, '0' as id FROM `productos_nuevos` WHERE `articulo` IN('02466', '02699', '02703', '10810', '10811', '10812', '10813', '10815', '10818', '10821', '10822', '10824', '10826', '10828', '10829', '41377', '44676C', '44677C', '44678C', '44679C', '44680C', '44681C', '44682C', '44684C', '44685C', '44686C', '44689C', '44690C', '44692C', '44693C', '44694C', '44695C', '44696C', '44697C', '44699C', '44701C', '44702C', '44703C', '44704C', '44706C', '44709C', '44711C', '44712C', '44713C', '44716C', '44717C', '44718C', '44719C', '44720C', '44721C', '44722C', '46949C', '49147C', '49148C', '49151C', '49153C', '6000-2RSC', '6000-TTC', '6001-2RSC', '6002-2RSC', '6003-2RSC', '6004-2RSC', '6005-2RSC', '608-2RSC', '609-2RSC', '6200-2RSC', '62000-2RSC', '6201-2RSC', '6202-2RSC', '6203-2RSC', '6203-TT', '6204-2RSC', '6205-2RSC', '6209-2RSC', '62201-2RS-C3', '62304-2RSC', '62306-2RS-C3', '629-2RSC', '63001-2RSC', '63003-2RSC', '6301-2RSC', '6302-2RSC', '6303-2RSC', '6305-2RSC', '6306-2RSC', '6333-2RSC', '6336-2RSC', '6902-2RSC', '6903-2RSC', '6904-2RSC', '8-101C', '8-9106C', '949100-3820', '9491002790C', 'B1027D', 'B1050DC', 'B1051D', 'B1583DC', 'B17-127DC', 'B1747D', 'B1799C', 'B8-23DC', 'B874D', 'B879D', 'B885D', 'NB-110', 'W6305-2RSC', 'W6306-2RSC') AND `entrada` >= '2026-04-14'
0.0003	SELECT count(*) as resultado, 'Tipo' as nombre, 1 as componente, -1 as orden, 'Oferta' as descripcion_especificacion, '0' as id FROM `outlet` WHERE `codigo` IN('02466', '02699', '02703', '10810', '10811', '10812', '10813', '10815', '10818', '10821', '10822', '10824', '10826', '10828', '10829', '41377', '44676C', '44677C', '44678C', '44679C', '44680C', '44681C', '44682C', '44684C', '44685C', '44686C', '44689C', '44690C', '44692C', '44693C', '44694C', '44695C', '44696C', '44697C', '44699C', '44701C', '44702C', '44703C', '44704C', '44706C', '44709C', '44711C', '44712C', '44713C', '44716C', '44717C', '44718C', '44719C', '44720C', '44721C', '44722C', '46949C', '49147C', '49148C', '49151C', '49153C', '6000-2RSC', '6000-TTC', '6001-2RSC', '6002-2RSC', '6003-2RSC', '6004-2RSC', '6005-2RSC', '608-2RSC', '609-2RSC', '6200-2RSC', '62000-2RSC', '6201-2RSC', '6202-2RSC', '6203-2RSC', '6203-TT', '6204-2RSC', '6205-2RSC', '6209-2RSC', '62201-2RS-C3', '62304-2RSC', '62306-2RS-C3', '629-2RSC', '63001-2RSC', '63003-2RSC', '6301-2RSC', '6302-2RSC', '6303-2RSC', '6305-2RSC', '6306-2RSC', '6333-2RSC', '6336-2RSC', '6902-2RSC', '6903-2RSC', '6904-2RSC', '8-101C', '8-9106C', '949100-3820', '9491002790C', 'B1027D', 'B1050DC', 'B1051D', 'B1583DC', 'B17-127DC', 'B1747D', 'B1799C', 'B8-23DC', 'B874D', 'B879D', 'B885D', 'NB-110', 'W6305-2RSC', 'W6306-2RSC') AND `tipo` = 'EXCEDENTES'
0.0003	SELECT count(*) as resultado, 'Tipo' as nombre, 1 as componente, -1 as orden, 'Remate' as descripcion_especificacion, '0' as id FROM `outlet` WHERE `codigo` IN('02466', '02699', '02703', '10810', '10811', '10812', '10813', '10815', '10818', '10821', '10822', '10824', '10826', '10828', '10829', '41377', '44676C', '44677C', '44678C', '44679C', '44680C', '44681C', '44682C', '44684C', '44685C', '44686C', '44689C', '44690C', '44692C', '44693C', '44694C', '44695C', '44696C', '44697C', '44699C', '44701C', '44702C', '44703C', '44704C', '44706C', '44709C', '44711C', '44712C', '44713C', '44716C', '44717C', '44718C', '44719C', '44720C', '44721C', '44722C', '46949C', '49147C', '49148C', '49151C', '49153C', '6000-2RSC', '6000-TTC', '6001-2RSC', '6002-2RSC', '6003-2RSC', '6004-2RSC', '6005-2RSC', '608-2RSC', '609-2RSC', '6200-2RSC', '62000-2RSC', '6201-2RSC', '6202-2RSC', '6203-2RSC', '6203-TT', '6204-2RSC', '6205-2RSC', '6209-2RSC', '62201-2RS-C3', '62304-2RSC', '62306-2RS-C3', '629-2RSC', '63001-2RSC', '63003-2RSC', '6301-2RSC', '6302-2RSC', '6303-2RSC', '6305-2RSC', '6306-2RSC', '6333-2RSC', '6336-2RSC', '6902-2RSC', '6903-2RSC', '6904-2RSC', '8-101C', '8-9106C', '949100-3820', '9491002790C', 'B1027D', 'B1050DC', 'B1051D', 'B1583DC', 'B17-127DC', 'B1747D', 'B1799C', 'B8-23DC', 'B874D', 'B879D', 'B885D', 'NB-110', 'W6305-2RSC', 'W6306-2RSC') AND `tipo` = 'REMATES'
0.0004	SELECT COUNT(p.sistema) AS resultado, 'Sistema' as nombre, 1 as componente, -2 as orden, s.codigo as codigo, s.descripcion as descripcion_especificacion, '0' as id FROM `productos` `p` LEFT JOIN `sistemas` `s` ON `s`.`codigo`=`p`.`sistema` WHERE `p`.`codigo` IN('02466', '02699', '02703', '10810', '10811', '10812', '10813', '10815', '10818', '10821', '10822', '10824', '10826', '10828', '10829', '41377', '44676C', '44677C', '44678C', '44679C', '44680C', '44681C', '44682C', '44684C', '44685C', '44686C', '44689C', '44690C', '44692C', '44693C', '44694C', '44695C', '44696C', '44697C', '44699C', '44701C', '44702C', '44703C', '44704C', '44706C', '44709C', '44711C', '44712C', '44713C', '44716C', '44717C', '44718C', '44719C', '44720C', '44721C', '44722C', '46949C', '49147C', '49148C', '49151C', '49153C', '6000-2RSC', '6000-TTC', '6001-2RSC', '6002-2RSC', '6003-2RSC', '6004-2RSC', '6005-2RSC', '608-2RSC', '609-2RSC', '6200-2RSC', '62000-2RSC', '6201-2RSC', '6202-2RSC', '6203-2RSC', '6203-TT', '6204-2RSC', '6205-2RSC', '6209-2RSC', '62201-2RS-C3', '62304-2RSC', '62306-2RS-C3', '629-2RSC', '63001-2RSC', '63003-2RSC', '6301-2RSC', '6302-2RSC', '6303-2RSC', '6305-2RSC', '6306-2RSC', '6333-2RSC', '6336-2RSC', '6902-2RSC', '6903-2RSC', '6904-2RSC', '8-101C', '8-9106C', '949100-3820', '9491002790C', 'B1027D', 'B1050DC', 'B1051D', 'B1583DC', 'B17-127DC', 'B1747D', 'B1799C', 'B8-23DC', 'B874D', 'B879D', 'B885D', 'NB-110', 'W6305-2RSC', 'W6306-2RSC') GROUP BY `p`.`sistema` ORDER BY `descripcion_especificacion` ASC
0.0003	SELECT COUNT(p.grupo) AS resultado, 'Grupo' as nombre, 1 as componente, -5 as orden, g.codigo as codigo, g.descripcion as descripcion_especificacion, '0' as id FROM `productos` `p` LEFT JOIN `grupos` `g` ON `g`.`codigo`=`p`.`grupo` WHERE `p`.`codigo` IN('02466', '02699', '02703', '10810', '10811', '10812', '10813', '10815', '10818', '10821', '10822', '10824', '10826', '10828', '10829', '41377', '44676C', '44677C', '44678C', '44679C', '44680C', '44681C', '44682C', '44684C', '44685C', '44686C', '44689C', '44690C', '44692C', '44693C', '44694C', '44695C', '44696C', '44697C', '44699C', '44701C', '44702C', '44703C', '44704C', '44706C', '44709C', '44711C', '44712C', '44713C', '44716C', '44717C', '44718C', '44719C', '44720C', '44721C', '44722C', '46949C', '49147C', '49148C', '49151C', '49153C', '6000-2RSC', '6000-TTC', '6001-2RSC', '6002-2RSC', '6003-2RSC', '6004-2RSC', '6005-2RSC', '608-2RSC', '609-2RSC', '6200-2RSC', '62000-2RSC', '6201-2RSC', '6202-2RSC', '6203-2RSC', '6203-TT', '6204-2RSC', '6205-2RSC', '6209-2RSC', '62201-2RS-C3', '62304-2RSC', '62306-2RS-C3', '629-2RSC', '63001-2RSC', '63003-2RSC', '6301-2RSC', '6302-2RSC', '6303-2RSC', '6305-2RSC', '6306-2RSC', '6333-2RSC', '6336-2RSC', '6902-2RSC', '6903-2RSC', '6904-2RSC', '8-101C', '8-9106C', '949100-3820', '9491002790C', 'B1027D', 'B1050DC', 'B1051D', 'B1583DC', 'B17-127DC', 'B1747D', 'B1799C', 'B8-23DC', 'B874D', 'B879D', 'B885D', 'NB-110', 'W6305-2RSC', 'W6306-2RSC') GROUP BY `p`.`grupo` ORDER BY `descripcion_especificacion` ASC
0.0003	SELECT COUNT(p.subgrupo) AS resultado, 'Subgrupo' as nombre, 1 as componente, -4 as orden, s.codigo as codigo, s.descripcion as descripcion_especificacion, '0' as id FROM `productos` `p` LEFT JOIN `subgrupos` `s` ON `s`.`codigo`=`p`.`subgrupo` WHERE `p`.`codigo` IN('02466', '02699', '02703', '10810', '10811', '10812', '10813', '10815', '10818', '10821', '10822', '10824', '10826', '10828', '10829', '41377', '44676C', '44677C', '44678C', '44679C', '44680C', '44681C', '44682C', '44684C', '44685C', '44686C', '44689C', '44690C', '44692C', '44693C', '44694C', '44695C', '44696C', '44697C', '44699C', '44701C', '44702C', '44703C', '44704C', '44706C', '44709C', '44711C', '44712C', '44713C', '44716C', '44717C', '44718C', '44719C', '44720C', '44721C', '44722C', '46949C', '49147C', '49148C', '49151C', '49153C', '6000-2RSC', '6000-TTC', '6001-2RSC', '6002-2RSC', '6003-2RSC', '6004-2RSC', '6005-2RSC', '608-2RSC', '609-2RSC', '6200-2RSC', '62000-2RSC', '6201-2RSC', '6202-2RSC', '6203-2RSC', '6203-TT', '6204-2RSC', '6205-2RSC', '6209-2RSC', '62201-2RS-C3', '62304-2RSC', '62306-2RS-C3', '629-2RSC', '63001-2RSC', '63003-2RSC', '6301-2RSC', '6302-2RSC', '6303-2RSC', '6305-2RSC', '6306-2RSC', '6333-2RSC', '6336-2RSC', '6902-2RSC', '6903-2RSC', '6904-2RSC', '8-101C', '8-9106C', '949100-3820', '9491002790C', 'B1027D', 'B1050DC', 'B1051D', 'B1583DC', 'B17-127DC', 'B1747D', 'B1799C', 'B8-23DC', 'B874D', 'B879D', 'B885D', 'NB-110', 'W6305-2RSC', 'W6306-2RSC') GROUP BY `p`.`subgrupo` ORDER BY `descripcion_especificacion` ASC
0.0003	SELECT COUNT(p.marca) AS resultado, 'Marca' as nombre, 1 as componente, -3 as orden, m.codigo as codigo, m.descripcion as descripcion_especificacion, '0' as id FROM `productos` `p` LEFT JOIN `marcas` `m` ON `m`.`codigo`=`p`.`marca` WHERE `p`.`codigo` IN('02466', '02699', '02703', '10810', '10811', '10812', '10813', '10815', '10818', '10821', '10822', '10824', '10826', '10828', '10829', '41377', '44676C', '44677C', '44678C', '44679C', '44680C', '44681C', '44682C', '44684C', '44685C', '44686C', '44689C', '44690C', '44692C', '44693C', '44694C', '44695C', '44696C', '44697C', '44699C', '44701C', '44702C', '44703C', '44704C', '44706C', '44709C', '44711C', '44712C', '44713C', '44716C', '44717C', '44718C', '44719C', '44720C', '44721C', '44722C', '46949C', '49147C', '49148C', '49151C', '49153C', '6000-2RSC', '6000-TTC', '6001-2RSC', '6002-2RSC', '6003-2RSC', '6004-2RSC', '6005-2RSC', '608-2RSC', '609-2RSC', '6200-2RSC', '62000-2RSC', '6201-2RSC', '6202-2RSC', '6203-2RSC', '6203-TT', '6204-2RSC', '6205-2RSC', '6209-2RSC', '62201-2RS-C3', '62304-2RSC', '62306-2RS-C3', '629-2RSC', '63001-2RSC', '63003-2RSC', '6301-2RSC', '6302-2RSC', '6303-2RSC', '6305-2RSC', '6306-2RSC', '6333-2RSC', '6336-2RSC', '6902-2RSC', '6903-2RSC', '6904-2RSC', '8-101C', '8-9106C', '949100-3820', '9491002790C', 'B1027D', 'B1050DC', 'B1051D', 'B1583DC', 'B17-127DC', 'B1747D', 'B1799C', 'B8-23DC', 'B874D', 'B879D', 'B885D', 'NB-110', 'W6305-2RSC', 'W6306-2RSC') GROUP BY `p`.`marca` ORDER BY `descripcion_especificacion` ASC
0.0003	SELECT COUNT(p.CategoriaMotor) AS resultado, 'Tipo Motor' as nombre, 1 as componente, -3 as orden, tm.codigo as codigo, tm.descripcion as descripcion_especificacion, '0' as id FROM `productos` `p` LEFT JOIN `tipo_motor` `tm` ON `tm`.`categoria_motor`=`p`.`CategoriaMotor` WHERE `tm`.`descripcion` IS NOT NULL AND `p`.`codigo` IN('02466', '02699', '02703', '10810', '10811', '10812', '10813', '10815', '10818', '10821', '10822', '10824', '10826', '10828', '10829', '41377', '44676C', '44677C', '44678C', '44679C', '44680C', '44681C', '44682C', '44684C', '44685C', '44686C', '44689C', '44690C', '44692C', '44693C', '44694C', '44695C', '44696C', '44697C', '44699C', '44701C', '44702C', '44703C', '44704C', '44706C', '44709C', '44711C', '44712C', '44713C', '44716C', '44717C', '44718C', '44719C', '44720C', '44721C', '44722C', '46949C', '49147C', '49148C', '49151C', '49153C', '6000-2RSC', '6000-TTC', '6001-2RSC', '6002-2RSC', '6003-2RSC', '6004-2RSC', '6005-2RSC', '608-2RSC', '609-2RSC', '6200-2RSC', '62000-2RSC', '6201-2RSC', '6202-2RSC', '6203-2RSC', '6203-TT', '6204-2RSC', '6205-2RSC', '6209-2RSC', '62201-2RS-C3', '62304-2RSC', '62306-2RS-C3', '629-2RSC', '63001-2RSC', '63003-2RSC', '6301-2RSC', '6302-2RSC', '6303-2RSC', '6305-2RSC', '6306-2RSC', '6333-2RSC', '6336-2RSC', '6902-2RSC', '6903-2RSC', '6904-2RSC', '8-101C', '8-9106C', '949100-3820', '9491002790C', 'B1027D', 'B1050DC', 'B1051D', 'B1583DC', 'B17-127DC', 'B1747D', 'B1799C', 'B8-23DC', 'B874D', 'B879D', 'B885D', 'NB-110', 'W6305-2RSC', 'W6306-2RSC') GROUP BY `p`.`CategoriaMotor` ORDER BY `descripcion_especificacion` ASC
0.0003	SELECT distinct(p.codigo) FROM `_productos` `_p` LEFT JOIN `especificaciones_tecnicas_producto` `ep` ON `ep`.`id_producto`=`_p`.`id` LEFT JOIN `especificaciones_tecnicas_atributos` `ea` ON `ep`.`id_especificacion`=`ea`.`id` INNER JOIN `productos` `p` ON `p`.`codigo`=`_p`.`codigo` INNER JOIN `subgrupos` `sgp` ON `sgp`.`codigo`=`p`.`subgrupo` WHERE `_p`.`codigo` IN('02466', '02699', '02703', '10810', '10811', '10812', '10813', '10815', '10818', '10821', '10822', '10824', '10826', '10828', '10829', '41377', '44676C', '44677C', '44678C', '44679C', '44680C', '44681C', '44682C', '44684C', '44685C', '44686C', '44689C', '44690C', '44692C', '44693C', '44694C', '44695C', '44696C', '44697C', '44699C', '44701C', '44702C', '44703C', '44704C', '44706C', '44709C', '44711C', '44712C', '44713C', '44716C', '44717C', '44718C', '44719C', '44720C', '44721C', '44722C', '46949C', '49147C', '49148C', '49151C', '49153C', '6000-2RSC', '6000-TTC', '6001-2RSC', '6002-2RSC', '6003-2RSC', '6004-2RSC', '6005-2RSC', '608-2RSC', '609-2RSC', '6200-2RSC', '62000-2RSC', '6201-2RSC', '6202-2RSC', '6203-2RSC', '6203-TT', '6204-2RSC', '6205-2RSC', '6209-2RSC', '62201-2RS-C3', '62304-2RSC', '62306-2RS-C3', '629-2RSC', '63001-2RSC', '63003-2RSC', '6301-2RSC', '6302-2RSC', '6303-2RSC', '6305-2RSC', '6306-2RSC', '6333-2RSC', '6336-2RSC', '6902-2RSC', '6903-2RSC', '6904-2RSC', '8-101C', '8-9106C', '949100-3820', '9491002790C', 'B1027D', 'B1050DC', 'B1051D', 'B1583DC', 'B17-127DC', 'B1747D', 'B1799C', 'B8-23DC', 'B874D', 'B879D', 'B885D', 'NB-110', 'W6305-2RSC', 'W6306-2RSC') AND `p`.`mostrar` != 'NM' AND ( ( `sgp`.`descripcion` IN('BALERO') ) )
0.0002	SELECT `filtro`, `valor` FROM `filtro_busqueda` WHERE `plataforma` = 'C' AND `status` = 1
0.0002	SELECT SQL_CALC_FOUND_ROWS s.* FROM `sistemas` `s` ORDER BY `descripcion`
0.0002	SELECT * FROM `grupos` `g` ORDER BY `descripcion`
0.0004	SELECT * FROM `subgrupos` `sg` ORDER BY `descripcion`
0.0003	SELECT * FROM `marcas` `m` WHERE `descripcion` NOT IN ('FUERA DE LINEA', 'POWERPLUG', 'POWERTEK') AND activo = 1 ORDER BY `descripcion`
0.0002	`select link_publico, activo, require_popup, require_sidebar_cazador, requiere_timer_relampago from links_publicos where activo = 1`
0.0002	SELECT `s`.`id` FROM `sliderConf` as `s` WHERE `s`.`status` = '1' AND `s`.`tipoSegmento` = '0'
0.0003	SELECT * FROM `sliderImg` WHERE `idSlider` IN('30') ORDER BY `orden`
0.0006	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '02466' OR `codigoSap` = '02466' AND `CategoriaMotor` != ''
0.0005	SELECT `npc`, `cedis`, `existencias`, `precio` FROM `no_resurtibles` WHERE `npc` = '02466' AND `cedis` IS NULL
0.0018	`SELECT * FROM similares WHERE producto LIKE '%02466%'`
0.0108	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`similar` = '02466' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0043	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('B1050DC') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0014	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`similar` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` = 'B1050DC' AND `similares`.`similar` != '02466' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0015	`SELECT * FROM productos_relacionados WHERE producto LIKE '%02466%'`
0.0011	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `productos_relacionados` ON `p`.`codigo` = `productos_relacionados`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `productos_relacionados`.`relacionado` = '02466' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0012	SELECT * FROM `productos` WHERE `productos`.`codigo` = '02466' AND `productos`.`tiene_app` = '1'
0.0011	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '02699' OR `codigoSap` = '02699' AND `CategoriaMotor` != ''
0.0004	SELECT `npc`, `cedis`, `existencias`, `precio` FROM `no_resurtibles` WHERE `npc` = '02699' AND `cedis` IS NULL
0.0038	`SELECT * FROM similares WHERE producto LIKE '%02699%'`
0.0053	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`similar` = '02699' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0039	`SELECT * FROM productos_relacionados WHERE producto LIKE '%02699%'`
0.0020	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `productos_relacionados` ON `p`.`codigo` = `productos_relacionados`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `productos_relacionados`.`relacionado` = '02699' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0013	SELECT * FROM `productos` WHERE `productos`.`codigo` = '02699' AND `productos`.`tiene_app` = '1'
0.0012	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '02703' OR `codigoSap` = '02703' AND `CategoriaMotor` != ''
0.0008	SELECT `npc`, `cedis`, `existencias`, `precio` FROM `no_resurtibles` WHERE `npc` = '02703' AND `cedis` IS NULL
0.0042	`SELECT * FROM similares WHERE producto LIKE '%02703%'`
0.0075	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`similar` = '02703' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0030	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('41377') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0017	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`similar` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` = '41377' AND `similares`.`similar` != '02703' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0022	`SELECT * FROM productos_relacionados WHERE producto LIKE '%02703%'`
0.0014	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `productos_relacionados` ON `p`.`codigo` = `productos_relacionados`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `productos_relacionados`.`relacionado` = '02703' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0010	SELECT * FROM `productos` WHERE `productos`.`codigo` = '02703' AND `productos`.`tiene_app` = '1'
0.0006	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '10810' OR `codigoSap` = '10810' AND `CategoriaMotor` != ''
0.0005	SELECT `npc`, `cedis`, `existencias`, `precio` FROM `no_resurtibles` WHERE `npc` = '10810' AND `cedis` IS NULL
0.0042	`SELECT * FROM similares WHERE producto LIKE '%10810%'`
0.0088	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`similar` = '10810' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0004	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('6000-2RSC') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0020	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`similar` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` = '6000-2RSC' AND `similares`.`similar` != '10810' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0004	`SELECT * FROM productos_relacionados WHERE producto LIKE '%10810%'`
0.0018	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `productos_relacionados` ON `p`.`codigo` = `productos_relacionados`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `productos_relacionados`.`relacionado` = '10810' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0009	SELECT * FROM `productos` WHERE `productos`.`codigo` = '10810' AND `productos`.`tiene_app` = '1'
0.0012	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '10811' OR `codigoSap` = '10811' AND `CategoriaMotor` != ''
0.0007	SELECT `npc`, `cedis`, `existencias`, `precio` FROM `no_resurtibles` WHERE `npc` = '10811' AND `cedis` IS NULL
0.0041	`SELECT * FROM similares WHERE producto LIKE '%10811%'`
0.0101	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`similar` = '10811' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0034	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('6305-2RSC') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0020	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`similar` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` = '6305-2RSC' AND `similares`.`similar` != '10811' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0027	`SELECT * FROM productos_relacionados WHERE producto LIKE '%10811%'`
0.0017	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `productos_relacionados` ON `p`.`codigo` = `productos_relacionados`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `productos_relacionados`.`relacionado` = '10811' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0010	SELECT * FROM `productos` WHERE `productos`.`codigo` = '10811' AND `productos`.`tiene_app` = '1'
0.0010	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '10812' OR `codigoSap` = '10812' AND `CategoriaMotor` != ''
0.0005	SELECT `npc`, `cedis`, `existencias`, `precio` FROM `no_resurtibles` WHERE `npc` = '10812' AND `cedis` IS NULL
0.0041	`SELECT * FROM similares WHERE producto LIKE '%10812%'`
0.0099	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`similar` = '10812' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0039	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('6200-2RSC') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0020	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`similar` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` = '6200-2RSC' AND `similares`.`similar` != '10812' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0027	`SELECT * FROM productos_relacionados WHERE producto LIKE '%10812%'`
0.0019	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `productos_relacionados` ON `p`.`codigo` = `productos_relacionados`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `productos_relacionados`.`relacionado` = '10812' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0012	SELECT * FROM `productos` WHERE `productos`.`codigo` = '10812' AND `productos`.`tiene_app` = '1'
0.0004	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '10813' OR `codigoSap` = '10813' AND `CategoriaMotor` != ''
0.0003	SELECT `npc`, `cedis`, `existencias`, `precio` FROM `no_resurtibles` WHERE `npc` = '10813' AND `cedis` IS NULL
0.0040	`SELECT * FROM similares WHERE producto LIKE '%10813%'`
0.0100	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`similar` = '10813' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0006	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('6003-2RSC') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0021	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`similar` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` = '6003-2RSC' AND `similares`.`similar` != '10813' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0003	`SELECT * FROM productos_relacionados WHERE producto LIKE '%10813%'`
0.0019	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `productos_relacionados` ON `p`.`codigo` = `productos_relacionados`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `productos_relacionados`.`relacionado` = '10813' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0007	SELECT * FROM `productos` WHERE `productos`.`codigo` = '10813' AND `productos`.`tiene_app` = '1'
0.0005	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '10815' OR `codigoSap` = '10815' AND `CategoriaMotor` != ''
0.0003	SELECT `npc`, `cedis`, `existencias`, `precio` FROM `no_resurtibles` WHERE `npc` = '10815' AND `cedis` IS NULL
0.0041	`SELECT * FROM similares WHERE producto LIKE '%10815%'`
0.0100	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`similar` = '10815' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0005	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('608-2RSC') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0020	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`similar` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` = '608-2RSC' AND `similares`.`similar` != '10815' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0004	`SELECT * FROM productos_relacionados WHERE producto LIKE '%10815%'`
0.0019	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `productos_relacionados` ON `p`.`codigo` = `productos_relacionados`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `productos_relacionados`.`relacionado` = '10815' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0009	SELECT * FROM `productos` WHERE `productos`.`codigo` = '10815' AND `productos`.`tiene_app` = '1'
0.0005	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '10818' OR `codigoSap` = '10818' AND `CategoriaMotor` != ''
0.0002	SELECT `npc`, `cedis`, `existencias`, `precio` FROM `no_resurtibles` WHERE `npc` = '10818' AND `cedis` IS NULL
0.0043	`SELECT * FROM similares WHERE producto LIKE '%10818%'`
0.0100	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`similar` = '10818' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0037	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('6204-2RSC') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0021	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`similar` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` = '6204-2RSC' AND `similares`.`similar` != '10818' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0004	`SELECT * FROM productos_relacionados WHERE producto LIKE '%10818%'`
0.0017	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `productos_relacionados` ON `p`.`codigo` = `productos_relacionados`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `productos_relacionados`.`relacionado` = '10818' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0014	SELECT * FROM `productos` WHERE `productos`.`codigo` = '10818' AND `productos`.`tiene_app` = '1'
0.0013	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '10821' OR `codigoSap` = '10821' AND `CategoriaMotor` != ''
0.0006	SELECT `npc`, `cedis`, `existencias`, `precio` FROM `no_resurtibles` WHERE `npc` = '10821' AND `cedis` IS NULL
0.0039	`SELECT * FROM similares WHERE producto LIKE '%10821%'`
0.0106	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`similar` = '10821' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0033	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('6336-2RSC') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0022	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`similar` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` = '6336-2RSC' AND `similares`.`similar` != '10821' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0030	`SELECT * FROM productos_relacionados WHERE producto LIKE '%10821%'`
0.0020	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `productos_relacionados` ON `p`.`codigo` = `productos_relacionados`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `productos_relacionados`.`relacionado` = '10821' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0014	SELECT * FROM `productos` WHERE `productos`.`codigo` = '10821' AND `productos`.`tiene_app` = '1'
0.0011	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '10822' OR `codigoSap` = '10822' AND `CategoriaMotor` != ''
0.0008	SELECT `npc`, `cedis`, `existencias`, `precio` FROM `no_resurtibles` WHERE `npc` = '10822' AND `cedis` IS NULL
0.0042	`SELECT * FROM similares WHERE producto LIKE '%10822%'`
0.0031	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`similar` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` = '10822' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0042	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('62304-2RSC') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0052	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` != '10822' AND `similares`.`similar` = '62304-2RSC' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0031	`SELECT * FROM productos_relacionados WHERE producto LIKE '%10822%'`
0.0022	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `productos_relacionados` ON `p`.`codigo` = `productos_relacionados`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `productos_relacionados`.`relacionado` = '10822' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0015	SELECT * FROM `productos` WHERE `productos`.`codigo` = '10822' AND `productos`.`tiene_app` = '1'
0.0012	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '10824' OR `codigoSap` = '10824' AND `CategoriaMotor` != ''
0.0007	SELECT `npc`, `cedis`, `existencias`, `precio` FROM `no_resurtibles` WHERE `npc` = '10824' AND `cedis` IS NULL
0.0040	`SELECT * FROM similares WHERE producto LIKE '%10824%'`
0.0104	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`similar` = '10824' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0045	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('6004-2RSC') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0025	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`similar` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` = '6004-2RSC' AND `similares`.`similar` != '10824' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0039	`SELECT * FROM productos_relacionados WHERE producto LIKE '%10824%'`
0.0021	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `productos_relacionados` ON `p`.`codigo` = `productos_relacionados`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `productos_relacionados`.`relacionado` = '10824' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0013	SELECT * FROM `productos` WHERE `productos`.`codigo` = '10824' AND `productos`.`tiene_app` = '1'
0.0005	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '02466' OR `codigoSap` = '02466' AND `CategoriaMotor` != ''
0.0002	`SELECT * FROM similares WHERE producto LIKE '%02466%'`
0.0004	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`similar` = '02466' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0003	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('B1050DC') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0003	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`similar` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` = 'B1050DC' AND `similares`.`similar` != '02466' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0009	SELECT * FROM `productos` WHERE `productos`.`codigo` = '02466' AND `productos`.`tiene_app` = '1'
0.0006	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '02699' OR `codigoSap` = '02699' AND `CategoriaMotor` != ''
0.0004	`SELECT * FROM similares WHERE producto LIKE '%02699%'`
0.0003	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`similar` = '02699' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0010	SELECT * FROM `productos` WHERE `productos`.`codigo` = '02699' AND `productos`.`tiene_app` = '1'
0.0006	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '02703' OR `codigoSap` = '02703' AND `CategoriaMotor` != ''
0.0003	`SELECT * FROM similares WHERE producto LIKE '%02703%'`
0.0005	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`similar` = '02703' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0004	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('41377') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0005	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`similar` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` = '41377' AND `similares`.`similar` != '02703' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0008	SELECT * FROM `productos` WHERE `productos`.`codigo` = '02703' AND `productos`.`tiene_app` = '1'
0.0005	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '10810' OR `codigoSap` = '10810' AND `CategoriaMotor` != ''
0.0003	`SELECT * FROM similares WHERE producto LIKE '%10810%'`
0.0004	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`similar` = '10810' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0003	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('6000-2RSC') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0004	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`similar` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` = '6000-2RSC' AND `similares`.`similar` != '10810' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0010	SELECT * FROM `productos` WHERE `productos`.`codigo` = '10810' AND `productos`.`tiene_app` = '1'
0.0005	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '10811' OR `codigoSap` = '10811' AND `CategoriaMotor` != ''
0.0002	`SELECT * FROM similares WHERE producto LIKE '%10811%'`
0.0003	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`similar` = '10811' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0003	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('6305-2RSC') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0006	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`similar` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` = '6305-2RSC' AND `similares`.`similar` != '10811' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0009	SELECT * FROM `productos` WHERE `productos`.`codigo` = '10811' AND `productos`.`tiene_app` = '1'
0.0003	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '10812' OR `codigoSap` = '10812' AND `CategoriaMotor` != ''
0.0004	`SELECT * FROM similares WHERE producto LIKE '%10812%'`
0.0004	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`similar` = '10812' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0003	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('6200-2RSC') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0003	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`similar` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` = '6200-2RSC' AND `similares`.`similar` != '10812' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0010	SELECT * FROM `productos` WHERE `productos`.`codigo` = '10812' AND `productos`.`tiene_app` = '1'
0.0004	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '10813' OR `codigoSap` = '10813' AND `CategoriaMotor` != ''
0.0003	`SELECT * FROM similares WHERE producto LIKE '%10813%'`
0.0005	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`similar` = '10813' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0005	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('6003-2RSC') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0004	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`similar` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` = '6003-2RSC' AND `similares`.`similar` != '10813' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0010	SELECT * FROM `productos` WHERE `productos`.`codigo` = '10813' AND `productos`.`tiene_app` = '1'
0.0005	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '10815' OR `codigoSap` = '10815' AND `CategoriaMotor` != ''
0.0003	`SELECT * FROM similares WHERE producto LIKE '%10815%'`
0.0003	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`similar` = '10815' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0003	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('608-2RSC') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0003	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`similar` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` = '608-2RSC' AND `similares`.`similar` != '10815' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0009	SELECT * FROM `productos` WHERE `productos`.`codigo` = '10815' AND `productos`.`tiene_app` = '1'
0.0003	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '10818' OR `codigoSap` = '10818' AND `CategoriaMotor` != ''
0.0004	`SELECT * FROM similares WHERE producto LIKE '%10818%'`
0.0003	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`similar` = '10818' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0003	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('6204-2RSC') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0004	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`similar` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` = '6204-2RSC' AND `similares`.`similar` != '10818' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0011	SELECT * FROM `productos` WHERE `productos`.`codigo` = '10818' AND `productos`.`tiene_app` = '1'
0.0005	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '10821' OR `codigoSap` = '10821' AND `CategoriaMotor` != ''
0.0005	`SELECT * FROM similares WHERE producto LIKE '%10821%'`
0.0004	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`similar` = '10821' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0003	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('6336-2RSC') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0003	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`similar` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` = '6336-2RSC' AND `similares`.`similar` != '10821' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0010	SELECT * FROM `productos` WHERE `productos`.`codigo` = '10821' AND `productos`.`tiene_app` = '1'
0.0003	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '10822' OR `codigoSap` = '10822' AND `CategoriaMotor` != ''
0.0002	`SELECT * FROM similares WHERE producto LIKE '%10822%'`
0.0003	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`similar` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` = '10822' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0003	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('62304-2RSC') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0003	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` != '10822' AND `similares`.`similar` = '62304-2RSC' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0010	SELECT * FROM `productos` WHERE `productos`.`codigo` = '10822' AND `productos`.`tiene_app` = '1'
0.0005	SELECT `codigo` as `producto`, `CategoriaMotor` as `tipo` FROM `productos` WHERE `codigo` = '10824' OR `codigoSap` = '10824' AND `CategoriaMotor` != ''
0.0003	`SELECT * FROM similares WHERE producto LIKE '%10824%'`
0.0004	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, IF(outlet.codigo IS NOT NULL, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`producto` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`similar` = '10824' AND (`p`.`codigo` NOT IN (SELECT codigo FROM outlet WHERE tipo = 'REMATES')) GROUP BY `p`.`codigo`
0.0004	SELECT p.*, v.producto AS v_producto, v.marca AS v_marca, v.subgrupo AS v_subgrupo, v.grupo AS v_grupo FROM prpromociones p JOIN prvariables v ON v.promocion = p.promocion JOIN productos prod ON prod.codigo IN ('6004-2RSC') WHERE ( v.producto = prod.codigo OR v.marca = prod.marca OR v.marca = 'ALL' OR v.subgrupo = prod.subgrupo OR v.grupo = prod.grupo) AND p.desde <= '2026-06-13' AND p.hasta >= '2026-06-13' AND p.status = 1 GROUP BY v.promocion,v.sec ORDER BY p.tipopromo
0.0004	SELECT SQL_CALC_FOUND_ROWS espxprod.esp1 as prod_esp1, marcas.descripcion as m_desc, marcas.codigo as m_codigo, 0 as promocion, descxprod.descripcion_l as prod_dcompl, IFNULL(descxprod.descripcion_l, p.descripcion) AS descripcion_unificada, p.*, p_shop.url_shop as url_npc, outlet.precio as outlet_precio, outlet.cantidad_disponible as outlet_disponible, outlet.tipo as outlet_tipo, IF(outlet.codigo IS NOT NULL AND outlet.cantidad_disponible > 0 AND outlet.precio > 0, 'SI', 'NO') existe FROM `productos` `p` JOIN `similares` ON `p`.`codigo` = `similares`.`similar` LEFT JOIN `marcas` ON `marcas`.`codigo` = `p`.`marca` LEFT JOIN `sistemas` ON `sistemas`.`codigo` = `p`.`sistema` LEFT JOIN `grupos` ON `grupos`.`codigo` = `p`.`grupo` LEFT JOIN `subgrupos` ON `subgrupos`.`codigo` = `p`.`subgrupo` LEFT JOIN `tipo_motor` ON `tipo_motor`.`categoria_motor` = `p`.`CategoriaMotor` LEFT JOIN `tiposiva` ON `tiposiva`.`tipo_iva` = `p`.`iva` LEFT JOIN `descxprod` ON `descxprod`.`producto` = `p`.`codigo` LEFT JOIN `productos_m_shop` `p_shop` ON `p_shop`.`codigo` = `p`.`codigoSap` LEFT JOIN `outlet` ON `outlet`.`codigo` = `p`.`codigo` LEFT JOIN `espxprod` ON `espxprod`.`producto` = `p`.`codigo` WHERE `similares`.`producto` = '6004-2RSC' AND `similares`.`similar` != '10824' AND `p`.`status` = '00' GROUP BY `p`.`codigo`
0.0011	SELECT * FROM `productos` WHERE `productos`.`codigo` = '10824' AND `productos`.`tiene_app` = '1'

BASE DE DATOS: (Noresurtibles_m:$mssql) CONSULTAS: 1 (0.0010 segundos) (Ocultar)

0.0010 SELECT CASE WHEN (@@OPTIONS | 256) = @@OPTIONS THEN 1 ELSE 0 END AS qi

CABECERAS HTTP (Mostrar)

DATOS DE SESIÓN (Mostrar)

__ci_last_regenerate	1781354459
clase	autopartes
USER_URL	autopartes/balero/Todo
site_lang	spanish
sistema
grupo
subgrupo	020309
marca
tipo_outlet
nveh_year
nveh_marca
nveh_modelo
veh_submodelo
nveh_motor
ws_fail	1

VARIABLES DE CONFIGURACIÓN (Mostrar)

secure_emails	Array ( [protocol] => smtp [smtp_host] => sandbox.smtp.mailtrap.io [smtp_port] => 2525 [smtp_user] => 30dc96b9fb2265 [smtp_pass] => 6a6552df95c66a [crlf] => [newline] => )
base_url	https://qav3.ciosa.net/
index_page
uri_protocol	REQUEST_URI
url_suffix
language	spanish
charset	UTF-8
enable_hooks	1
subclass_prefix	MY_
composer_autoload	vendor/autoload.php
permitted_uri_chars	a-z 0-9~%.:_\-
enable_query_strings
controller_trigger	c
function_trigger	m
directory_trigger	d
allow_get_array	1
log_threshold	1
log_path
log_file_extension
log_file_permissions	420
log_date_format	Y-m-d H:i:s
error_views_path
cache_path
cache_query_string
encryption_key	cio.sa
sess_driver	files
sess_cookie_name	ci_session
sess_expiration	29600
sess_expire_on_close	1
sess_encrypt_cookie
sess_use_database	1
sess_match_useragent
sess_save_path	/ci_sessions
sess_match_ip
sess_time_to_update	300
sess_regenerate_destroy
cookie_prefix
cookie_domain
cookie_path	/
cookie_secure
cookie_httponly
standardize_newlines
global_xss_filtering
csrf_protection
csrf_token_name	csrf_test_name
csrf_cookie_name	csrf_cookie_name
csrf_expire	7200
csrf_regenerate	1
csrf_exclude_uris	Array ( )
compress_output
time_reference	local
rewrite_short_tags
proxy_ips
header_assets	Array ( [js] => Array ( ) [css] => Array ( ) )
CALIXTA_URL	https://api1.calixtaondemand.com/Controller.php/__a/sms.send.remote.ol.sa
CALIXTA_CTE	48865
CALIXTA_ENCPWD	7288943302200e44604b39dbb3d2fd8336a519433abe6f4e300329532cba42e7
CALIXTA_EMAIL	juan_flores@ciosa.com
no_promo	Array ( [0] => 0010000425 [1] => 0010000459 [2] => 0010001451 [3] => 0002000432 [4] => 0010000462 [5] => 0010002279 [6] => 0010003342 [7] => 0010002475 [8] => 0010002252 [9] => 0010003171 [10] => 0010000066 [11] => 0010000425 [12] => 0010000043 [13] => 0010000914 )
c30	Array ( [0] => 0010004677 )
disp	Array ( [0] => 0010008628 [1] => 0010002290 [2] => 0010006298 [3] => 0010006590 [4] => 0002001514 [5] => 0010006354 [6] => 0010001501 [7] => 0010003012 [8] => 0010004357 [9] => 0010005152 [10] => 0010006940 [11] => 0010001465 [12] => 0010002000 [13] => 0010002019 [14] => 0010007001 [15] => 0010000421 [16] => 0010001821 [17] => 0010001992 [18] => 0010001986 [19] => 0010000147 [20] => 0010000464 [21] => 0010000458 [22] => 0010002481 [23] => 0010006096 [24] => 0010007095 [25] => 0010002552 [26] => 0010002540 [27] => 0010002535 [28] => 0010002498 [29] => 0010002518 [30] => 0010003852 [31] => 0010003566 [32] => 0010007862 [33] => 0010002032 [34] => 0010002049 [35] => 0010006115 [36] => 0010002040 [37] => 0010006640 [38] => 0010007276 [39] => 0010007020 [40] => 0010005098 [41] => 0010007325 [42] => 0010006724 [43] => 0010006703 [44] => 0010005095 [45] => 0010007195 [46] => 0010007906 [47] => 0010002031 [48] => 0010003539 [49] => 0010004357 [50] => 0010006122 [51] => 0010006832 [52] => 0010005355 [53] => 0010003167 [54] => 0010002385 [55] => 0010005251 [56] => 0010002390 [57] => 0010006641 [58] => 0030000216 [59] => 0010002311 [60] => 0010002242 [61] => 0010008997 [62] => 0010002396 [63] => 0010007502 [64] => 0010000143 [65] => 0010000710 [66] => 0010007926 [67] => 0010005804 [68] => 0010009136 [69] => 0010008708 [70] => 0010002552 [71] => 0010002587 [72] => 0010002607 [73] => 0010002549 [74] => 0010002498 [75] => 0010002537 [76] => 0010007733 [77] => 0010002652 [78] => 0010007317 [79] => 0010007257 [80] => 0010002579 [81] => 0010007001 [82] => 0010008216 [83] => 0010000610 [84] => 0010001216 [85] => 0010006592 [86] => 0010001198 [87] => 0010004663 [88] => 0002000401 [89] => 0010000996 [90] => 0010001071 [91] => 0010007386 [92] => 0010006361 )

Eléctrico

Fuel Injection

Mecánico

Accesorios

Autos Híbridos y Eléctricos

Filtros

Sistema

Grupo

Subgrupo

Marca

Tipo de producto

Productos

BALERO DE ALTERNADOR ( 1010504 ) HITACHI TSURU TSUBAME LADO COLECTOR ALTERNADOR FORD 6G CON SEGURO BALERO DE ALTERNADOR ( 1010504 ) HITACHI TSURU TSUBAME LADO COLECTOR ALTERNADOR FORD 6G CON SEGURO

BUJE RODILLO PARA CAMPANA DE MARCHA DELCO SERIES 5MT SD250 SD255 SD260 BUJE RODILLO PARA CAMPANA DE MARCHA DELCO SERIES 5MT SD250 SD255 SD260

RODILLO PARA ALTERNADOR DELCO SERIES 22SI 27SI RODILLO PARA ALTERNADOR DELCO SERIES 22SI 27SI

BALERO ( 6000 ) ALTERNADOR DELCO CS130 CS121 LADO COLECTOR DELGADO SELLO HULE BALERO ( 6000 ) ALTERNADOR DELCO CS130 CS121 LADO COLECTOR DELGADO SELLO HULE

BALERO ( 6305 ) ALTERNADOR MOTOROLA 84 AMPS SELLO HULE BALERO ( 6305 ) ALTERNADOR MOTOROLA 84 AMPS SELLO HULE

BALERO ( 6200 ) ALTERNADORES MOTOROLA PARIS RHONE MARCHA DELCO SERIES 28 MT NIPPONDENSO OSGR SELLO HULE BALERO ( 6200 ) ALTERNADORES MOTOROLA PARIS RHONE MARCHA DELCO SERIES 28 MT NIPPONDENSO OSGR SELLO HULE

BALERO ( 6103 ) ARMADURA MARCHA 28MT LADO FLECHA SELLO HULE BALERO ( 6103 ) ARMADURA MARCHA 28MT LADO FLECHA SELLO HULE

BALERO ( 608 ) MARCHA DELCO PMGR LADO COLECTOR MARCHA NIPPONDENSO LADO COLECTOR SELLO HULE BALERO ( 608 ) MARCHA DELCO PMGR LADO COLECTOR MARCHA NIPPONDENSO LADO COLECTOR SELLO HULE

BALERO ( 6204 ) ALTERNADOR RENAULT SELLO HULE BALERO ( 6204 ) ALTERNADOR RENAULT SELLO HULE

BALERO ( 9491003360 ) ALTERNADOR CHRYSLER NIPPONDENSO BALERO ( 9491003360 ) ALTERNADOR CHRYSLER NIPPONDENSO

BALERO LEECENEVILLE NIPPONDENSO BALERO LEECENEVILLE NIPPONDENSO

BALERO MARCHA NIPPONDENSO SELLO HULE BALERO MARCHA NIPPONDENSO SELLO HULE