SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340627 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340627 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260815,427523,25637,739417,728098,789340,657288,826223,436109,721210,25416,628870,1013421,12975,157421,412050,610028,1034816,248761,487904,845978,360545,793848,260361,952804,756556,390547,785688,229849,888761,249476,433539,768607,520182,564265,645914,201462,197603,901620,644055,862864,426797,956450,151072,400688,96809,411877,272923,750672,480585,98337,866806,696382,427352,882743,725088,731104,828683,1765,869894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340627 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340627 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]