SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343252 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343252 [ RunTime:0.003738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (785081,44126,446190,152847,377274,110164,109103,586888,18337,136133,599997,686015,394110,690427,997590,294191,751356,569670,868500,772310,439085,85967,612065,306029,713152,296820,386943,325542,609289,716142,206049,459942,240313,496649,113858,209098,737737,953381,315295,598652,94516,156558,896821,702110,894120,887321,371881,390367,150516,273224,291197,424574,311110,616990,546001,940645,261348,644564,841784,356111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343252 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343252 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]