SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426011 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426011 [ RunTime:0.006117s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (641809,528580,357752,424101,539809,200414,439482,784698,1010967,1023054,1025910,216801,1007100,138463,45676,283678,634722,780329,338134,980717,135456,950328,203367,80678,869105,1025965,63356,147040,78970,577768,177928,384636,790486,214447,938862,324262,995539,720826,44460,219269,486095,61062,401801,1029492,57988,147132,588106,591988,204464,11007,250139,412556,692375,869241,821610,532710,418559,291852,802092,762668) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001789s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]