SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013040 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013040 [ RunTime:0.001993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485321,867495,343098,689913,821798,685872,486193,429449,884112,998554,69434,217215,766061,487667,230997,295055,912366,32315,964215,971874,172644,132379,569039,886986,40363,685619,43484,889180,707412,275069,1025260,508946,516508,172301,268838,435940,98717,1036168,1021527,648397,113512,672235,847331,965920,989402,42430,262186,513313,309642,226565,596038,972451,601161,120500,627895,672412,812385,611141,141622,792337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]