SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.011720s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012887 LIMIT 1 [ RunTime:0.005510s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012887 [ RunTime:0.004678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (735105,405647,463124,953406,964999,987447,1013060,654203,28862,145221,1019811,139365,904497,382626,389202,1030993,588799,928039,787105,1009283,458968,29832,905688,934409,21727,330097,228102,684502,748846,816153,1007228,963998,611974,833190,635485,117870,620928,662239,425952,46740,123624,1011460,503127,476440,956368,571810,952633,851301,23092,443387,7900,459819,797006,958933,559925,715979,518851,540602,955865,70769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012887 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012887 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000869s ]