SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485590 LIMIT 1 [ RunTime:0.001563s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485590 [ RunTime:0.002746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028269,829803,1016288,1030277,808933,659076,1018914,436540,610017,228617,930098,321170,255508,580878,1003224,213647,375098,921616,996905,166081,617408,363882,270540,827857,269887,248678,117438,444505,990617,824824,244379,756076,556838,768001,343607,780248,303181,362795,89096,467564,500074,729901,776964,183023,989001,888582,291340,1004914,427610,987836,149388,993863,1039814,298329,221823,603637,341057,621330,645302,681125) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.033754s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002234s ]