SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292158 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292158 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822901,1013011,580232,578169,436355,1023487,142760,400628,1000151,726015,536650,719490,80400,632147,1005686,271317,878750,708934,764363,802400,746571,546790,805509,265445,440735,34549,536164,944423,102815,70786,973708,819642,186434,991133,880289,677986,320503,281493,425228,908615,706600,758629,11435,97453,898843,188127,568040,723166,66398,306218,665537,638679,138224,477107,934044,210735,544205,793524,674363,758100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]