SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428151 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428151 [ RunTime:0.001396s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (970480,477532,48377,125151,950150,679396,874033,918514,311677,232729,1006316,739343,395378,119679,1023480,541399,785028,115917,468171,509134,534900,66788,212255,387999,223086,657601,712704,919334,554151,1047649,655026,639400,22021,580868,599261,659310,724942,591957,582912,244229,316798,941028,82573,525400,913858,610529,119767,54543,694175,957650,804205,508569,1008128,242719,400934,409981,146829,770949,619099,1029730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]