SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4368 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4368 [ RunTime:0.002620s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888849,255576,975161,887459,369881,548977,240880,69012,342566,76855,1004239,561459,916427,596737,318538,404621,1002968,349348,19432,835326,224770,113070,443135,413097,996499,1005226,467816,678528,718423,87393,894858,559431,640864,357189,183722,719814,313440,175090,136582,984242,229997,151555,441888,884444,340022,677645,686419,301709,856976,381353,292823,904893,42463,587988,877050,431891,422623,444564,176862,713590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4368 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000696s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4368 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]