SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201702 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201702 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316278,21094,383005,842192,320983,797536,272215,152679,726130,140742,539402,468988,538815,825715,605256,610381,899226,269905,875500,563272,283593,473706,786245,808163,472477,937771,69634,940481,1035987,589597,847642,691287,171568,941475,550385,183326,413341,207409,590785,303177,379683,425839,622295,247558,108293,402598,51001,725340,283090,917465,50403,138141,414892,689090,14108,972120,852604,603278,522966,127976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201702 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201702 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000724s ]