SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002996s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482091 LIMIT 1 [ RunTime:0.000777s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482091 [ RunTime:0.004383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640628,920239,1036471,350435,185385,626924,510723,209751,647980,324065,872130,415307,328891,334109,522081,103175,1044795,1012882,3908,341981,491337,396527,870030,59792,171139,967018,33270,184669,35979,256953,418700,788670,575067,906987,987724,70998,272152,73205,1030772,689812,594517,293240,577402,647819,597570,368615,107801,27643,224179,1001680,512696,34689,506299,713095,31589,730575,124478,664553,613326,170840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005917s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000768s ]