SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455186 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455186 [ RunTime:0.002507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319611,87109,812135,594281,744961,806976,967537,191180,495195,776428,413148,624895,591435,756323,649562,119041,673158,594901,1035870,22926,770244,408858,654643,502190,327777,210767,291480,545180,111173,761430,417894,1015623,301410,452460,374438,324628,321528,346895,789044,395672,411450,470782,980544,878640,90169,3895,956660,413239,624630,589360,861187,36465,274338,389110,833801,110446,715575,301890,966819,709579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455186 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455186 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]