SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508582 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508582 [ RunTime:0.003813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (92079,342439,1010529,1010487,144433,926539,811659,537736,278504,398337,93944,571136,722561,14291,324453,98639,393404,1027517,965938,822802,420381,554864,868982,193331,996441,917503,306651,521188,217529,240969,913645,648762,225511,703003,611564,1042673,603790,759791,513595,622811,169286,60797,490819,205111,917260,766510,333524,95094,545530,823312,229586,276117,864862,802863,947391,74102,475566,699133,134005,317453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]