SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519406 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519406 [ RunTime:0.002118s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483520,275217,361425,677139,379060,81294,895376,933450,618479,103551,1010681,954911,248777,990656,867346,935228,614508,119677,340846,516481,510841,194079,762548,313091,689813,946274,416055,286852,890729,850948,56316,516690,933301,735023,157317,490904,54135,516500,495265,504870,769387,200591,661693,318456,12661,272842,344550,980747,924771,165839,148008,962570,575574,423423,482522,254782,72970,730553,328059,424655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]