SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001896s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495015 LIMIT 1 [ RunTime:0.000869s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495015 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323498,856998,172842,201666,915246,525476,1032588,336091,786948,214558,948578,712538,404564,181814,35460,226130,406261,994751,820769,785152,958664,1042994,815081,859299,962501,3888,183217,555969,880805,487938,1021941,572838,401512,692316,589359,322352,315612,1023924,569794,1016070,515392,374548,284695,400082,986096,565101,453125,432389,181969,324594,612229,592528,268657,981306,630158,145150,760318,514590,267686,235409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001655s ]