SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 124838 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 124838 [ RunTime:0.002035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68306,309080,989203,110291,107124,176280,199583,486608,333853,572656,425074,256943,823481,996611,520090,483369,53601,333971,76275,781256,1031445,486034,745386,62375,1034447,227790,555660,917141,21565,313661,88420,558712,966036,330853,670775,1000113,199348,49395,718173,304376,502680,869588,741782,908235,687842,807087,175846,930175,48276,290098,849422,894989,448440,279147,917000,920003,848108,260344,947590,62130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 124838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 124838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]