SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001534s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491002 LIMIT 1 [ RunTime:0.001051s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491002 [ RunTime:0.002887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (255217,330104,187859,612564,425308,228484,365077,265109,637385,1032005,692182,320286,906164,977728,467065,763526,321691,941989,301408,810038,440214,807150,278118,729543,124931,1008984,72934,356805,55637,704990,966931,725257,450961,1017408,964191,367385,415229,403036,854718,64951,976154,267126,702877,130314,279156,120333,238278,228578,690646,1037866,693050,861392,611504,907482,460918,943077,368391,659153,256338,1038891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]