SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431891 LIMIT 1 [ RunTime:0.001138s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431891 [ RunTime:0.002156s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (175083,991606,130457,603548,797960,224990,761,750261,614468,135046,613959,468640,35896,989418,845961,316050,276327,1028179,194627,397072,554409,377666,859253,269432,912175,234261,114481,454514,415011,521162,858995,120351,3298,302185,840664,123065,387539,225853,22128,395064,380368,119544,488112,494103,215965,462973,792175,436764,570896,446574,302050,32694,896568,16589,511038,105227,778897,346912,618789,412542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]