SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4885 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4885 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (941103,732283,30384,439005,40207,421741,900595,572435,935803,902091,902867,837417,671201,238189,1006869,382048,612429,311357,1037996,173822,895566,205793,719225,76028,491027,140864,528091,279681,180368,291312,652767,730647,839456,574240,640258,85971,653355,9277,262558,880926,991526,508299,419657,917857,680374,540251,648994,313217,716202,472349,801019,1043645,420949,372060,832051,1008072,399989,907574,144703,579745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4885 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000875s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4885 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001009s ]