SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305866 LIMIT 1 [ RunTime:0.000631s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305866 [ RunTime:0.005026s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179963,900647,1032360,481285,44065,656789,330279,923212,150771,688004,122849,622346,638787,937014,814197,697792,208388,280894,54636,884456,12109,178157,294901,1041541,784551,580691,191296,229836,245609,867193,473960,1010417,930689,793745,622269,746011,180055,807923,753241,831327,668878,831425,253686,993008,559026,348868,602372,319093,317099,129201,651557,1017501,276108,15546,684608,269610,121924,671028,524273,569650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305866 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305866 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001302s ]