SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 191905 LIMIT 1 [ RunTime:0.000539s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191905 [ RunTime:0.002960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904641,176006,62097,411917,536946,631016,889683,102727,574168,1015814,781199,977966,734638,553193,1040210,261062,370024,692944,560430,486100,98475,7013,315406,189848,276732,700371,67194,764747,777450,695232,296054,429390,540489,160084,85629,668805,343187,275184,575061,414641,745303,518267,921218,592656,274916,654653,82366,962563,372126,705843,79147,646555,1023881,408951,315332,544926,193763,585330,16069,730991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]