SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466470 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466470 [ RunTime:0.001982s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (729043,825332,615707,900272,55140,538378,902879,283914,890550,845227,28841,199355,585826,328562,7804,432587,690755,77937,26375,873989,27772,440135,455016,224031,736835,862148,62648,440433,785691,501331,386110,257094,39807,277546,422393,496822,1032165,995186,861978,692926,20503,872188,865382,471353,276505,1046982,740077,697089,325725,350180,202757,53171,948672,701030,974346,280648,1025387,428478,837261,177112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]