SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 905309 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 905309 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (87257,961453,528918,931200,211606,223367,319305,35484,106020,563724,208500,254016,269130,1010926,39364,1032134,38389,283870,127022,273526,180794,503286,544838,122759,1028592,49591,175403,877212,295308,372101,519020,559761,77649,70771,691255,204058,938933,870893,21442,605803,302201,779181,858593,249145,200410,662300,769701,1020931,752153,1002902,618700,908002,258127,1035859,747496,211726,637777,486785,32453,359506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 905309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 905309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]