SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002447s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281760 LIMIT 1 [ RunTime:0.000532s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281760 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (164308,723031,854537,69463,730394,206171,166084,17302,161742,442578,1029198,544582,552806,621366,963690,676863,614979,763103,375739,50197,1028141,955613,128092,472741,620440,970967,509116,47422,720741,361926,839676,12160,117139,175503,393041,936564,295466,481595,522114,493912,519871,815207,1047110,75973,276033,273327,160684,431472,17867,848333,2334,1020104,739347,485542,184700,418177,166735,335722,873015,906005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000737s ]