SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003081s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485173 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485173 [ RunTime:0.007302s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044462,263837,585054,752093,801007,355083,262746,737534,576063,672132,396041,294527,750344,708396,576402,181367,227107,49926,1013566,75560,823190,373814,229767,574241,134199,134825,497699,639699,150447,852623,434506,710432,510459,891572,793247,1022203,873430,428957,311693,761905,311430,763722,433704,469863,617741,26095,166632,187525,159523,1038014,788385,964202,566644,287552,522423,534487,734178,400902,957271,217333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001698s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485173 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002921s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485173 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]