SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 590060 LIMIT 1 [ RunTime:0.000524s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 590060 [ RunTime:0.001996s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314503,253542,244530,347947,121227,684553,930831,585560,755601,636774,553287,306468,324901,338417,704894,683750,810451,44092,217523,964758,231330,831139,490444,383059,666536,186398,382956,940453,653445,239392,334533,518135,102141,434351,260166,807748,774100,617811,695151,945461,590217,927797,154647,275582,56983,839814,1000087,108221,397809,741292,311728,338338,1027588,1039940,863897,1028168,940186,912560,383619,602134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 590060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 590060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]