SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317094 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317094 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37516,881564,396142,944082,606498,878389,787615,299055,957545,238552,737468,1022853,443688,725048,740074,335531,170536,969968,4377,532072,122017,212839,1032643,617538,867358,1018898,760756,720458,935263,315001,420328,364831,827916,1027393,695408,835970,77430,347863,92797,771248,49668,41605,96756,446270,112162,756206,344545,731967,566154,278362,1016797,233982,209570,497754,970796,413391,922552,340723,919081,72209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]