SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5400 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5400 [ RunTime:0.002465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (33210,848299,88396,38800,771111,654207,310785,863882,734984,968658,1044090,398948,414569,340523,197909,241907,450334,737824,856664,731927,68502,519240,151647,808063,650149,998184,746391,440112,977765,366738,69145,108932,929430,253296,309000,230129,790435,116531,900192,430177,462757,602560,246145,426987,296018,634095,708929,328757,950227,436404,1032618,995508,180538,259748,990455,546757,903144,413555,83314,371248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]