SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598821 LIMIT 1 [ RunTime:0.002081s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598821 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399852,381229,185387,44994,725217,394085,1033479,891824,32490,749447,1025949,843325,940649,913387,381308,478115,1029181,422235,575769,960417,159218,926119,541948,924935,966495,224762,853350,593630,905125,114138,434754,487462,812880,45710,321882,120953,675960,795415,933547,851450,754661,944351,116153,109013,936727,47331,650983,286021,648686,596827,104890,36388,198969,350609,279242,897473,620507,928564,14078,60711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]