SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367481 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367481 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113776,366243,836019,204438,1044895,581060,344996,871783,410625,50230,496393,599598,42590,154894,217389,847054,917279,64583,461345,744720,842098,110022,824372,9332,150133,116662,966833,971929,64422,684564,58619,301885,312842,121046,271806,885688,576053,347711,108609,118826,796163,379475,490056,824022,780336,626245,878598,865824,344821,918479,302486,977996,662445,769893,187410,929218,71288,190703,896484,171294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]