SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102254 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102254 [ RunTime:0.002400s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292882,27481,179476,256467,725820,389911,132896,320955,656193,275336,995212,720010,297138,157642,105370,704539,151963,385693,695804,234699,61541,125418,979791,109001,75474,949391,314943,237950,889727,998286,540250,387543,707541,642302,137982,953557,643182,218506,647451,261909,461199,371469,536106,266114,171236,99520,287570,998320,881262,637846,408874,438312,261275,781041,904422,725103,534999,853467,506850,838935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]